Re: Oracle for OS/2

From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: 1995/07/20
Message-ID: <DC0CsA.DJ7_at_liverpool.ac.uk>#1/1


01516, 00000, "nonexistent log/data file '%s'"
// *Cause: ALTER DATABASE is attempting to rename/create a log or a data
// file which is not known to the database control file.
// *Action: Specify the name of an existing log file.

You've missed the point. The error is saying that the specified file is not known to the control file. In fact, are you perchance attempting to rename the control file? You cannot do so this way. To do so, shutdown your database, copy control file to new location and change init.ora to specify new control file location. You should now be able to startup your database to rename log and data files as per your posting. Don't forget that you need to copy files to new locations manually - all rename does is record facts in the control file.

Hope this helps.

        Helen Received on Thu Jul 20 1995 - 00:00:00 CEST

Original text of this message