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.

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 19:39:32 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.