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
Messages: 61
Registered: June 2007
Location: now york
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,
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: 65082
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.

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

Current Time: Fri Jul 21 08:06:43 CDT 2017

Total time taken to generate the page: 0.18646 seconds