Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN and datafile

Re: RMAN and datafile

From: Volker <Volker.Zink_at_porabo.ch>
Date: 30 May 2006 07:45:02 -0700
Message-ID: <1149000302.503834.103220@i40g2000cwc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US