Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Roback messages
Apparently the rollback segment is not online.
either issue a select segment_name, status from dba_rollbck_segs or use
v$rollstat to verify.
If it is not online issue alter rollback segment <segment_name> online and
verify init<sid>.ora where it should appear in the line
rollback_segments=(<segmentname1>,<segmentname2>), assuming your didn't
issue the command create public rollback segment before, in which case this
all shouldn't be necessary.
Hth,
Sybrand Bakker, Oracle DBA
Jeff Smelser <tradergt_at_bigfoot.com> wrote in message
news:Pine.LNX.4.10.10002221029080.12019-100000_at_server.smelser.org...
> Inserting some records into my newly created database/tables gives me:
>
> Procedure created.
>
> No errors.
> Big problem on insert
> Error of some kind
> BEGIN load_stock_info; END;
>
> *
> ERROR at line 1:
> ORA-01552: cannot use system rollback segment for non-system tablespace
> 'STOCKS_TBLS'
> ORA-06512: at "ORACLE.LOAD_STOCK_INFO", line 63
> ORA-06512: at line 1
>
>
> Here is what I did, I created the database, created tablespace
> stocks_tbls. I then created the table stocks. Then, created a rollback
> segment, using tables space stocks_tbls, stocks_rbs.
>
> I am user oracle btw.
> I am new at this stuff, so if I missed something I would not be
> surprised.. :) thanks
>
> Jeff
>
Received on Tue Feb 22 2000 - 11:11:26 CST