Hi,
Need to re-create all tables and re-create (no data) with ROWDEPENDENCIES option.
Approx 300+ tables.
Problem :
1. When dropping tables (all data truncated first), had to run drop table script a few
times in order to drop all tables.
2. When doing table creation, tables having foreign key on tables not created yet throws
ORA-00942 table or view does not exist.
3. Unable to disable all constraints as about 40% of constraints are disabled and when
enable all constraints, unable to disable back the 40% disabled ones unless doing it
manually. (Have many databases to be upgraded after testing )
Questions :
1. How to disable constraints during tables drop/creation and enabling after creation ?
( like using imp, creating tables alphabetically and enabling enable constraints and
leave disabled ones alone. )
Thanks in advance
Zack