DBA Hub

📋Steps in this guide1/1

Rename tablespace in oracle db

Imported guide

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
SQL❯
select file_id,file_name,tablespace_name from dba_data_files where file_id=37;
FILE_ID FILE_NAME						    TABLESPACE_NAME
---------- -------------------------------------------------------- ------------------------------
	37 /home/oracle/app/oracle/oradata/cdb1/testin1.dbf	    TESTING
 
 
--- Rename the tablespace_name from TESTING to PRODUCING;
 
SQL❯
alter tablespace TESTING rename to PRODUCING;
Tablespace altered.
SQL❯
select file_id,file_name,tablespace_name from dba_data_files where file_id=37;
FILE_ID FILE_NAME						    TABLESPACE_NAME
---------- -------------------------------------------------------- ------------------------------
	37 /home/oracle/app/oracle/oradata/cdb1/testin1.dbf	    PRODUCING

Comments (0)

Please to add comments

No comments yet. Be the first to comment!