RE: Steps to move schema data from one database to another
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 Sep 2005 14:00:38 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of J. Dex
Sent: Tuesday, September 13, 2005 1:39 PM
To: oracle-l@xxxxxxxxxxxxx
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/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
