Home » RDBMS Server » Server Utilities » Improve Import /Export process of Large database.
Improve Import /Export process of Large database. [message #72837] Thu, 13 November 2003 17:58 Go to next message
Sujath.
Messages: 2
Registered: November 2003
Junior Member
Hi,
I am importing very large database (180gb),
currently its taking around 45 hrs to complete the whole import process.

Its Oracle 9.2.0.3 release.

Please suggest how can i cut down that time?

Thanks in advance.

Thanks,
Sujath
Re: Improve Import /Export process of Large database. [message #72838 is a reply to message #72837] Fri, 14 November 2003 05:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try increasing the BUFFER and RECORDLENGTH
Re: Improve Import /Export process of Large database. [message #72840 is a reply to message #72838] Fri, 14 November 2003 06:41 Go to previous messageGo to next message
Sujath.
Messages: 2
Registered: November 2003
Junior Member
Mahesh,
Thanks for the response.
How about adding below 2 more items?

Commit=N.
INDEXFILE = file location.
Pre-create the tables without the indexes, load the data, and then create the indexes. Use the INDEXFILE parameter to help in index creation.

Pls give your suggestion.

Thanks,
Sujath
Re: Improve Import /Export process of Large database. [message #72842 is a reply to message #72840] Fri, 14 November 2003 13:48 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
INDEXFILE = file location  has nothing to do with indexes.
it will just dump the ddl of the to-be-imported tables and indexes.
if was assuming that, u are loading the data without any indexes ( becuase , it is the standard practise).
so disable the indexes (in 9i) or drop the indexes (8i)
and load the data and recreate the indexes.

COMMIT=N gives the preset for commits. it is good, if the records are not commited too frequently.

But first try the other options and then, we can look into this.

Previous Topic: creating a flat file
Next Topic: Loading EBCDIC Data using SQL Loader
Goto Forum:
  


Current Time: Tue Dec 24 20:37:42 CST 2024