Re: Making sure all objects moved

From: Thomas Fox <belvdr_at_yahoo.com>
Date: Thu, 17 Nov 2005 06:56:42 -0800 (PST)
Message-ID: <20051117145642.70633.qmail@web32411.mail.mud.yahoo.com>

In regards to commit=y, there is a discussion regarding the amount of undo that is needed. Tom Kyte gave one answer, while the Oracle 9i docs gave a different answer.

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:230214032357

My question to Tom, and his reply with an example, is near the bottom. Just search for "Tom Fox from Cinti, OH".

Tom

Jared Still <jkstill_at_gmail.com> wrote:

> Use the 'log=<filename>' option, then examine the log file for errors.
>
> I like to use the following parameters - your mileage may vary.
>
> buffer=10485760 - 10 meg buffer. You can use bigger, but
> my wholly unscientific (empirical) method has found there
> doesn't seem to be much benefit to larger than 10m.
> Could be influenced by platform, available memory, etc.
>
> commit=y - Commits the data every time the buffer fills.
> easier on UNDO resources if it is a large import.
> Some imports should not be done this way, appending
> data for instance. ( not fun to fix if the imp dies part way through,
> after 1+ commits)
>
> Importing into an empty schema should be fine.
>
> ignore=y depends on what errors you are trying to ignore.
> eg. There may be object grants in the export file. These cause
> errors if the grantee is not in the new database.
>
> statistics=n I prefer to generate them in the new database.
> May be import if there are minor version differences. If you
> don't like the generated stats, you can always export the
> stats and import into the new database.
>
> indexes: Y if a small import - N if a large one. It is faster
> to build the indexes yourself after the import with 2+
> sqlplus sessions.
>
> recordlength=65536 - platform dependent. on 32 bit Intel
> boxes it maxes out at 64k.
>
> grants=n - only if absolutely none of the grants should be imported.
>
> HTH
>
> Jared
>
>
> On 11/17/05, Nirmalya Das <nirmalya_at_hln.com> wrote:
> >
> > I have an "export" for an Oracle 8.1.7.4 <http://8.1.7.4>
> > I am "importing" it into an Oracle 10g database.
> > What is the best way to make sure all the objects imported correctly?
> > I usually have problems with "synonyms".
> > What are the proper switches to use while import?
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 17 2005 - 10:00:34 CST