how to fix Delta Tables (Adds Table and Deletes Table).

JoseSanchez — Fri, 18 Feb 2011 11:22:33 GMT

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).

Re: how to fix Delta Tables (Adds Table and Deletes Table).

JoseSanchez — Fri, 18 Feb 2011 11:31:43 GMT

In this case there are some invalid rows in the table

http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=34133

topic Re: how to fix Delta Tables (Adds Table and Deletes Table). in Data Management Questions

how to fix Delta Tables (Adds Table and Deletes Table).

Re: how to fix Delta Tables (Adds Table and Deletes Table).