Home » RDBMS Server » Server Administration » Illegal rollback Segment operation in Automatic Undo mode
Illegal rollback Segment operation in Automatic Undo mode [message #63423] Mon, 04 October 2004 08:13 Go to next message
gurinder
Messages: 16
Registered: September 2004
Junior Member
WHEN I Tried to create a roll back segment it gives me this error

CREATE ROLLBACK SEGMENT R1 TABLESPACE btrRollback01 storage (Initial 52K NEXT 52K MINEXTENTS 2)
*
ERROR at line 1:
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

can u please tell me what should i do to create rollback segment
Thanx Gurinder

Report message to a moderator

Re: Illegal rollback Segment operation in Automatic Undo mode [message #63427 is a reply to message #63423] Mon, 04 October 2004 11:53 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Hi,

If your database is running in Automatic Undo mode, it will create and drop its own rollback segments (called undo segments) depending on demand. You can safely ignore this error or set the "UNDO_SUPPRESS_ERRORS" parameter to TRUE to ignore it.

Best regards.

Frank

Report message to a moderator

Re: Illegal rollback Segment operation in Automatic Undo mode [message #63431 is a reply to message #63423] Mon, 04 October 2004 12:01 Go to previous message
croK
Messages: 170
Registered: April 2002
Senior Member
That's because you are running in automatic undo mode, so, you cannot create any rs.
You can change db status to manual rs mode by commenting out init.ora parameters like undo*.

Best luck
Oracle Consultant and remote DBA for hire.

Report message to a moderator

Previous Topic: Import of Views
Next Topic: What are the appropriate parameter of init.ora file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 14:34:07 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.