| Improve Import /Export process of Large database. [message #72837] |
Thu, 13 November 2003 17:58  |
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 #72840 is a reply to message #72838] |
Fri, 14 November 2003 06:41  |
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 |
 |
Mahesh Rajendran
Messages: 10707
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
