My Oracle Support Banner

ORA-01141 'File not Found' when trying to rename the file. (Doc ID 289667.1)

Last updated on JUNE 07, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 10.1.0.3 [Release 8.1.7 to 10.1]
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

 NOTE: In the images and/or the document content below, the user information and environment data used
represents fictitious data from the Oracle sample schema(s),Public Documentation delivered with an
Oracle database product or other training material. Any similarity to actual environments, actual
persons, living or dead, is purely coincidental and not intended in any manner.



For the purposes of this document, the following fictitious environment is used as an example
to describe the procedure:

 

Directory =  /home/oracle and all subdirectories

 

You are trying to rename a datafile, but oracle is not able to recognize the file, even though it is physically present in the mentioned location.
During this operation, oracle would look/read the datafile in the new location/name provided.
So, when "renaming the file", the "new file" should be present.

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.