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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: how to remove the datafile from data dictionary

Re: how to remove the datafile from data dictionary

From: alex <tech_a_at_126.com>
Date: Wed, 29 Dec 2004 11:10:14 +0800
Message-Id: <20041229031025.251B672C978@turing.freelists.org>


hi,alex

i have some other file in the same tablespace, so i can't just drop the tablespace.

>Hi oracle-l
>
>I offline drop a datafile from database and the datafile still exist in the data dictionary, and when create new table, oracle still allocate tablespace on this datafile.it will encounter and error.
>so my question is how can i remove the datafile from data dictionary.
>
>
> Thanks
> Alex
>
> tech_a_at_126.com
> 2004-12-29
>
>
>--
>http://www.freelists.org/webpage/oracle-l
>

        thanks                                    

        alex
        tech_a_at_126.com
          2004-12-29



--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 28 2004 - 21:06:03 CST

Original text of this message

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