From Sujatha.Madan@cmc.cwo.net.au Wed, 30 Jan 2002 18:40:19 -0800 From: Sujatha Madan Date: Wed, 30 Jan 2002 18:40:19 -0800 Subject: RE: Rename a datafile Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi, The SQL syntax is correct. Looking at the example below, it's for a single datafile in a single tablespace. So, stupid question, did you take the tablespace offline before you did anything? Cheers, Sujatha -----Original Message----- Sent: Thursday, 31 January 2002 12:05 PM To: Multiple recipients of list ORACLE-L Okay, I don't have the manuals with me and can't for the life of me remember the correct syntax to do this... Is it: shutdown database startup no noumt (or startup mount) alter tablesapce evisions rename datafile '/full_path/file_name' to '/full_path/new_name'; I'm on 8.1.6 and this complains saying the database isn't open. It can't be open to rename a datafile... Thanks, Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe LaCascio INET: jlacasci@wheatonma.edu 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@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.com -- Author: Sujatha Madan INET: Sujatha.Madan@cmc.cwo.net.au 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@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).