Index organised on non Primary Index possible?

Hi I don't want to bother with Varrays or neseted tables, so I tought an index organised table looks a good candidate due to its storage advantages etc.

However, the examples I've seen use a Primary key.

But my target table has a non-unique index.

Can it be done (or similar) on a non-unique index?

If so, please give an example or suggest an alternative.

Thanks Received on Mon Aug 23 2004 - 08:20:21 CDT