Home / APPS DBA / How to rename a Datafile with Extension .dbf?

How to rename a Datafile with Extension .dbf?

How to rename a Datafile with Extension .dbf?

For example we have  added a datafile but we forgot to give the extension .dbf

Step 1. Shut down the Database

SQL> shutdown immediate;


Step 2. Startup the Database in Mount State

SQL> startup mount

Step 3. Now copy the datafile by renaming it with .dbf extension

$cp /u01/app/oracle/user2  /u01/app/oracle/user2.dbf


Step 4. Now rename database file at Database Level

SQL> alter database rename file ‘/u01/app/oracle/user2’ to ‘/u01/app/oracle/user2.dbf’;


Step 5. Now Open the Database

SQL> alter database open;



About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also


AC-50480: Internal error occurred

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora

Leave a Reply