| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: oddity dropping tablespace!?
K.Spiller wrote:
>
> Hi!
>
> I'm a bit confused about the behaviour of my DB. Using 7.3.4 on WinNT.
>
> I dropped a tablespace, and it really has gone viewing dba_tablespaces,
> but it still lingers around when viewing dba_ts_quotas or
> when viewing the underlying sys.ts$ (and sys.tsq$).
>
> I created another tablespace using the same name of the dropped one,
> and sys.ts$ didn't change at all. Still one row for the
> dropped and recreated tablespace. And the quotas once installed
> still existed for the newly created tablespace.
>
> I even stopped and restarted the database, but got the same results.
>
> Should this be seen as a feature???
> I expected droppping a tablespace would destroy all information related
> to it. And reusing a name shouldn't have such side effects.
>
> Seems confusing to me. Any good explanations?
>
> regards,
> Kathrin Spiller
> kspiller_at_gmx.de
THis is correct behaviour and whats more comes in very useful when creating lots of massive tablespaces in parallel.
HTH
--
"Some days you're the pigeon, and some days you're the statue." Received on Fri Jan 21 2000 - 04:23:40 CST
 |
 |