Re: default tablespace
- From: Kirtikumar Deshpande <kedeshpande@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Tue, 27 Sep 2005 06:03:58 -0700 (PDT)
> 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
Other related posts:
