Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

apostrophe expression in filename

Mehmet YAYLAMay 4 2025

Hello guys

I have really serrious and funny problem

I just wanna move to data files to another folder but I have something weird issue

one of the data file name includes ' (apostrophe expression ) ( I dont know when this happen and why)

and when run the move command than I get the following error

my file name : ‘file_name01.dbf ’

and sql query is :

alter database rename file '/u02/oradata/'file_name01 ‘ ' to ’/u03/oradata/file_name01.dbf';

error :

ERROR at line 1:
ORA-00946: missing TO keyword

Any advice would be great

Comments
Post Details
Added on May 4 2025
1 comment
109 views