Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle9iAS - Make sure there is at least one online non-system rollback segment?

Re: Oracle9iAS - Make sure there is at least one online non-system rollback segment?

From: Alan <nomorezpam3_at_hotmail.com>
Date: 30 Sep 2004 06:20:54 -0700
Message-ID: <84f54f12.0409300520.54cae2ff@posting.google.com> 





Thanks - but "create rollback segment ROLLBACKSEG;" failed with an
"ORA-30019: Illegal rollback Segment operation in Automatic Undo
mode".



Alternatively - I've been able to issue:



SQL> create undo tablespace undo_tbs1 datafile
/var/opt/oracle/undoTablespace/undo_tbs1.dat' size 100M;
SQL> Alter system set undo_tablespace = undo_tbs1;




not sure where the standard/correct place to put these files (or even
the standard filename extension) on Solaris, so I've dumped it there
for now.



Thanks


Alan
Received on Thu Sep 30 2004 - 08:20:54 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US