Hi Joshua,
you can specify this tablespace attribute in the template file (*.dbt). Here is
just a snippet as an example:
--------------------------------------------------------------------------------------------------
<TablespaceAttributes id="UNDOTBS1">
...
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes
id="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/undotbs01.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
--------------------------------------------------------------------------------------------------
You can find an example template file in
"$ORACLE_HOME/assistants/dbca/templates/" and specify this template by using
the DBCA parameter
"-templateName".
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: @OracleSK
Joshua Collier <jcoll1970@xxxxxxxxx> hat am 7. August 2015 um 22:12
geschrieben:
I would like use dbca command line to make bigfile tablespace the default at
database creation time. I do not see an argument for this when I look
at the results of dbca -databaseCreate -help. Does anyone have any ideas how
to get this done?