-
import taking time
Hi,
i am taking 8.0.3 database i plan to create a new database on 8.1.6 . for this i take export of our existing database with rows=n,grants=y,consistent=y index=y,user=user_name
and now when i am taking import (using import utility of 8.1.6)from this dump file on my new datadabse(8.1.6) i am having a problem of slowness.
my import taking too much time.
I have left it for more then 12 hrs but it is not going to complete. any help in this regard please ....
my dump file contains around 2000 tables 3000 procedures and 3000 funtions etc.
[Edited by pravesh on 10-16-2001 at 08:29 AM]
-
Do not use CONSISTENT=Y if volume of data is high.
Improve performance by allocating large buffer size and using DIRECT=Y.
Do not use compress=y if there are many deleted rows.
All the best!
-
-
He said that import is slow. DIRECT=Y is not valid in IMP!
DIRECT is an EXP parameter.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|