Re: default tablespace

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

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