Re: omf and maintaining naming conventions

From: Daniel Fink <Daniel.Fink_at_Sun.COM>
Date: Tue, 24 Feb 2004 14:17:06 -0700
Message-id: <403BBF52.AE1F784@sun.com>

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_at_cox.net 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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Feb 24 2004 - 15:14:09 CST