1. how do you delete duplicate rows in a table?
2. can you disable and enable primary key?
3. how do you move tables from one tablespace to another
tablespace?????
- 2 Answers
- 6060 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / mohapatra.gouranga@gmail.com
1. DELETE FROM table_name A WHERE ROWID > (SELECT min
(rowid) FROM table_name B WHERE A.key_values =
B.key_values);
2. can you disable and enable primary key?
Yes,
e.g., alter table EHIS.HIPARTRANSACTIONDETAILS DISABLE
constraint FK_HIPAR_TRANS
3. how do you move tables/indexes from one tablespace to
another tablespace?
ALTER TABLE <schemaname.tablename> MOVE TABLESPACE
<tablespace_name>;
alter index <owner.indexname> rebuild online tablespace
<target_tablespace_name>;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the commands you'd issue to show the explain plan for "select * from dual"?
What purpose does the model database server? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
What is the importance of a recovery model? : sql server DBA
Explain materialized views and how they are used.
What the different types of replication and why are they used? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the recovery models for a database? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
who owns the operating system files created by the utl_file package?
how can a session indicate its interest in receiving alerts?
What are statistics, under what circumstances they go out of date, how do you update them?
What is the difference between dropping a database and taking a database offline? : sql server DBA
