-
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????
-
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
I remember when this place was cool.
-
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...
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|