import error

[prodadmin]

hi ,

when i am importing i am getting the following error

RA-01552: cannot use system rollback segment for non-system tablespace 'TS_DATA_DISTR'
IMP-00017: following statement failed with ORACLE error 1552:

Pls help me

[bhallar]

Need few information
a) Exact syntax u r using.
b) Are u importing into different version of target Database or both are same.

-Ravinder

[jmodic]

You only have a SYSTEM rollback segment online on your database. You need at least one non-SYSTEM rollback segment for any work to be done. So you have to put some of your other rollback segments online. If you haven't had created any rollback segments on that database yet, you'll have to create them first, of course.

[prodadmin]

here is the info:

A. imp usn/pwd file=abc.dmp log= mylog.log Fromuser=db1 Tosuer=db2
b. no it's same version.Yesterday i did for few tables ..didn't got any issues but i am importing 3 tables same db , it gave the error


thanks

[prodadmin]

when i try to create a roll back segment

i am getting the following error

cannot create a rollback segment in tablespace with auto space management

[jmodic]

Originally posted by prodadmin
when i try to create a roll back segment

i am getting the following error

cannot create a rollback segment in tablespace with auto space management

So? The error message says it all, doesn't it?

[Suman Thummala]

What version of oracle are you using?
If you are using 8i, create a rollback segment tablespace( If you dont have any). Create rollback segments and make it online and try importing.

[bhallar]

Are u using 9i
Pls send the ouput of the following query

select owner,segment_name,tablespace_name from dba_rollback_segs order by 3;

Also
SQL> show parameter undo

select TABLESPACE_NAME, CONTENTS, EXTENT_MANAGEMENT, ALLOCATION_TYPE, SEGMENT_SPACE_MANAGEMENT from dba_tablespaces where contents='UNDO';

[julian]

Originally posted by Suman Thummala
What version of oracle are you using?
If you are using 8i, create a rollback segment tablespace( If you dont have any). Create rollback segments and make it online and try importing.

Obsviously he is not using 8i. You cannoy have auto space management tablespaces in 8i.

I suggest you craete undo segments (AUM), not RBSs.

[pando]

well you cannot create undo segments, it´s crated by Oracle internally