Alter command for tablespace offline or online in Oracle

Check status of tablespace offline or online in Oracle

Check the tablespace status is offline or online.

SELECT TABLESPACE_NAME,STATUS FROM DBA_TABLESPACES;

Take the tablespace offline.

alter tablespace ts_name offline;

Take the tablespace online

alter tablespace ts_name online;

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply