Re: Simple questions about Import/Export

Hi Rick,

I use the Exp and Imp utilities to do the same things you're trying to do.

If you want to synchronize your PROD and TEST instances, you can do an export of PROD, and then import it into your TEST instance. When you do an import, the existing data in your TEST instance will get over-written. So you don't have to erase anything from TEST before the import.

But when you do the import, be sure to set the IGNORE parameter to "Y." The reason is because the Imp utility creates all the objects that you have in your PROD database in your TEST database. If some of the objects are already there in TEST, Imp cannot create another one with the same object name, and will throw an error. But if you set IGNORE=Y, then Imp will reuse that existing object and insert the necessary data into that object, overwriting any pre-existing data (thus, you don't have to erase anything before doing an import.) Your data will come out in synch between the 2 databases.

Another good thing about doing export/import of your databases routinely is that when you do an export, the extents get coalesced. So it saves you some work in tuning.

Ally Cheung
http://resumes.yahoo.com/firenze95/dba

BTW, I'm a junior DBA currently looking for work. Any leads in DBA positions would be greatly appreciated! Received on Sun Oct 14 2001 - 01:43:25 CEST