OCM 11g Preparation - Create and manage temporary, permanent, and undo tablespaces

Creating tablespaces is one of the most basic thing a DBA must know. If you need to create any in the exam, do not memorialize the syntax. Go to the DOC, get an example and adapt as needed. You can also use the DBMS_METADATA to get the DDL of any existent tablespace to use as a template.

You must clearly know the difference/advantages/disadvantages/consequences/requirements between:

  • BIG / SMALL file tablespaces.
  • DMT / LMT - Convert between them.
  • MSSM / ASSM.

You must also be able to create very fast a new tablespace via sqlplus or EM interface.

Path to Documentation:

Oracle Database SQL Language Reference -> CREATE TABLESPACE
Oracle Database Administrator's Guide -> Managing Tablespaces


Click here to go back to the Main OCM 11g Preparation page.

Have you enjoyed? Please leave a comment or give a 👍!

3 comments

    • Radek on March 16, 2016 at 16:23
    • Reply

    I think it is worth mentioning TRANSPORTABLE TABLESPACES which you will find at the end section of:
    Oracle Database Administrator’s Guide -> Managing Tablespaces

  1. Good day,

    Hope you don't mid but I am preparing for the OCM exam myself. I will cut and paste a lot of the content from your site to create a similar page. i will however reference all copied items back to your page. I will also add videos for the activities.

    Imraan Grace

    1. No problem Imraan

Leave a Reply

Your email address will not be published.