exp/imp

If I have about 500 tables in the schema, how can I move these 500 tables to different schema with this condition: we only want 100 tables out of this 500 with data and the rest without data, and we don't want to do the full exp/imp with data and then truncate the data b/c this may cause FK violation.

Any thoughts???

thanks

Here is the approach I have in mind but I am not sure this is the best approach so please give me your opinion:

1. do a full export with no data
2. export the 100 tables with data.
3. do a full import to the new schema.
4. import the 100 tables with ignore=y

any other thoughts????

Quote:

---

Originally posted by learning_bee
Here is the approach I have in mind but I am not sure this is the best approach so please give me your opinion:

1. do a full export with no data
2. export the 100 tables with data.
3. do a full import to the new schema.
4. import the 100 tables with ignore=y

any other thoughts????

---

Sounds good to me but..

You may want to save the index builds for last, after the data is loaded.

No?

MH

How about export the 100 tables that need data but do it with indexes=n and constraints=no.

then do a full export with indexes and constraints but no data.

import the export with the data.

then do the other import with ignore=y?

or you can just restore you latest backup to the new server and truncate the tables that need truncated.

Check the RLS method suggested in this thread...