Re: omf and maintaining naming conventions

  • From: Daniel Fink <Daniel.Fink@xxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 24 Feb 2004 14:17:06 -0700

You can use the command "drop tablespace junk including contents and 
datafiles;". IIRC it was introduced in 9i. If you want to use the datafiles 
clause, you must use the including
contents clause.

ryan.gaffuri@xxxxxxx wrote:

> i didnt notice that you can delete the datafile from with in oracle. I missed 
> it in the docs.

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: