Re: Deleting datafile after drop tablespace
From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 20 May 2003 07:09:07 -0700
Message-ID: <1b061893.0305200609.583ed356_at_posting.google.com>
Date: 20 May 2003 07:09:07 -0700
Message-ID: <1b061893.0305200609.583ed356_at_posting.google.com>
In 9i, the syntax is:
"drop tablespace WHATEVERNAME including contents and datafiles".
Daniel
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
Received on Tue May 20 2003 - 16:09:07 CEST