| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: IMPORT - how many passes?
Brian Peasland wrote:
> > Are you saying that I can create an Oracle 9.2 database, drop all the
> > users except for sys and system, and then simply run import with full=y
> > using a dmp file that's a full export from 8.1.6?
> >
> > This sounds too easy.
>
> It's pretty much that easy.
Any fancy stuff going on in the parfile? Or can you post an example?
>
> Yes...it's pretty much that easy. You may have a few more "wrinkles" to
> sort out, like making sure you have enough UNDO or rollback space to
> import a large table.
I think I'm ok on space as I've been able to get an import to go through (with difficulty - I've got a 60Meg logfile of errors! )
-- //-Walt // //Received on Tue Nov 04 2003 - 17:19:36 CST
![]() |
![]() |