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?????
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: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No. It will not.
Just remember that one file is named differently.
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.
Previous Topic: AWR report analysis
Next Topic: KEEP POOL
Goto Forum:
  


Current Time: Sat Dec 03 00:52:59 CST 2016

Total time taken to generate the page: 0.08882 seconds