-
Hello Friends:
I am importing a dump file, while do so I come across one table in my database which has 85000 records in it. At this stage it takes hell lot of time for importing, and later on gets hanged. Somebody told me that I can solve this problem by increasing the size of rollback segment. Is is true? if yes explain me step by step how to increase it. If no then give me the solution.
Bye.
Marjo.
-
Are you sure that your import is failing because of Rollback? Do you get any error message?
Try import with commit=y, this will prevent rollback segment swelling.
Sanjay
-
hi Trusted4u,
i had the same problem, and it turned to be that the datafile i'm importing into is full, check if this is the case you have.
if this is the case, and you don't have any disk space limititions then turn it into Autoextend.
Best Regards.
-
Be sure to check you alert.log to see if there are any errors that have been logged.
cheers
OCP 8i, 9i DBA
Brisbane Australia
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
|