Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reusing name of rollback segment
In article <917tle$gad$1_at_nnrp1.deja.com>,
Grange Man <odindba_at_my-deja.com> wrote:
> Someone told me recently that if one drops and recreates a rollback
> segment (say to change its size), that it should be given a new name,
> not the name it used to have.
>
> Is there any basis for this?
>
> Thanks.
>
> Sent via Deja.com
> http://www.deja.com/
>
No,
of course before you drop the rollback segment it must be offline.
Hth,
-- Sybrand Bakker, Oracle DBA All standard disclaimers apply ------------------------------------------------------------------------ Sent via Deja.com http://www.deja.com/Received on Wed Dec 13 2000 - 08:21:44 CST