From oracle-l-bounce@freelists.org  Tue Sep 27 04:30:18 2005
Return-Path: <oracle-l-bounce@freelists.org>
Received: from air891.startdedicated.com (root@localhost)
 by orafaq.com (8.12.10/8.12.10) with ESMTP id j8R9UC3D008016
 for <oracle-l@orafaq.com>; Tue, 27 Sep 2005 04:30:17 -0500
X-ClientAddr: 206.53.239.180
Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180])
 by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8R9Tx6H007951
 for <oracle-l@orafaq.com>; Tue, 27 Sep 2005 04:29:59 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A9C6D1EF3A7;
 Tue, 27 Sep 2005 04:29:54 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 12707-04; Tue, 27 Sep 2005 04:29:54 -0500 (EST)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2F9471EF3A6;
 Tue, 27 Sep 2005 04:29:54 -0500 (EST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=qONyPd4Z+/yYeAcHxOty/FpiH+Q0SH4/2l6ys10FHpcNTaQZao3abOqhOQx0+BbJLdBZjWG1N89OYT6GM7mGU0vz5C7q6TzwWssNps9VJUhwsWs4kJiszx88JLGiDAbK9GeT4+qJYebjdgQNpYOMNWh0hlbAEKoap2oyIlk1438=
Message-ID: <7765c897050927022761a17d72@mail.gmail.com>
Date: Tue, 27 Sep 2005 10:27:54 +0100
From: Niall Litchfield <niall.litchfield@gmail.com>
To: jdunn@sefas.com
Subject: Re: default tablespace
Cc: Oracle-L@freelists.org
In-Reply-To: <000401c5c344$15484f20$3e04050a@johnman>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_12820_9941297.1127813274630"
References: <000401c5c344$15484f20$3e04050a@johnman>
X-archive-position: 25924
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-To: oracle-l-bounce@freelists.org
X-original-sender: niall.litchfield@gmail.com
Precedence: normal
Reply-To: niall.litchfield@gmail.com
X-list: oracle-l
X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net
X-mailscan-MailScanner-Information: Please contact the ISP for more information
X-mailscan-MailScanner: Found to be clean
X-MailScanner-From: oracle-l-bounce@freelists.org
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on 
 air891.startdedicated.com
X-Spam-Status: No, hits=-3.2 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE 
 autolearn=ham version=2.63
------=_Part_12820_9941297.1127813274630
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

any object that requires physical storage will be created in the default
tablespace unless otherwise specified
(TABLE,INDEX,CLUSTER,MATERIALIZED VIEW etc), logical objects
(views,procedures etc) get stored in the data dictionary and so reside in
objects in the SYSTEM tablespace.
 cheers
 Niall

 On 9/27/05, John Dunn <jdunn@sefas.com> wrote:
>
> What database objects are created in the default tablespace?
>
> If I create a table, is both the index and the table created in the
> default
> tabalespace?
>
> Platform is Oracle 9.2
>
>
>
> John Dunn
>
> --
> http://www.freelists.org/webpage/oracle-l
>



--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

------=_Part_12820_9941297.1127813274630
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<div>any object that requires physical storage will be created in the defau=
lt tablespace unless otherwise specified</div>
<div>(TABLE,INDEX,CLUSTER,MATERIALIZED VIEW etc), logical objects (views,pr=
ocedures etc) get stored in the data dictionary and so reside in objects in=
 the SYSTEM tablespace. </div>
<div>&nbsp;</div>
<div>cheers</div>
<div>&nbsp;</div>
<div>Niall<br><br>&nbsp;</div>
<div><span class=3D"gmail_quote">On 9/27/05, <b class=3D"gmail_sendername">=
John Dunn</b> &lt;<a href=3D"mailto:jdunn@sefas.com">jdunn@sefas.com</a>&gt=
; wrote:</span>
<blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">What database objects are create=
d in the default tablespace?<br><br>If I create a table, is both the index =
and the table created in the default
<br>tabalespace?<br><br>Platform is Oracle 9.2<br><br><br><br>John Dunn<br>=
<br>--<br><a href=3D"http://www.freelists.org/webpage/oracle-l">http://www.=
freelists.org/webpage/oracle-l</a><br></blockquote></div><br><br clear=3D"a=
ll">
<br>-- <br>Niall Litchfield<br>Oracle DBA<br><a href=3D"http://www.niall.li=
tchfield.dial.pipex.com">http://www.niall.litchfield.dial.pipex.com</a>=20

------=_Part_12820_9941297.1127813274630--
--
http://www.freelists.org/webpage/oracle-l