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
- 5606 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
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what functionality does oracle provide to secure sensitive information?
which background process invoke at the time of upgradation tell me???
Which autogrowth database setting is good? : sql server DBA
how can you connect from 10g user to 11g user??
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
how can you record information about current session?
what are the performance views in an oracle rac environment?
how can you get actual data change values from previous transactions in oracle?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
