how to remove the datafile from data dictionary

  • From: "alex" <tech_a@xxxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 29 Dec 2004 11:07:26 +0800

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@xxxxxxx
          2004-12-29


--
http://www.freelists.org/webpage/oracle-l

Other related posts: