Topic : Tablespace Management

Can a tablespace hold objects from different schemes?


Answer :

YES

Show Answer Discuss

How to Extend the Size of a tablespace?


Answer :

SQL>alter database tablespace_name datafile '/u01/oracle/data/salestb01.dbf' resize 100M;

Show Answer Discuss

How to Coalescing Tablespaces?


Answer :

SQL> alter tablespace ica coalesce;

Show Answer Discuss

How To make a tablespace read only and read write?


Answer :

SQL>alter tablespace ica read only;
Again to make it read write
SQL>alter tablespace ica read write;

Show Answer Discuss

User SCOTT creates an index with this statement: CREATE INDEX emp_indx on employee (empno). In which tablespace would be the index created?


  • SYSTEM tablespace
  • SCOTTS default tablespace
  • Tablespace with rollback segments
  • Same tablespace as the EMPLOYEE table.

Answer :

SCOTTS default tablespace

Show Answer Discuss