Re: how to remove the datafile from data dictionary

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

hi,alex

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

======= 2004-12-29 11:07:26 =======

>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
>
>
>--
>//www.freelists.org/webpage/oracle-l
>

= = = = = = = = = = = = = = = = = = = =
                        

        thanks
 
                                 
        alex
        tech_a@xxxxxxx
          2004-12-29



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

Other related posts: