Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6807 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 spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What authentication modes does sql server support? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
What would you do with an "in-doubt" distributed transaction?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What is transparent data encryption? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how can you get actual data change values from previous transactions in oracle?
What are the recovery models for a database? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What happens on checkpoint? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
