Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: default index tablespace?

Re: default index tablespace?

From: Ted Knijff <knijff_at_bigfoot.com>
Date: Thu, 28 Dec 2000 08:01:40 GMT
Message-ID: <3a4af292.1740522@news.online.de>

AFAIK the default tablespace for an index ist the one used for the table = default tablespace for the user if not specifically stated in the CREATE statement.

Ted

On Thu, 28 Dec 2000 03:39:31 GMT, wutang_warrior_at_my-deja.com wrote:

>Must I specify the tablespace for my indexes with all my DDL?
>isn't there a default_index_tablespace for dba_users?
>
>What about the different names given to the Index tablespace between
>Oracle versions? can I just change it to whatever I like when creating
>my DB or do catalog.sql, catproc.sql, etc... rely on it? I suppose
>their indexes just sit in the SYSTEM tablespace....
>
>
>
>
>Sent via Deja.com
>http://www.deja.com/

EMail: knijff_at_bigfoot.com Received on Thu Dec 28 2000 - 02:01:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US