My apologies for excluding the list from my email. Regards Theo
-----Original Message----- Sent: 04 June 2002 09:21 To: '[EMAIL PROTECTED]' 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: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [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).
