Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 7 equivalent of Organizational Index
If I understand you correctly, the only option is to create a full-table index in version 7 (as well as a unique index on the primary key if you want to enforce uniqueness at the database level rather than by program).
Pretty huge waste of space, which is partly why Oracle 8 introduced IOTs.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
vikas_kumar_at_inf.com wrote in message <7pjugo$vf2$1_at_nnrp1.deja.com>...
>I was using oracle 8.0.3 which has Organizational index for primary
>keys.Now i am shifting the database to Oracle 7.3.4(workgroup) However
>this feature does not seem to be there in Oracle. A lot of my
>application is based on the fact that tables have organizational index.
>is there some equivalent or workaround in Oracle 7.3.4
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Fri Aug 20 1999 - 11:37:31 CDT