Tom, if he is going to have the tablespace off line with database up and running , shouldn't the command be alter tablespace rename file '< >' to '< >' ;
Cheers, RS --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > Hamid, > > .dbf is prefectly valid on all machines, as far as I > know. > > You can rename it - look at the ALTER DATABASE > RENAME FILE 'filename' to > 'newfilename' clause to rename the data file. You > will need to take the > tablespace offline to do this. > > Hope this helps > > Tom Mercadante > Oracle Certified Professional > > > -----Original Message----- > Sent: Tuesday, March 26, 2002 11:39 AM > To: Multiple recipients of list ORACLE-L > > > I have added a datafile to a the temp tablespace > with the name of .dbf only > is ithis a valid name?, is there any way to rename > it without shutdown the > database,if yes HOW? > > Thanks > > > > Hamid Alavi > Office 818 737-0526 > Cell 818 402-1987 > > The information contained in this message and any > attachments is intended > only for the use of the individual or entity to > which it is addressed, and > may contain information that is PRIVILEGED, > CONFIDENTIAL and exempt from > disclosure under applicable law. If you have > received this message in error, > you are prohibited from copying, distributing, or > using the information. > Please contact the sender immediately by return > e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Hamid Alavi > 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: Mercadante, Thomas F > 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!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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).