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

Home -> Community -> Usenet -> c.d.o.tools -> Re: PK Constraint tablespace usage question

Re: PK Constraint tablespace usage question

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: 2000/02/01
Message-ID: <3896E4A3.D49DBD8C@edcmail.cr.usgs.gov>#1/1 






> A primary key constraint always uses an index. If you use the 'USING

> INDEX TABLESPACE ...' clause with the constraint, this specifies which

> tablespace this index is created in. If you don't specify this clause,

> the index is created in the same tablespace as the table.




And then the default storage parameters for that tablespace are used.



HTH,



Brian
Received on Tue Feb 01 2000 - 00:00:00 CST












Original text of this message













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