Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ora-01516 on alter database rename file

Re: ora-01516 on alter database rename file

From: koert54 <koert54_at_nospam.com>
Date: Sat, 23 Feb 2002 17:24:43 GMT
Message-ID: <vfQd8.175960$rt4.19833@afrodite.telenet-ops.be>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US