Re: default tablespace

> 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
> >
> > --
> > http://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
--
http://www.freelists.org/webpage/oracle-l

Other related posts: