exp/imp

[learning_bee]

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

[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????

[Mr.Hanky]

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

[gandolf989]

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.

[jmodic]

Check the RLS method suggested in this thread...