Rename tablespace in oracle db

Rename tablespace in oracle db

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