[askdba] Re: [dba_gurus] ORA-01552 - cannot create a rollback segment
- From: Chandra Pabba <chandra.pabba@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Tue, 28 Dec 2004 14:42:26 +0530
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
Other related posts:
