Hi everyone!
So I've been trying to compare a table and view results using dbms_comparison. But when I execute the CREATE_COMPARISON sql I get this message: ora-23626 no eligible index on table. I've checked every constrant and index on tables (source and target). The CREATE_COMPARISON sql is:
BEGIN DBMS_COMPARISON.CREATE_COMPARISON
(
COMPARISON_NAME => 'EMPLOYEES_COMPARE_VIEW',
SCHEMA_NAME => 'HR' ,
OBJECT_NAME => 'EMPNEW' , -- It's a VIEW
REMOTE_SCHEMA_NAME => 'HR_COPY' ,
remote_object_name => 'EMPNEW' , -- It's a TABLE
COMPARISON_MODE => DBMS_COMPARISON.CMP_COMPARE_MODE_OBJECT,
DBLINK_NAME => NULL
); END;/
My doubt is: Can I do a compare between table and view? I've read every single word at Oracle Document and there's no clearly answer about that. There's no discuss about it on this forum.
So I'm gonna really appreciate any advices, tips or anything else can help me out. Thanks!