Re: default tablespace

From: Kirtikumar Deshpande <kedeshpande_at_yahoo.com>
Date: Tue, 27 Sep 2005 06:03:58 -0700 (PDT)
Message-ID: <20050927130358.85260.qmail@web50108.mail.yahoo.com>

> 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_at_gmail.com> 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_at_sefas.com> 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

Received on Tue Sep 27 2005 - 08:06:06 CDT