以此记录每一次OCM练习的过程，发现其中缺少的部分并补完。

撤销保留范围

题目千万句，回答就一句

alter system set undo_retention=5400;

表空间

新增表空间

CREATE TABLESPACE USERS
DATAFILE '/u01/app/oracle/oradata/PROD1/users01.dbf' SIZE 64M AUTOEXTEND ON MAXSIZE 2G EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M SEGMENET SPACE MANAGEMENT MANUAL;
ALTER DATABASE DEFAULT TABLESPACE USERS;
CREATE TABLESPACE INDX
DATAFILE '/u01/app/oracle/oradata/PROD1/users01.dbf' SIZE 32M AUTOEXTEND ON MAXSIZE 2G EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT MANUAL;
CREATE BIGFILE TABLESPACE EXAMPLE
DATAFILE '/u01/app/oracle/oradata/PROD1/example01.dbf' SIZE 512M AUTOEXTEND ON MAXSIZE 8T EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE OLTP
DATEFILE '/u01/app/oracle/oradata/PROD1/oltp01.dbf' SIZE 64M AUTOEXTEND ON MAXSIZE 2G EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE BATCH
DATAFILE '/u01/app/oracle/oradata/PROD1/batch01.dbf' SIZE 128M AUTOEXTEND ON MAXSIZE 2G EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2M SEGMENT SPACE MANAGEMENT MANUAL;

临时表空间组

创建新临时表空间组

CREATE TEMPORARY TABLESPACE TMP1
TEMPFILE '/u01/app/oracle/oradata/PROD1/tmp1.dbf' SIZE 64M AUTOEXTEND ON MAXSIZE 2G EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
TABLESPACE GROUP TMPGRP;
CREATE TEMPORARY TABLESPACE TMP2
TEMPFILE '/u01/app/oracle/oradata/PROD1/tmp2.dbf' SIZE 64M AUTOEXTEND ON MAXSIZE 2G EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
TABLESPACE GROUP TMPGRP;
CREATE TEMPORARY TABLESPACE TMP3
TEMPFILE '/u01/app/oracle/oradata/PROD1/tmp3.dbf' SIZE 64M AUTOEXTEND ON MAXSIZE 2G EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
TABLESPACE GROUP TMPGRP;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TMPGRP;

完成！ 
今天的题目其实不难，主要是记住创建表空间的语句，漏掉条件的话，考试可是过不了的，尤其是那个bigfile
的tablespace
，如果没有加bigfile
标签，虽然创建过程不会报错，但是实际上dbf
文件最大也不会超过32g(块大小为8K的情况下)。