Re: IMPORT - how many passes?

Walt <walt_at_boatnerd.com> wrote in message news:<3FA83408.B4870E9B_at_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! )

I've found what Brian says is exactly right. I have seen unmanaged UNDO fail sometimes when it succeeds others, with nearly the same data. I'm simply precreating the users and tablespaces, then I just use a normal command line user mode imp. Of course, I would do more were it a production system, since I'm going from a system with, er, "older stylings" in some of its management... :-)

jg

--
@home.com is bogus.
http://www.potaroo.net/ispcolumn/2003-07-v4-address-lifetime/ale.html