Home » RDBMS Server » Server Utilities » Import error
Import error [message #70411] Tue, 11 June 2002 07:58 Go to next message
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 #70412 is a reply to message #70411] Tue, 11 June 2002 08:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try again using this syntax
d:IMP80 USERID=blankblank TABLES=table1 IGNORE=Y COMMIT=Y
Re: Import error [message #70821 is a reply to message #70411] Sun, 28 July 2002 06:51 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #380942 is a reply to message #380940] Wed, 14 January 2009 03:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Reduce your buffer size.

Regards
Michel
Re: Import error [message #381016 is a reply to message #70411] Wed, 14 January 2009 18:47 Go to previous messageGo to next message
wille
Messages: 2
Registered: January 2009
Junior Member
how much should i reduce?
Re: Import error [message #381036 is a reply to message #381016] Wed, 14 January 2009 23:26 Go to previous message
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
Previous Topic: Migrating Oracle Database from Windows to Linux
Next Topic: SQL*Loader: Loading fixed-length file to table with VARRAY
Goto Forum:
  


Current Time: Tue Nov 12 23:00:51 CST 2024