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: Help!!! Rollback tablespace

Re: Help!!! Rollback tablespace

From: BRAJB <brajb_at_aol.com>
Date: 1997/09/19
Message-ID: <19970919032100.XAA11893@ladder02.news.aol.com>#1/1

I am not certain on this, but I believe you will have to do the following:

  1. alter rollback segment segment_name offline;
  2. drop rollback segment segment_name;
  3. create rollback segment segment_name tablespace ROLLBACK online; (You have to specify more parameters here like storage and such - see the syntax guide for assistance);
Received on Fri Sep 19 1997 - 00:00:00 CDT

Original text of this message

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