Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: IMPORT - how many passes?

Re: IMPORT - how many passes?

From: Walt <walt_at_boatnerd.com>
Date: Tue, 04 Nov 2003 18:19:36 -0500
Message-ID: <3FA83408.B4870E9B@boatnerd.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US