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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Specifying default tablespaces for indexes

Re: Specifying default tablespaces for indexes

From: David Sharples <davidsharples_at_gmail.com>
Date: Wed, 15 Jun 2005 15:06:54 +0100
Message-ID: <be592d55050615070636a12e3@mail.gmail.com>


Hi John, Im afraid you cant have a default index tablespace, have to specify it on the create command if you want a different tablespace

On 6/15/05, John Dunn <jdunn_at_sefas.com> wrote:
> When I create a user is it possible to specify a default tablespace for
> indexes that is different from the default tablespace for tables?. Or can=
 I
> only specify a different tablespace for indexes when I create the index?

>=20

> This is Oracle 9.2

>=20
> John
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 15 2005 - 10:12:03 CDT

Original text of this message

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