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: Set rollback segment online

Re: Set rollback segment online

From: Chris Weiss <weisschr_at_pilot.msu.edu>
Date: Thu, 22 Jul 1999 12:51:16 -0400
Message-ID: <7n7i6u$996$1@msunews.cl.msu.edu>


See my previous post. You can with dynamic PL/SQL.

Chris

Vrajesh Patel <vrajesh_p_at_hotmail.com> wrote in message news:nGHl3.195$pF6.39495_at_PM01NEWS...
> As far as my knowledge goes, you can't.
>
> Thanks,
>
> -Vrajesh Patel.
>
> Daiminger, Helmut <Helmut.Daiminger_at_gedas.de> wrote in message
> news:53924C75CF23D3118C1300508B0A4B1B0396A5_at_mucsem01.gedas.de...
> > Hi,
> >
> > can I set a rollback segment online within a PL/SQL package?
> >
> > begin
> > ....
> > alter rollback segment PUB_RS1 online;
> > ...
> > end;
> >
> > Thanks,
> > Helmut
> >
>
>
Received on Thu Jul 22 1999 - 11:51:16 CDT

Original text of this message

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