Maybe Oracle will add a default index tablespacce to user. On 9/27/05, Kirtikumar Deshpande <kedeshpande@xxxxxxxxx> wrote: > > > 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 > -- Welcome, Fangxin.Lou from China MYDUL, alternative to DUL !!! Home: http://www.anysql.net/en/ Mydul: http://www.anysql.net/en/mydul.html