> tablespace unless otherwise specified .... and the owner of such objects must have proper privileges to create those in other tablespaces. Cheers! - Kirti --- Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote: > 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 > __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l