Home » RDBMS Server » Performance Tuning » What if not give any ext in datafile........
What if not give any ext in datafile........ [message #394591] Sat, 28 March 2009 02:08 Go to next message
sameer_2230
Messages: 19
Registered: March 2009
Location: India
Junior Member
i just add a datafile in tablespace but forgot to give extension...
is it cause some problem?????

Report message to a moderator

Re: What if not give any ext in datafile........ [message #394602 is a reply to message #394591] Sat, 28 March 2009 06:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No. It will not.
Just remember that one file is named differently.

Report message to a moderator

Re: What if not give any ext in datafile........ [message #394855 is a reply to message #394591] Mon, 30 March 2009 10:09 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
What you can do is take that datafile offline WITH ALTER DATABASE DATAFILE <file> OFFLINE;, rename the file on disk, use ALTER DATABASE RENAME FILE '<old file name>' TO '<new file name>'; and then bring the datafile back online again.

Documentation - you've got to love it.

Report message to a moderator

Previous Topic: AWR report analysis
Next Topic: KEEP POOL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 09:47:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.