Re: Rollback Segment

On Sat, 17 Nov 2001 23:52:50 GMT, "Sara Swartz" <sarabillnn_at_Shotmail.com> wrote:

>Here is one that I cannot figure out. I have Oracle Personal edition 8i, and
>I am trying to insert values into a table that I created. I keep getting the
>error ora - 01552 which states that I cannot use the system rollback
>segment for the tablespace 'Users'. Okay, I can accept that. The problem is
>that I don't know how to create a rollback segment that 'Users' can use. Can
>I do this through SQL Plus?
>
>What would the proper sql statement be to create the rollback segment?
>
>Thanks,
>Sara
>

Obviously you must be using the starter database. Immediately after install you must create a second rollback segment in the tablespace system.
Only then you can use non-system tablespaces. The normal procedure is to create a rollback segment in the tablespace SYSTEM called rbtemp or something like that, and then create rollback segments in the tablespace RBS.
The syntax to create a rollback segment can be found in the sql reference manual.
Do not forget to change init<sid>.ora to add a line rollback_segments=(<name of rollback segment>...)

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Nov 18 2001 - 00:56:29 CST