If you are NOT using AUTO UNDO MANAGEMENT, then please try the following: CREATE ROLLBACK SEGMENT SYS_TEMP TABLESPACE SYSTEM; ALTER ROLLBACK SEGMENT SYS_TEMP ONLINE; then; Create your rollback segments--- then you can drop the SYS_TEMP rollback segment. HTH Regards Chandra On Tue, 28 Dec 2004 13:01:30 +0530, Abraham Kurian <kurian24@xxxxxxxxx> wrote: > I think you have Undo Management set to AUTO > > Regards > Kurian > > On Mon, 27 Dec 2004 14:57:58 -0800 (PST), Nisar Tareen > <ntareen@xxxxxxxxx> wrote: > > Laly, > >=20 > > Your question dose not match to the problem you had mentioned, Do you r= > eally understand that what is cloning of Database, It means exact copy of = > your production and import is not the part of Cloning senario. > >=20 > > Looking at the problem it looks like you do not have RBS tablespace. > >=20 > > Nisar Tareen > >=20 > > Laly <lspel@xxxxxxxxx> wrote: > >=20 > > Hi All > > i am cloning a productive database in another server. > > This new database (9i) has problems when i run the import. > > The import gives errors because i haven't created the rollback segments a= > nd the database has the system tablespace as the rollback seg. > >=20 > > SQL> SELECT SEGMENT_NAME, TABLESPACE_NAME, FILE_ID,STATUS from dba_rollba= > ck_segs; > > SEGMENT_NAME TABLESPACE_NAME FILE_ID STATUS > > -------------------------------------------------------------------------= > -------------------------------- > > SYSTEM SYSTEM 1 ONLINE > >=20 > > So, when i try to create a rollback seg for the RBS tablespace, i receved= > the following error: > >=20 > > SQL> CREATE ROLLBACK SEGMENT RBS01 TABLESPACE RBS > > STORAGE > > (INITIAL 5M > > NEXT 5M > > MINEXTENTS 4 > > MAXEXTENTS 32765); 2 3 4 5 6 > > CREATE ROLLBACK SEGMENT RBS01 TABLESPACE RBS > > * > > ERROR at line 1: > > ORA-01552: cannot use system rollback segment for non-system tablespace '= > RBS' > >=20 > > How can i fix this problem ? > > Please, anyone can help me? > > Thanks in advance, > >=20 > > Laura > >=20 > > --------------------------------- > > Do you Yahoo!? > > The all-new My Yahoo! =E2=80=93 Get yours free! > >=20 > > [Non-text portions of this message have been removed] > >=20 > > ------------------------ Yahoo! Groups Sponsor --------------------~--> > > $4.98 domain names from Yahoo!. Register anything. > > http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/67folB/TM > > --------------------------------------------------------------------~-> > >=20 > >=20 > > Yahoo! Groups Links > >=20 > > <*> To visit your group on the web, go to: > > http://groups.yahoo.com/group/dba_gurus/ > >=20 > > <*> To unsubscribe from this group, send an email to: > > dba_gurus-unsubscribe@xxxxxxxxxxxxxxx > >=20 > > <*> Your use of Yahoo! Groups is subject to: > > http://docs.yahoo.com/info/terms/ > >=20 > > --------------------------------- > > Do you Yahoo!? > > Dress up your holiday email, Hollywood style. Learn more. > >=20 > > > > -- Regards, Chandra Pabba OCP, SCSA