Hello Friends
My query is pretty long
I have a table 'COMPANY' which is a master table and a lot of other table depend on it (That way a lot of constraints)
Now if I want to recreate this table witout affecting data.
I want to do this bcos of in order to modify order of the fields and also to add some columns. Oracle Doesnt allow you to drop table as other table depend on it.
If I create the DUMMY table with
'CREATE TABLE COMPANY_TEMP AS
SELECT * FROM COMPANY'
it will create the tables with data but it will not copy the constraints. And Also the original table cannot be dropped. Therefore
1) How can I recreate table with Constrains same as previous
table ?
2) How can I drop the Table like this without disabling each
and every constraint
Thanks in Advance
Amol [sig][/sig]
My query is pretty long
I have a table 'COMPANY' which is a master table and a lot of other table depend on it (That way a lot of constraints)
Now if I want to recreate this table witout affecting data.
I want to do this bcos of in order to modify order of the fields and also to add some columns. Oracle Doesnt allow you to drop table as other table depend on it.
If I create the DUMMY table with
'CREATE TABLE COMPANY_TEMP AS
SELECT * FROM COMPANY'
it will create the tables with data but it will not copy the constraints. And Also the original table cannot be dropped. Therefore
1) How can I recreate table with Constrains same as previous
table ?
2) How can I drop the Table like this without disabling each
and every constraint
Thanks in Advance
Amol [sig][/sig]