Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IMPORT - how many passes?
"Brian Peasland" <dba_at_remove_spam.peasland.com> schrieb im Newsbeitrag news:3FA92120.167B1F56_at_remove_spam.peasland.com...
> > 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.
Ok, but what happens to the SYS and SYSTEM schemata of
the database I'm importing into? and the performance views and all
that stuff?
And what requirements must that database fulfil? Is the "create database" statement enough or must I run catalog.sql too?
Lots of Greetings!
Volker
Received on Wed Nov 05 2003 - 10:29:33 CST