Home » RDBMS Server » Server Administration » Datafiles without .dbf extension (oracle 9207, sun solaris 5.9)
icon1.gif  Datafiles without .dbf extension [message #339096] Wed, 06 August 2008 14:16 Go to next message
harry07
Messages: 61
Registered: June 2007
Location: now york
Member
Hi Forum

Someone created datafiles in a tablespace in production database without .dbf extensions.

Can anyone please guide how to restore these datafiles back with .dbf extension.

And is there any concern of changing them back to .dbf exntension.

Thanks in advance,
Hary.
Re: Datafiles without .dbf extension [message #339100 is a reply to message #339096] Wed, 06 August 2008 14:25 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First, Oracle does not care about extension or any part of your naming.

If you want to change the name, put the file offline, use "mv" or "rename" OS command, then "alter database datafile" and put bakc the file online.

Regards
Michel
Previous Topic: Shrink DB
Next Topic: DBMS
Goto Forum:
  


Current Time: Fri Dec 09 23:31:52 CST 2016

Total time taken to generate the page: 0.07891 seconds