Re: invalid status tablespace

From: G.H VITTAL <vittal_at_india.hp.com>
Date: Sun, 02 May 1999 12:50:29 +0530
Message-ID: <372BFCBD.64E2C424@india.hp.com>

All the deleted tablspaces will be shown as with the status INVALID in USER_TABLESPACES. You can refer DBA by Oracle press by author kelly for guidelines for sizing rollback segments.

nieuws net wrote:

> Hi everyone
>
> I've deleted 3 tablespaces a couple of weeks ago and removed the datafiles
> from disk, so far so good.
> When i yesterday did a
> SELECT
> TABLESPACE_NAME,STATUS
> FROM
> USER_TABLESPACES
> i saw the 3 deleted tablespaces with a status INVALID
> (the same query on dba_tablespaces did'nt show those tablespaces by the way)
> Anyone with a hint ?
>
> My second question is : Are there guidelines for sizing rollback segments ?
> How many and whats the size.
>
> Thanks
>
> gkor_at_rdw.nl
Received on Sun May 02 1999 - 02:20:29 CDT