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: 64269
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: Mon Jan 16 11:51:13 CST 2017

Total time taken to generate the page: 0.04822 seconds