RE: Steps to move schema data from one database to another

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 13 Sep 2005 14:00:38 -0400
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF41050395BABF@usahm236.amer.corp.eds.com>

J, if you want to use the source database values for the sequences and they already exist in the target database I think you will want to drop them prior to import. I would expect private synonyms are already set up the way you will want them but if you are doing a user export public synonyms will not be part of the import. You will have to re-create them if they do not already exist in the target db.

If FK constraints exist in the target db I would drop them and let Oracle re-create them during the import otherwise you could have table loads error off and have to go back and fix data.

If any of the target tables are large then depending on the index definitions you might need to use commit=y on the import depending on how your rollback segments are configured.

Just so things to think about.
-- Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J. Dex Sent: Tuesday, September 13, 2005 1:39 PM To: oracle-l_at_freelists.org
Subject: Steps to move schema data from one database to another

Does anything have to be done with the pre-existing sequences or synonyms, triggers or foreign keys when moving data from one database into another database under the same user/schema name?

I have a schema in Database A that has data in it. I want to truncate the data leaving the table definitions, etc in Database A. Then I want to take an export from Database B and import it into Database A using ignore=y. Is there anything else that I need to do?

Haven't done this in ages and I am afraid I feel like I am skipping some steps if I just try and import using ignore=y.

This is a 9206 database.

Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 13 2005 - 13:03:08 CDT