Re: Using DROP TABLESPACE INCLUDING CONTENTS

From: Marianne C Brooks <dprmcb_at_inetg1.ARCO.COM>
Date: 24 Jan 92 15:47:08 GMT
Message-ID: <1992Jan24.154708.6655_at_Arco.COM>


In article <1992Jan24.152527.39_at_hhcs.gov.au>, pihlab_at_hhcs.gov.au writes:
> Yes it should work BUT I have had problems with the INCLUDING CONTENTS
> option
> under V6.0.30 when a "non-active" rollback segment was in the tablespace.
> The
> end result being an unrecoverable database with massive block corruption.
> > Luckily we had a recent backup and the loss of a dya of data on this
> database
> was not crucial (simply reentered by users). I tend to shy away from
> that
> option these days.
>
>

Would this problem be eliminated if you had a tablespace devoted to containing your rollback segments? I believe this is what ORACLE recommends.

Any thoughts out there?

Marianne Brooks Received on Fri Jan 24 1992 - 16:47:08 CET

Original text of this message