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;

 

 

........Subsribe OracleSolutions.pk........
OracleSolutions.pk is exclusively meant to guide the newbies to Learn and Share.

About oracle.solutions

Check Also

JSP error Request URI:/OA_HTML/RF.jsp java.lang.NoClassDefFoundError

ERROR JSP Error: Request URI:/OA_HTML/RF.jsp Exception: java.lang.NoClassDefFoundError JSP Error: Request URI:/OA_HTML/AppsLocalLogin.jsp Exception: java.lang.NoClassDefFoundError More from …

Leave a Reply