Re: primary key indexes - where ???

seci_at_ludens.elte.hu wrote:

>hello,
 

>if i have a table with a primary key it is obvious that oracle will
>create an index (of course a unique one) to maintain this constraint
>(but if i look at user_indexes i cannot see this index).
 

>is it possible to define the name and the TABLESPACE and STORAGE of this
>kind of indexes or not?
 

>TIA
> peter

alter table T add constraint T_PK primary key (T_ID) using index storage (initial XXX next XXX ....) tablespace INDS;

Enjoy .....

+----------------------------------------
+ Michael Abbey    Ottawa Canada
+ msabbey_at_magi.com GMT -5
+
+ Co-author Tuning Oracle
+           Oracle: A Beginner's Guide
+           Oracle Data Warehousing
+----------------------------------------