import existing table how to enable the constraints etc...
VPSOct 29 2008 — edited Oct 29 2008Friends,
OS: RHEL AS 3
DB: 9iR2
I have exported one table from production because i added a new column with data in that table.
Now i want to import that table in the test. But, this table is already exists in the test.
for that i will drop the table with cascade option.
1. what should i do before dropping the table. i mean what i have check for the dependents and constraints and how?
2. after importing what should i do for enabling dependents and constraints?
thanks