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

Home -> Community -> Usenet -> c.d.o.server -> Create table, pk constraint, AS SELECT, Index Org tables

Create table, pk constraint, AS SELECT, Index Org tables

From: Yosi Greenfield <ygreenfield_at_compuserve.com>
Date: Wed, 03 Nov 1999 10:10:08 -0500
Message-ID: <38205050.8B785D2F@compuserve.com>


Wise Colleagues,

Is it possible to declare, at table creation time, a PK constraint on a table created using an AS SELECT clause?

Normally, that shouldn't be an issue, you can create the table an then alter it to add the PK.

However for index organized tables, you have to create the PK constraint at table creation. Does this mean that for IOTables you can't use the AS SELECT clause?

Thanks,

Yosi

create an index organized table using an AS SELECT clause?

To create an IOT, you have to declare a PK in the creation, and you need an ORGANIZATION INDEX clause. No matter how I Received on Wed Nov 03 1999 - 09:10:08 CST

Original text of this message

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