| Rollback seg [message #64286] |
Mon, 10 January 2005 00:40  |
Abdulla
Messages: 1
Registered: January 2005
|
Junior Member |
|
|
|
Why is it not possible to create a rollback segment initially in a Locally Managed Table space ?
|
|
|
|
| Re: Rollback seg [message #64290 is a reply to message #64286] |
Mon, 10 January 2005 03:53  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
What version of Oracle are you using? Is your database maybe using AUM (undo_management = TRUE)? If so, Oracle will create its own rollback segments (called undo segments) and you don't have to bother creating them. If not, post the command issued with the complete error (hell, why do we need to ask for this every time!).
Best regards.
Frank
|
|
|
|
| Re: Rollback seg [message #64335 is a reply to message #64286] |
Wed, 12 January 2005 23:19 |
naveed
Messages: 5
Registered: October 2001
|
Junior Member |
|
|
see upto to 9.0.1 manual rollback segments cannot
be created in locally managed tbs this shorting comming
has been eliminated from oracle 9.2.0 version
now in 9.2.0 first create a rollback segment in
tablespace system and make it online and then create rollback segments in any locally managed tbs
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
