- silent mode 에서 일괄로 Big file 로 만드는 방법

- silent mode 에서 전부 Big file 로 만드는 방법 (Tablespace 별 개별적으로 true로 하지 않고)

1. Templates 화일의 최소 충족요건으로 변경

$ORACLE_HOME/assistants/dbca/templates/New_Database.dbt 화일내의 USERS tabllespace 의 datafile 최소크기를 최소 7M 로 변경함.

      <DatafileAttributes id="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/users01.dbf">
         <tablespace>USERS</tablespace>
         <temporary>false</temporary>
         <online>true</online>
         <status>0</status>
         <size unit="MB">7</size>
         <reuse>true</reuse>
         <autoExtend>true</autoExtend>
         <increment unit="KB">1280</increment>
         <maxSize unit="MB">-1</maxSize>
      </DatafileAttributes>

2. -useBigFileForTablespace 옵션 사용 
dbca -silent -createDatabase -gdbName BIGORCL -templateName New_Database.dbt -useBigFileForTablespace true


3. 확인
sys@BIGORCL> select TABLESPACE_NAME, BIGFILE from DBA_TABLESPACES;

TABLESPACE_NAME                BIG
------------------------------ ---
SYSTEM                         YES
SYSAUX                         YES
UNDOTBS1                       YES
TEMP                           YES
USERS                          YES