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?????
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / anil kumar prajapati
1. DELETE FROM
table_name A
WHERE
a.rowid >
ANY (
SELECT
B.rowid
FROM
table_name B
WHERE
A.col1 = B.col1
AND
A.col2 = B.col2
);
2.CREATE TABLE table_name
(
column1 datatype null/not null,
column2 datatype null/not null,
...
CONSTRAINT constraint_name PRIMARY KEY (column1, column2,
... column_n)
);
3.ALTER TABLE <TABLE NAME to be moved> MOVE TABLESPACE
<destination TABLESPACE NAME>
Is This Answer Correct ? | 0 Yes | 0 No |
how can you process messages in order asynchronously?
How would you go about increasing the buffer cache hit ratio?
what functionality does oracle provide to secure sensitive information?
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Oracle 11g new features?
what are the differences of where and if in SAS?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
How to make a replica of existing oracle server to another server?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What view would you use to look at the size of a data file?
How do you resize a data file?