Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IMPORT - how many passes?
Brian Peasland wrote:
>
> > > Why not do export with FULL=Y and import with FULL=Y? This is only one
> > > pass and gets everything.
> >
> > Several reasons, the principal one being that it won't work.
>
> Can you elaborate *why* it won't work? I've done many, many refreshes of
> a development or test database with production data and doing a FULL
> export and a FULL import has always worked for me. Why won't it work for
> you?
Well, for one, I'm moving the data from 8.1.6 to 9.2. Wouldn't a full import overwrite the data in the system and ctxsys tables (and some others)?
Also, wouldn't I get a boatload of errors as foreign keys fail to find their parent records, grant statements fail to find the referenced objects, views fail to find their underlying tables, etc.
I can see a full import working if it's done just the right order, but I don't see how to guarantee it.
In any case, I did try a full import at first, but everytime I tried it the import process would hang. Others here suggested importing just the application data, so that's the path that I'm on now. If there's an easy way to just import the whole thing at once I'd be more than happy to use it.
-- //-Walt // //Received on Tue Nov 04 2003 - 13:40:15 CST