Taking tablespaces Offline or Online

SQL>  select tablespace_name FROM DBA_TABLES;

SQL>  select tablespace_name FROM USER_TABLES;


SQL> select owner, table_name, tablespace_name
     from dba_tables
     where owner in ('SCOTT', 'HR')

     order by owner, tablespace_name, table_name;

OWNER                          TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------ ----------------
HR                             DEPARTMENTS                    USERS
HR                             EMPLOYEES                      USERS
HR                             JOBS                           USERS
HR                             JOB_HISTORY                    USERS
HR                             LOCATIONS                      USERS
HR                             REGIONS                        USERS
HR                             COUNTRIES

7 rows selected.

SQL> SELECT TABLESPACE_NAME, STATUS, CONTENTS
     FROM USER_TABLESPACES;
     TABLESPACE_NAME

SQL> alter tablespace tablespace_name offline;

SQL> alter tablespace tablespace_name online;