Return-Path: <oracle-l-bounce@freelists.org>
X-Original-To: oracle-l@orafaq.com
Delivered-To: oracle-l@orafaq.com
Received: from puck1183.startdedicated.com (localhost [127.0.0.1])
 by puck1183.startdedicated.com (Postfix) with ESMTP id CFB8E1960FD3
 for <oracle-l@orafaq.com>; Sat,  8 Aug 2015 10:47:23 +0200 (CEST)
Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180])
 by puck1183.startdedicated.com (Postfix) with ESMTP
 for <oracle-l@orafaq.com>; Sat,  8 Aug 2015 10:47:23 +0200 (CEST)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7B9EA2E71B;
 Sat,  8 Aug 2015 04:47:22 -0400 (EDT)
X-Virus-Scanned: Debian amavisd-new at turing.freelists.org
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 4wf-IYnl8-NG; Sat,  8 Aug 2015 04:47:22 -0400 (EDT)
Received: from turing.freelists.org (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DA4722E1A8;
 Sat,  8 Aug 2015 04:46:41 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 08 Aug 2015 04:46:01 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7AD882BE46
 for <oracle-l@freelists.org>; Sat,  8 Aug 2015 04:46:00 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id t2lnHy-VkxTx for <oracle-l@freelists.org>;
 Sat,  8 Aug 2015 04:46:00 -0400 (EDT)
Received: from wp021.webpack.hosteurope.de (wp021.webpack.hosteurope.de [80.237.132.28])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CF4BC2BD8A
 for <oracle-l@freelists.org>; Sat,  8 Aug 2015 04:45:59 -0400 (EDT)
Received: from app03.ox.hosteurope.de ([92.51.170.10]); authenticated
 by wp021.webpack.hosteurope.de running ExIM with esmtpsa (TLS1.0:RSA_ARCFOUR_MD5:16)
 id 1ZNzlO-0006Rg-Qe; Sat, 08 Aug 2015 10:45:58 +0200
Date: Sat, 8 Aug 2015 10:45:58 +0200 (CEST)
From: Stefan Koehler <contact@soocs.de>
To: "oracle-l@freelists.org" <oracle-l@freelists.org>, jcoll1970@gmail.com
Message-ID: <1000918819.44409.1439023558824.JavaMail.open-xchange@app03.ox.hosteurope.de>
In-Reply-To: <CAMiRvoGKpC37Lz0xFcoienF13KZ9=qgJC25Txag4AJzfBvVPmA@mail.gmail.com>
References: <CAMiRvoGKpC37Lz0xFcoienF13KZ9=qgJC25Txag4AJzfBvVPmA@mail.gmail.com>
Subject: Re: question about bigfile tablespaces at database create time.
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Originating-Client: com.openexchange.ox.gui.dhtml
X-bounce-key: webpack.hosteurope.de;contact@soocs.de;1439023559;4b8d9bb8;
X-archive-position: 61101
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: contact@soocs.de
Precedence: normal
Reply-To: contact@soocs.de
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:mark.bobak@proquest.com>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l

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@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