primary key indexes - where ???
From: Charlie Crissman <ccriss_at_unf.edu>
Date: 1996/09/25
Message-ID: <3249525E.3F61_at_unf.edu>#1/1
constraint PRIMARY_KEY_NAME primary key (column_name) ###-----> using index tablespace 'INDEX_TABLESPACE_NAME' ###----> storage (index_storage_parameters) tablespace TABLE_TABLESPACE_NAME
storage (table_storage_parameters)
pctfree XX
pctused XX
;
Date: 1996/09/25
Message-ID: <3249525E.3F61_at_unf.edu>#1/1
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
Use the following when you create your table:
create table tablename
( column1 blah blah blah, column2 blah blah blah, columnn blah blah blah)
constraint PRIMARY_KEY_NAME primary key (column_name) ###-----> using index tablespace 'INDEX_TABLESPACE_NAME' ###----> storage (index_storage_parameters) tablespace TABLE_TABLESPACE_NAME
storage (table_storage_parameters)
pctfree XX
pctused XX
;
Charlie Crissman - Oracle DBA Barnett Bank, Jacksonville, FL Received on Wed Sep 25 1996 - 00:00:00 CEST