Hi RF ,
export is Fairly straight forward .
1.Use direct export
2.Use parallel export processes . Run your biggest
table export first and fire off other exports
simultaneously . Take a look at parallel download
script at
http://www.oriole.com/frameindexTK.html
Now import is another kind of beast .
Import :
SERVER SIDE
1.Increase SGA as much as possible with out paging
and if possible lock it in physical memory .
2. Create Large redo log files > or = 3
3. No archivelog mode
4.Depending on number of parallel Exp/Imp process ,
create the same number of large rollback segs and
bring them on line ( keep other normal ones offline )
5.Precreate empty objects . Make all tablespace
nologging and all tables nologging .
6. Disable all FK and PKs
7. Drop all indexes if you have already created them .
8. drop all triggers .
9. Finally ( I hope..!! ) run import with commit=N.
Remember to fix all this when import is over . Hope
this helps .
Regards,
RS
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raj Sakthi
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).