RE: RE: How to drop a datafile ?

Prem

   I will provide my guesses and maybe someone that knows the real story will reply. First, in order for Oracle to drop a datafile, you would somehow have to ensure that it is empty. I would guess if Oracle added this feature, then Oracle Support would receive a lot of questions about why it erred out for them.

   Second, for any software system, what is the portion most likely to cause an error? The part that changed last. If they created this feature at this late date, it would probably produce weird behavior sometime.

   Finally, developers develop what they are requested to develop. Those requests generally come from marketing. For odd features like this marketing probably gets a list from support. So, if many customers aren't requesting a feature, it will probably never get on the development feature list.

   But that is all just a guess based on my personal experience working for a software vendor long ago on a faraway planet, and that vendor certainly wasn't Oracle.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, October 30, 2003 8:24 PM To: Multiple recipients of list ORACLE-L

Thanx everybody.
i thought there would be a way to do it.

just curious .....

why is it not so ? any good reason for it ?!!!

Regards,
Jp.

30-10-2003 02:34:26, Jared.Still_at_radisys.com wrote:
> That won't actually do what you're implying. Checking the docs would
prove
> helpful.
>
> From the SQL ref:
>
>
> If the database is in NOARCHIVELOG mode, you must specify the DROP clause
to
> take a datafile offline. However, the DROP clause does not remove the
>
> datafile from the database. To do that, you must drop the tablespace in
> which the datafile resides. Until you do so, the datafile remains in the
>
> data dictionary with the status RECOVER or OFFLINE.
>
>
> If the database is in ARCHIVELOG mode, Oracle ignores the DROP keyword.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: jprem_at_kssnet.co.jp

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).