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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 7 equivalent of Organizational Index

Re: Oracle 7 equivalent of Organizational Index

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 20 Aug 1999 17:37:31 +0100
Message-ID: <935167435.21250.0.nnrp-02.9e984b29@news.demon.co.uk>

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

Original text of this message

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