primary key indexes - where ???

From: Charlie Crissman <ccriss_at_unf.edu>
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

Original text of this message