DBA Hub

📋Steps in this guide1/1

How to Rename datafile in Oracle

How to rename Datafile in Oracle 12c SQL> SELECT name FROM v$datafile WHERE name LIKE '%users01%'; NAME

oracle configurationintermediate
by OracleDba
12 views
1

Overview

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
SQL> SELECT name FROM v$datafile WHERE name LIKE '%users01%';

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/cdb1/users01.dbf

SQL> ALTER TABLESPACE users OFFLINE NORMAL;

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>

Comments (0)

Please to add comments

No comments yet. Be the first to comment!