you have to drop the tablespace to remove it form thedata dictionary - you cannot just wildly drop datafiles On Wed, 29 Dec 2004 11:10:14 +0800, alex <tech_a@xxxxxxx> wrote: > hi,alex > > i have some other file in the same tablespace, so i can't just drop the > tablespace. -- http://www.freelists.org/webpage/oracle-l