Import error [message #70411] |
Tue, 11 June 2002 07:58 |
Steve
Messages: 190 Registered: September 1999
|
Senior Member |
|
|
I am trying to import a table with 45,000 rows from one server to another in Oracle8. I've exported the table, and when I try and reimport, using this command:
d:IMP80 USERID=blankblank TABLES=table1 IGNORE=Y
IMP-00058: ORACLE error 1562 encountered
ORA-01562: failed to extend rollback segment number 15
ORA-01650: unable to extend rollback segment R111 by 256 in tablespace RBS1
IMP-00028: partial import of previous table rolled back: 441 rows rolled back.
What is this message stating, and how do I get the import to work correctly?
|
|
|
|
Re: Import error [message #70821 is a reply to message #70411] |
Sun, 28 July 2002 06:51 |
Henner C. Dierks
Messages: 1 Registered: July 2002
|
Junior Member |
|
|
Thanks,
I had the same problem with a table containing more than 1,000,000 lines. No matter how hard I tried, the rollback-segments tablespace was always too small until I went out of Diskspace.
'commit=y' really saved my day!
|
|
|
Re: Import error [message #70993 is a reply to message #70411] |
Sat, 24 August 2002 03:58 |
Ayyappan
Messages: 2 Registered: November 2001
|
Junior Member |
|
|
I tried to import the dump file in oracle 7.3 user.
The error messge i received is :-
ORA-1562 - failed to extend Rollback segment RB2.
then i created a new Rollback segment with Value 242 instead of 121.
after that i received the above same messge with
failed to extend Rollback segment RB4.
My question is Should i change the RB4 or to create new Rollback segment ?
or What to do ?
|
|
|
Re: Import error [message #70997 is a reply to message #70411] |
Mon, 26 August 2002 01:45 |
K.K. Raj kumar
Messages: 33 Registered: July 2002
|
Member |
|
|
Dear Friend,
You should set the Parameter commit=y, so that Oracle will commit the Records after the BUFFER Size is full.
You got the error though adding RB4 because You cannot make Oracle to use RB4 which importing because this is set by Oracle on a Round robin basis.
eg is
imp / FILE=abc.dmp TABLES="(abc)" IGNORE=Y GRANTS=Y INDEXES=Y ROWS=Y COMMIT=Y FULL=N
|
|
|
Re: Import80 error code 1950 [message #71767 is a reply to message #70411] |
Wed, 08 January 2003 04:15 |
Andreas Semmel
Messages: 1 Registered: January 2003
|
Junior Member |
|
|
Hello,
I have got the abouve mentioned error code while trying to import an former exportet data base into a newly generated db under oracle 8.0.
the commande i used was: imp80 login/password fromuser=comp1 touser=comp2 log=logs9.txt buffer=40000 commit=y file=e:dumpnameformerexport.dmp
Any idear? The error message says that i don't have the privilege to acces the storage space of comp2.
Andreas
|
|
|
Re: Import error [message #380940 is a reply to message #70411] |
Wed, 14 January 2009 03:32 |
wille
Messages: 2 Registered: January 2009
|
Junior Member |
|
|
Hi,
i facing an import error too:
i use the command
imp80 name/password buffer = 50000000 file = 14012009.dmp
fromuser = test touser = test log = 140109.log analyze = n
commit = y feedback = 1000
the error message i get is:
IMP - 00058 : ORACLE error 1562 encountered
ORA - 01562 : failed to extend rollback segment number2
ORA - 01628 : max # extents (512) reached for rollback segment RB1
IMP - 00028 partial import of previous table rolled back : 107926973 row rolled back
help, any solution?
[Updated on: Wed, 14 January 2009 03:34] Report message to a moderator
|
|
|
|
|
Re: Import error [message #381036 is a reply to message #381016] |
Wed, 14 January 2009 23:26 |
|
Michel Cadot
Messages: 68712 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
From your error message: less than 107926973 * average size of a row.
Regards
Michel
|
|
|