Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ora-01516 on alter database rename file
I think your datadictionary is corrupted (file$) - contact oracle support
You might want to try recreating the control file but I think it won't help
Another option is restore your backup 8.0.4 and run the migration scripts
manual
instead of using a 'wizard' ....
"ivan pellegrin_at_aedventure.com" <ivanpellegrinataedventure_at_yahoo.com> wrote
in message news:e846ce1f.0202220612.71cb11a9_at_posting.google.com...
> 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 Sat Feb 23 2002 - 11:24:43 CST