Re: ora-01516 on alter database rename file

paul

try to verify the existing location of the datafile you want to move in v$datafile:

select name
from v$datafile;

then try to reissue the command:

ALTER DATABASE RENAME FILE '<OldPathAndName>' TO '<NewPathAndName>';

where:
<OldPathAndName> filename as it is listed in the v$datafile view

hope this solves the problem

ivan pellegrin Received on Fri Feb 22 2002 - 08:12:07 CST