Skip to content
Home » Oracle » How Oracle Rename Tablespace

How Oracle Rename Tablespace

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.

Leave a Reply

Your email address will not be published. Required fields are marked *