Hi all,
Is there a way to fix Delta Tables (Adds Table and Deletes Table), when they look in bad shape:
This is the result I see when executing: Analyze, and checking "Adds" in the component to analyze
Start Time: Fri Feb 18 08:19:14 2011
ERROR 999999: Error executing function.
Underlying DBMS error[ORA-20000: Unable to analyze TABLE "XXXX"."A1046", insufficient privileges or does not exist
ORA-06512: at "SYS.DBMS_STATS", line 13427
ORA-06512: at "SYS.DBMS_STATS", line 13457
ORA-06512: at line 1
]
Failed to execute (Analyze)
And This is the resul I see when executing: Analyze, and checking "Deletes" in the component to analyze
Start Time: Fri Feb 18 08:21:23 2011
ERROR 999999: Error executing function.
Underlying DBMS error[ORA-20000: Unable to analyze TABLE "XXXX"."D1046", insufficient privileges or does not exist
ORA-06512: at "SYS.DBMS_STATS", line 13427
ORA-06512: at "SYS.DBMS_STATS", line 13457
ORA-06512: at line 1
]
Failed to execute (Analyze).
