Alter Tablespace Rename
To rename a tablespace, we can issue command ALTER TABLESPACE RENAME TO like this.
SQL> alter tablespace erp_tsb rename to erp_tbs;
Tablespace altered.
As you can see, we have corrected the misspelled tablespace name from ERP_TSB into ERP_TBS, no lock is required.