Re: Tablespace for primary Key

From: Eugeny Naidenov <naidenov_at_inkasbank.ru>
Date: Fri, 08 Oct 1999 09:43:05 +0400
Message-ID: <37FD8469.B6073171@inkasbank.ru>

You can do it in create table statment. For example: Create table test
(

  Id      NUMBER  CONSTRAINT consname PRIMARY KEY
                             USING INDEX PCTFREE 5 TABLESPACE tsforindex
                             STORAGE ( INITIAL 8K NEXT 8K ),

 .......
 .......

regards,
Eugeny Naidenov

Shi yousong wrote:

> Hi,
> I have a silly question here. Oracle treats the primary Key of a table
> as index. So the default storage location should be the same with the
> data segment of the table. What shall I do if I want to specify a
> different location for the implicit index? Can I do that ? I can not
> find a correspondent method to do this in Enterprise Manager or other
> GUI tool.
>
> regards,
>
> Sam Shi
Received on Fri Oct 08 1999 - 00:43:05 CDT