Home » RDBMS Server » Server Utilities » Import Problem
Import Problem [message #72880] Sat, 29 November 2003 10:53 Go to next message
Ali
Messages: 88
Registered: March 2000
Member
Dear All ,
I need your help in the following message :

Connected to:
Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production With the Partitioning option
PL/SQL Release 8.0.4.0.0 - Production

. . importing table "XXXXXXXXXXXXX"
IMP-00058: ORACLE error 1562 encountered
ORA-01562: failed to extend rollback segment number 5
ORA-01562: failed to extend rollback segment number 5
IMP-00028: partial import of previous table rolled back: 101909 rows rolled back
About to enable constraints...
Import terminated successfully with warnings.

Regards,
Ali
Re: Import Problem [message #72882 is a reply to message #72880] Sat, 29 November 2003 16:46 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9101
Registered: November 2002
Location: California, USA
Senior Member
Please see the following excerpt from Oracle on-line documentation:

ORA-01562 failed to extend rollback segment number string

Cause: Failure occurred when trying to extend rollback segment.

Action: This is normally followed by another error message that caused the failure. You may take the rollback segment offline to perform maintenance. Use SELECT SEGMENT_NAME FROM DBA_ROLLBACK_SEGS WHERE SEGMENT_ID=string (where string is the segment number from the message) to determine the rollback segment name. Then use the ALTER ROLLBACK SEGMENT OFFLINE command to take the rollback segment offline.
Re: Import Problem [message #72900 is a reply to message #72880] Fri, 05 December 2003 04:51 Go to previous message
naveen dutt
Messages: 8
Registered: December 2003
Junior Member
Hi,
This problem occurs while you run import utility rollback segments fulls and didn't shrink ,
1. add more rollback segments
2. in init file increased rollback_segments

then try

Naveen dutt
Previous Topic: import query help
Next Topic: Best Practices for temporary tablespace(s)
Goto Forum:
  


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