if you did a shutdown of the database, and then do a startup mount, you don't actually HAVE to take the tablespace offline, as the database isn't open and technically it isn't online.
If you want to live dangerously, you can do this while the database is open for business. Then yes, you'd need to take the tablespace offline. In either case, the syntax for the rename itself is: alter database rename file '<full path specification of the old filename>' to '<full path specification of the new filename>'; Once that is done, you copy the datafile over to where you actually want it via OS commands, then either alter database open or alter tablespace online depending on which way you've done it. Immediately do a "alter database backup controlfile to trace" and as soon as possible afterwards, do a backup, just to be safe --- Sujatha Madan <[EMAIL PROTECTED]> wrote: > 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: [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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sujatha Madan > 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). __________________________________________________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).