Re: IMPORT - how many passes?

> Any fancy stuff going on in the parfile? Or can you post an example?

My export params typically look as follows:

exp userid=system/manager file=exp.dmp log=exp.log full=y

In the new database, precreate your tablespaces, then issue the following:

imp userid=system/manager file=exp.dmp log=imp.log full=y

Nothing really fancy going on here. Since you did a full export, all users, grants, constraints, objects, everything will get created for you on import so long as you do the full import as well. If you had objects in the destination database that you want to replace on import, make sure you drop them first.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"