Oracle-L: FW: Can we drop and re-create tablespace without deleting the corresponding datafile thru operating system command?

Home -> Community -> Mailing Lists -> Oracle-L -> FW: Can we drop and re-create tablespace without deleting the corresponding datafile thru operating system command?

From: Theodoros Demosthenous <theodoros_at_edams.com>
Date: Tue, 04 Jun 2002 01:18:26 -0800
Message-ID: <F001.00473276.20020604011826@fatcity.com>

My apologies for excluding the list from my email.

Regards
Theo

-----Original Message-----
Sent: 04 June 2002 09:21
To: 'shinakhibhat_at_hotmail.com'
corresponding datafile thru operating system command?

Sorry for the delay, but this is to our time difference. Please find a more detailed explanation below:

Dropping Datafiles and Tempfiles

Unlike files that are not Oracle managed, when an Oracle-managed datafile or tempfile is dropped, the filename is removed from the control file and the file is automatically deleted from the file system. The statements that delete Oracle-managed files when they are dropped are:

DROP TABLESPACE
ALTER DATABASE TEMPFILE ... DROP Dropping Online Redo Log Files

When an Oracle-managed online redo log file is dropped its Oracle-managed files are deleted. You specify the group or members to be dropped. The following statements drop and delete online redo log files:

ALTER DATABASE DROP LOGFILE
ALTER DATABASE DROP LOGFILE MEMBER In Oracle9i Rel.2 you can use the following:

AND DATAFILES clause

When you specify INCLUDING CONTENTS, the AND DATAFILES clause lets you instruct Oracle to delete the associated operating system files as well. Oracle writes a message to the alert log for each operating system file deleted. This clause is not needed for Oracle-managed files.

The following example drops the tbs_02 tablespace and deletes all associated operating system datafiles:

DROP TABLESPACE tbs_02

INCLUDING CONTENTS AND DATAFILES; I hope that this was more helpful.

Regards
Theodoros

-----Original Message-----
Sent: 04 June 2002 06:19
To: ODTUG-SQLPLUS-L_at_fatcity.com
Cc: Peter.McLarty_at_mincom.com; Theodoros Demosthenous corresponding datafile thru operating system command?

Dear Mr Theo,

Thanks for your enclosed mail. You mean to say if it is some earlier version, then we need to drop the tablespace, delete corresponding dbf file thru operating system command and recreate the tablespace & the corresponding dbf datafile thru create tablespace command?

Please elaborate.

Regards

Kamal Mutneja

Theodoros Demosthenous <theodoros_at_edams.com> wrote:
> Only in Oracle9i Rel.2 this can be done.
>
> Regards
> Theo
>
> -----Original Message-----
> Sent: 03 June 2002 09:53
> To: Multiple recipients of list ODTUG-SQLPLUS-L
> corresponding datafile thru operating system
> command?
>
>
> Hi
>
> Can we drop and re-create tablespace without
> deleting
> the corresponding datafile thru operating system
> command?
>
> Regards
>
> Kamal Mutneja
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
> Become an ODTUGer and be a voice to Oracle! Join now
> at www.odtug.com/join.htm
> ODTUG 2002 at Caesars Palace in Las Vegas, NV, June
> 17-21, 2002
> --
> Author: Kamal Mutneja
> INET: shinakhi_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>

> 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
> ODTUG-SQLPLUS-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).
> Become an ODTUGer and be a voice to Oracle! Join now
> at www.odtug.com/join.htm
> ODTUG 2002 at Caesars Palace in Las Vegas, NV, June
> 17-21, 2002
> --
> Author: Theodoros Demosthenous
> INET: theodoros_at_edams.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>

> 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
> ODTUG-SQLPLUS-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).

Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Theodoros Demosthenous
  INET: theodoros_at_edams.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

Received on Tue Jun 04 2002 - 04:18:26 CDT