Blog
How to Rename datafile in Oracle
- June 10, 2019
- Posted by: Ankush Thavali
- Category: Oracle DBA
No Comments
How to rename Datafile in Oracle 12c
SQL> SELECT name FROM v$datafile WHERE name LIKE '%users01%'; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/cdb1/users01.dbf SQL> ALTER TABLESPACE users OFFLINE NORMAL;
Rename the file on server level
HOST mv /u01/app/oracle/oradata/cdb1/users01.dbf /u01/app/oracle/oradata/cdb1/users02.dbf
ALTER TABLESPACE users RENAME DATAFILE '/u01/app/oracle/oradata/cdb1/users01.dbf' TO '/u01/app/oracle/oradata/cdb1/users02.dbf'; ALTER TABLESPACE users ONLINE; SQL> SELECT name FROM v$datafile WHERE name LIKE '%users02%'; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/cdb1/users02.dbf SQL>
How to rename Datafile in Oracle 12c
SQL> SELECT name FROM v$datafile WHERE name LIKE '%users01%'; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/cdb1/users01.dbf SQL> ALTER TABLESPACE users OFFLINE NORMAL;
Rename the file on server level
HOST mv /u01/app/oracle/oradata/cdb1/users01.dbf /u01/app/oracle/oradata/cdb1/users02.dbf
ALTER TABLESPACE users RENAME DATAFILE '/u01/app/oracle/oradata/cdb1/users01.dbf' TO '/u01/app/oracle/oradata/cdb1/users02.dbf'; ALTER TABLESPACE users ONLINE; SQL> SELECT name FROM v$datafile WHERE name LIKE '%users02%'; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/cdb1/users02.dbf SQL>