Home » Infrastructure » Unix » datafile rename (11.2.0.2)
datafile rename [message #521846] Fri, 02 September 2011 06:35 Go to next message
sahadba
Messages: 59
Registered: September 2009
Location: Pune
Member

Hi,

While adding a datafile to DB, i did a mistake i added '>' to the file name

uwp_T01_16.dbf>


I want to rename now and have shutdown the database as we have downtime.
I get the below error though while moving the datafile


oracle@lxx0084:/prd/dvp/ora/oradata/LCU/disk06]# mv /prd/dvp/ora/oradata/LCU/disk06/uwp_T01_16.dbf> /prd/dvp/ora/oradata/LCU/disk06/uwp_T01_16.dbf
mv: missing destination file operand after `/prd/dvp/ora/oradata/LCU/disk06/uwp_T01_16.dbf'
Try `mv --help' for more information.


Please assist..

Thank You
Re: datafile rename [message #521849 is a reply to message #521846] Fri, 02 September 2011 06:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
mv '/prd/dvp/ora/oradata/LCU/disk06/uwp_T01_16.dbf>' /prd/dvp/ora/oradata/LCU/disk06/uwp_T01_16.dbf

Regards
Michel
Re: datafile rename [message #521851 is a reply to message #521846] Fri, 02 September 2011 06:58 Go to previous message
sahadba
Messages: 59
Registered: September 2009
Location: Pune
Member

Guys,

I renamed the file

mv uwp_T01_16.dbf\> uwp_T01_16.dbf
Smile

Thanks
Previous Topic: How to display Century in UNIX.
Next Topic: Privileges on Oracle_home
Goto Forum:
  


Current Time: Fri Mar 29 04:20:36 CDT 2024