Home » RDBMS Server » Server Administration » how to rename the datafile name and type
how to rename the datafile name and type [message #229691] Mon, 09 April 2007 13:32 Go to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
hello sir

Last week we add datafile for ur server but unfortunately we miss ".dbf" formate

>alter tablespace <tn> add datafile '/mnt/test1'

eg: "/mnt/test1" ---->insteed of "/mnt/test1.dbf"

so we missed the ".dbf" ,now we added another datafile also in the name of '/mnt/test2.dbf' ,but it shows no error till now

plz advice me what can i do ,i dont know whether it will affect in future or not

plz help me to grt rid from the issue

thanx.
Re: how to rename the datafile name and type [message #229693 is a reply to message #229691] Mon, 09 April 2007 13:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96521/dfiles.htm#8765
Re: how to rename the datafile name and type [message #229696 is a reply to message #229693] Mon, 09 April 2007 13:50 Go to previous messageGo to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
thank u sir


plz explain the difference between "data01.dbf" and "data01" file in datafile
what will happen if we use "data01" insteed of "data01.dbf


plz help me sir

Thanx.
Re: how to rename the datafile name and type [message #229697 is a reply to message #229696] Mon, 09 April 2007 13:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> what will happen if we use "data01" insteed of "data01.dbf
Nothing. It is just the way you named it.
Re: how to rename the datafile name and type [message #229698 is a reply to message #229697] Mon, 09 April 2007 13:55 Go to previous message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
thank u sir

so we dont worry about it right!


thank u verymuch sir
Previous Topic: Need help with these interview questions.
Next Topic: Server IP address
Goto Forum:
  


Current Time: Sun Dec 11 08:23:51 CST 2016

Total time taken to generate the page: 0.06768 seconds