Oracle 11g DBA Concepts
SQL> select name from v$tablespace;
SQL> alter tablespace venu offline;
SQL> select tablespace_name,block_size,status,contents,bigfile from dba_tablespces;
SQL> alter tablespace venu online;
SQL> select tablespcae_name,status from dba_tablespaces;
No comments:
Post a Comment