How can rename datafile


SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1.2831E+10 bytes
Fixed Size 2171296 bytes
Variable Size 1946164832 bytes
Database Buffers 1.0872E+10 bytes
Redo Buffers 11231232 bytes
Database mounted.
SQL> !mv /u01/app/oracle/product/11.2.0/db_1/dbs/
C:APPORACLESRV2PRODUCT11.2.0DBHOME_2DATABASEOC_TMP_TS /
data/AZKKTST/AZKKTST/OC01.dbf
SQL> ALTER DATABASE RENAME FILE '/u01/app/oracle/product
/11.2.0/db_1/dbs/
C:APPORACLESRV2PRODUCT11.2.0DBHOME_2DATABASEOC_TMP_TS'
 TO '/data/AZKKTST/AZKKTST/OC01.dbf';
Database altered.
SQL> alter database open;
Database altered.
SQL> select status,instance_name from v$instance;
STATUS INSTANCE_NAME
------------ ----------------
OPEN AZKKTST

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: