Overriding the Default Tablespace Type (79)

The SYSTEM and SYSAUX tablespaces are always created with the default tablespace
type. However, you can explicitly override the default tablespace type for the UNDO
and DEFAULT TEMPORARY tablespace during the CREATE DATABASE operation.

For example, you can create a bigfile UNDO tablespace in a database with the default
tablespace type of smallfile as follows:

CREATE DATABASE rbdb1
...
BIGFILE UNDO TABLESPACE undotbs
DATAFILE '/u01/oracle/oradata/mynewdb/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

You can create a smallfile DEFAULT TEMPORARY tablespace in a database with the
default tablespace type of bigfile as follows:

CREATE DATABASE rbdb1
SET DEFAULT BIGFILE TABLSPACE
...
SMALLFILE DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/oracle/oradata/mynewdb/temp01.dbf'
SIZE 20M REUSE
...
覆蓋預設的臨時表空間檔案型別
1. 可為UNDO和DEFAULT TEMPORARY顯示的指定表空間檔案型別 ,
以此來覆蓋預設的表空間檔案型別

[@more@]