Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Set rollback segment online
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