Re: RMAN and datafile

Volker schreef:
> 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.
>

Eeerrr. No

INDX is a tablespace that is created by default. A remnant from old days, and removed immediately when checking the scripts :)

It is in no way a "system" tablespace - that is, it is not crucial to the Oracle RDBMS (as opposed to SYSTEM, UNDO and -to a lesser account- TEMP).

Same is true for USER and TOOLS tablespaces - although created, the standard scripts do not use/install objects into these tablespaces.

About time SYSTEM got TOOLS for a default TS.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...