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

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

how to remove the datafile from data dictionary

From: alex <tech_a_at_126.com>
Date: Wed, 29 Dec 2004 11:07:26 +0800
Message-Id: <20041229030729.5BA0172C20A@turing.freelists.org>


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
Received on Tue Dec 28 2004 - 21:03:09 CST

Original text of this message

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