Database Administration (MOSC)

MOSC Banner

Rollback segment storage parameter

edited Aug 26, 2009 7:43AM in Database Administration (MOSC) 5 commentsAnswered
 Hi,

I am trying to create a public rollback segment in a rollback segment tablespace. However, after creating the rollback segment, it seems only the initial parameter is set according to my preference. The next extent and min extents are set to the same values as the tablespace's ones. It doesn't seem to take my parameter.

Here's the script:

create public rollback segment bigrbs

storage (initial 100m next 100m maxextents unlimited)

tablespace rbseg;

The Oracle version is 9.2.0.6. Thanks in advance.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center