Home » RDBMS Server » Backup & Recovery » import error ORA-01552
import error ORA-01552 [message #175340] Thu, 01 June 2006 16:28 Go to next message
SLKRR
Messages: 11
Registered: May 2006
Location: Recife, Brasil
Junior Member
I am trying to import data into a 9.2 database that was exported from an 8.1.7 database. The attempt to import keeps running up against the following error:

ORA-01552 cannot use system rollback segment for non-system tablespace

This happens whether I try to import using full=y or using fromuser. If I go into OEM and try to create a public or private rollback segment (as most FAQs seem to recommend), I receive exactly the same error.

Any ideas what to try next?

Report message to a moderator

Re: import error ORA-01552 [message #175343 is a reply to message #175340] Thu, 01 June 2006 16:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
In 9i, you are supposed to use UNDO segments.
Create an undo tablespace in 9i with proper UNDO_RETENTION and then import

Report message to a moderator

Re: import error ORA-01552 [message #175345 is a reply to message #175343] Thu, 01 June 2006 16:43 Go to previous messageGo to next message
SLKRR
Messages: 11
Registered: May 2006
Location: Recife, Brasil
Junior Member
The database into which I am trying to import the data already has an undo tablespace called "UNDOTBS1" - what settings does it need to have in order to be "proper"?

Report message to a moderator

Re: import error ORA-01552 [message #175346 is a reply to message #175345] Thu, 01 June 2006 16:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Start here
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/undo.htm#8888
Make sure you have UNDO_MANAGEMENT=AUTO

Report message to a moderator

Re: import error ORA-01552 [message #175347 is a reply to message #175346] Thu, 01 June 2006 16:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And search the forum for UNDO_RETENTION
Make sure you are using 8i version of import to import into 9i database.
Else
You need to install 8i version exp/imp views inside the 9i database by running catexp.sql

[Updated on: Thu, 01 June 2006 17:00]

Report message to a moderator

Re: import error ORA-01552 [message #175468 is a reply to message #175347] Fri, 02 June 2006 07:07 Go to previous messageGo to next message
SLKRR
Messages: 11
Registered: May 2006
Location: Recife, Brasil
Junior Member
I need to use 8i version of import? That could be the problem. I have been using the 9i version. I will try that, then. Setting UNDO_MANAGEMENT to MANUAL or AUTO returned the same error on import.

Report message to a moderator

Re: import error ORA-01552 [message #175513 is a reply to message #175340] Fri, 02 June 2006 10:03 Go to previous messageGo to next message
SLKRR
Messages: 11
Registered: May 2006
Location: Recife, Brasil
Junior Member
Import 8i does not want to run against the 9i database -- it is giving an ORA-00058 error.

Report message to a moderator

Re: import error ORA-01552 [message #175516 is a reply to message #175513] Fri, 02 June 2006 10:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Posting the commands you used and exact/complete error message may be useful.
You must be doing a full import.
Use fromuser/touser

Report message to a moderator

Re: import error ORA-01552 [message #175518 is a reply to message #175340] Fri, 02 June 2006 10:20 Go to previous messageGo to next message
SLKRR
Messages: 11
Registered: May 2006
Location: Recife, Brasil
Junior Member
/store2/u01/app/oracle/product/8.1.7/bin/imp cellplan/***** file=/store1/CTS2.dmp fromuser=cellplan

(The **** is the password) I get the same error using either fromuser or full=y.

The error is actually "IMP-00058:" without any accompanying error message at all.

The previous errors ORA-01552 with regard to the rollback segments all occurred at the time of the create table statements during the import. Is there some reason why creating a table would trigger this?

Report message to a moderator

Re: import error ORA-01552 [message #175521 is a reply to message #175518] Fri, 02 June 2006 10:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
The idea is,
Use the lower version of exp to export and same lower version of imp to import (exp using 8i and imp using 8i).
or
install 8i version of exp/imp views into a 9i database,by runnig catexp.sql of 8i version against 9i database.
Before doing this,in the target database first
precreate the user(No resource role), assign the default tablespaces,allocate quota.
Set your UNDO_MANAGEMENT to auto.
Then, do the import.

PS:
Your posts are very contradicting.
In previos post you said
>> it is giving an ORA-00058 error.
Now you are saying The error is actually "IMP-00058:"

Report message to a moderator

Re: import error ORA-01552 [message #175522 is a reply to message #175521] Fri, 02 June 2006 10:43 Go to previous message
SLKRR
Messages: 11
Registered: May 2006
Location: Recife, Brasil
Junior Member
>> Your posts are very contradicting.
>> In previos post you said
>>>> it is giving an ORA-00058 error.
>>Now you are saying The error is actually "IMP-00058:"

Yes, I was making a correction - what I said before was wrong.

Report message to a moderator

Previous Topic: RMAN error ORA 27603
Next Topic: import using wild card?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 18:53:56 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.