Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Create table, pk constraint, AS SELECT, Index Org tables
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