.dbf is a valid name for a datafile name?

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 Cell818 402-1987 The information contained in this message and any

Re: .dbf is a valid name for a datafile name?

[EMAIL PROTECTED] wrote: 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? it depends on your OS. and how you'd rename depends on that too. -- -- Bill Shrek Thater

Re: .dbf is a valid name for a datafile name?

-- Hamid Alavi [EMAIL PROTECTED] 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? You can ln .dbf name_you_wanted any time you like. Unlink the .dbf basename whenever

RE: .dbf is a valid name for a datafile name?

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

RE: .dbf is a valid name for a datafile name?

.dbf is perfectly OK -Original Message- Sent: Tuesday, March 26, 2002 10: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

RE: .dbf is a valid name for a datafile name?

recipients of list ORACLE-L Subject: .dbf is a valid name for a datafile name? 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

RE: .dbf is a valid name for a datafile name?

is a valid name for a datafile name? .dbf is perfectly OK -Original Message- Sent: Tuesday, March 26, 2002 10: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

RE: .dbf is a valid name for a datafile name?

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

RE: .dbf is a valid name for a datafile name?

Raj, That looks like it works also. Many ways to skin a cat. I personally have gotten used to using OEM and letting it issue the command. I think they both would work. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, March 26, 2002 1:44 PM To: Multiple

RE: .dbf is a valid name for a datafile name?

Just don't know can i make off line TEPM tablespace or not? alot of users using it ... -Original Message- Sent: Tuesday, March 26, 2002 10:44 AM To: Multiple recipients of list ORACLE-L Tom, if he is going to have the tablespace off line with database up and running , shouldn't the

RE: .dbf is a valid name for a datafile name?

That looks like it works also. Many ways to skin a cat. true..!! Thanks for not taking this the wrong way..:) Cheers, RS __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the

RE: .dbf is a valid name for a datafile name?

Create another temp1 tablespace not big. point your user temp tablespace to temp1. Offline your temp tablespace and do whatever you want. Once done point back the original temp tbs and drop temp1 tbs. No system down time. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of

RE: .dbf is a valid name for a datafile name?

Alter tablespace is a better option wherby you can do it while database is up and only that particular tablespace is offline. OEM does the same thing. You can use it for any tablespace except SYSTEM tablespace which you cannot put offline. For 'Alter database' you need down time as database