Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN and datafile
The INDX-tablespace is a system-tablespace (like tools and user). There
is no application object in this tablespace. Probably there is nothing
in it at all, but i am not sure. If i do look at dba_indexes no index
is in this tablespace (but there are some with NO tablespace_name). If
i look which segments are in there, there are none too. But if i look
in the Enterprise Manager the first datafile (not the accidently
created one) is 0.063% full. It really seems there is nothing in it,
and so i would be happy to drop it completely but i am quite cautious
to drop something i don't know whats in and what it is used for.
Received on Tue May 30 2006 - 09:45:02 CDT