ora-01516 on alter database rename file

From: paul_at_redfacedrhino <nospampaul_at_redfacedrhino.co.uk>
Date: 22 Feb 2002 03:03:41 -0800
Message-ID: <cb104bfa.0202220303.6542d45a@posting.google.com>

I have upgraded an 8.0.4 database to 8i. I had problems with the migration wizard moving files, so have moved the files manually. I have had no problems with the majority of the files, but I have three files which appear in the view dba_data_files with no path specified.

I have tried ;

"alter database rename file 'path\file.dbf' to 'newpath\file.dbf' and
"alter database rename file 'file.dbf' to 'newpath\file.dbf'

both of them return the same errors

ora-01511: error in renaming log/data files ora-01516: nonexistent log file, datafile or tempfile etc.

I have tried copying the files to various other locations, such as the same dir as init.ora, the oradata, database and dbs sub directories to no avail.

The files do exist on the disk and are accessible to Oracle - I can query data in these tablespaces....

Is there a way around this? Received on Fri Feb 22 2002 - 05:03:41 CST