Re: default tablespace

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



--
Welcome, Fangxin.Lou from China
MYDUL, alternative to DUL !!!
Home: http://www.anysql.net/en/
Mydul: http://www.anysql.net/en/mydul.html

Other related posts: