Re: question about bigfile tablespaces at database create time.

From: Stefan Koehler <contact_at_soocs.de>
Date: Sat, 8 Aug 2015 10:45:58 +0200 (CEST)
Message-ID: <1000918819.44409.1439023558824.JavaMail.open-xchange_at_app03.ox.hosteurope.de>

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: _at_OracleSK

> Joshua Collier <jcoll1970_at_gmail.com> 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? 

 

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Aug 08 2015 - 10:45:58 CEST