Re: Deleting datafile after drop tablespace

fareeda_at_pspl.co.in (fareeda) wrote in message news:<c6d78d84.0305190518.1e1dafa7_at_posting.google.com>...
> Is there a way to tell oracle to delete the datafile when deleting
> tablespaces?
> Now this has to be done manually after drop tablespace is completed
> without problems.
> Any pointers appreciated
> Thanks

Which version are you using ??

I think in Oracle8 you have to delete the data file mananually after droping the tablespace. But in Oracle 9i, Oracle deletes the datafile automatically on droping the tablespace. You don't have to delete that manually. Received on Tue May 20 2003 - 10:37:41 CEST