Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how would i compare if two indexes are identical?

Erhan_torontoJul 24 2013 — edited Jul 31 2013

I like to compare if two indexes from both users are identical. Is there any way to to that. I need similer to below query:

select CASE (2*(select count(*) from (select * from XPKTBL_A INTERSECT select * from XPKTBL_A )) - (select count(*) from XPKTBL_A ) - (select count(*) from XPKTBL_A )) WHEN 0 THEN 'Indexes are identical' ELSE 'Indexes are different' END "Result" from  DUAL;

UserA:

create table TBL_A (       FIELD_A1 number not null,

FIELD_A2 varchar2(50),

FIELD_A3 date,

FIELD_A4 number(5,2) default 0,

FIELD_A5 varchar2(10) not null

                                );

                                create unique index XPKTBL_A on TBL_A (FIELD_A1);

UserB:

create table TBL_A (       FIELD_A1 number not null,

FIELD_A2 varchar2(20),

FIELD_A4 number(5,2) not null,

FIELD_A5 varchar2(10),

FIELD_A6 number(2) not null

                                );

                                create unique index XPKTBL_A on TBL_A (FIELD_A1, FIELD_A6);

This post has been answered by Erhan_toronto on Jul 30 2013
Jump to Answer

Comments

Hi Volker,

can you run the login page in debug mode (LEVEL9) to see what happens? I first thought this could be bug #14798940 but in that case the problem would have gone away after saving the authentication scheme.

Regards,
Christian
99770
Ho to do Level 9 Debug?
Hi Volker,

the app's URL will look a bit like this:

http://host:port/apex/f?p=app:page:session::NO::

Change NO to LEVEL9. Before 4.2, you could only say YES, which is level 4, or NO. LEVEL9 gives the most detailed output.

Regards,
Christian
99770
error:ORA-24247: network access denied by access control list (ACL), backtrace:ORA-06512: at "SYS.DBMS_LDAP_API_FFI", line 25 ORA-06512: at "SYS.DBMS_LDAP", line 48 ORA-06512: at "APEX_040200.WWV_FLOW_CUSTOM_AUTH_LDAP", line 45
Hi,

the post-installation steps described here

http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/otn_install.htm#BEHHJJIH

to configure the ACL for APEX_040200 seem to be missing.

Regards,
Christian
99770
Hi Christian,

many thanks to you. Now it works.
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 28 2013
Added on Jul 24 2013
25 comments
1,891 views