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.
Jared
| "Venu Gopal" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 10/29/2003 05:09 AM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: How to drop a datafile ? |
Well, you an actually move all your objects from this datafile into a
different datafile (read it as different TS) and then offline drop the
datafile.
This will ensure that users don't get the error 'xxx.dbf file is
currently inacessible' message.
Cheers!
Venu
-----Original Message-----
Prem Khanna J
Sent: Wednesday, October 29, 2003 4:34 PM
To: Multiple recipients of list ORACLE-L
Thanx Sinardy & Rachel.
so,the only way is as what Sinardy said.
is that so ?
Regards,
Jp.
29-10-2003 19:44:25, Rachel Carmichael <[EMAIL PROTECTED]> wrote:
>The doc is right. You cannot drop a single datafile from a tablespace.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
**************************Disclaimer************************************
Information contained in this E-MAIL being proprietary to Wipro Limited is
'privileged' and 'confidential' and intended for use only by the individual
or entity to which it is addressed. You are notified that any use, copying
or dissemination of the information contained in the E-MAIL in any manner
whatsoever is strictly prohibited.
***************************************************************************
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Venu Gopal
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
