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!

rename datafile by file#

HonzaApr 23 2011 — edited May 2 2011

Hello,

is it possible to rename a datafile, but instead of specifying the file name, I can specify the file number?

something along the lines of:
alter database rename file 10 to '/whatever';

Is this possible in any way? The problem is that I have a datafile with question marks showing up that always display differently and this is causing problems.

Regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 30 2011

Added on Apr 23 2011

#general-database-discussions

14 comments

1,352 views