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