Re: default tablespace
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: jdunn@xxxxxxxxx
- Date: Tue, 27 Sep 2005 10:27:54 +0100
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@xxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
Other related posts:
