Messages Executing: Analyze "Database Connections\SDE_ACCOUNT.sde\DATA_OWNER_ACCOUNT.TABLE_NAME" BUSINESS Start Time: Tue Feb 05 07:20:10 2013 ERROR 999999: Error executing function. Underlying DBMS error [ORA-20000: Unable to analyze TABLE "DATA_OWNER_ACCOUNT"."TABLE_NAME", insufficient privileges or does not exist ORA-06512: at "SYS.DBMS_STATS", line 23818 ORA-06512: at "SYS.DBMS_STATS", line 23880 ORA-06512: at line 1 ] Failed to execute (Analyze). Failed at Tue Feb 05 07:20:11 2013 (Elapsed Time: 1.00 seconds)
Messages Executing: Analyze "Database Connections\DATA_OWNER_ACCOUNT.sde\DATA_OWNER_ACCOUNT.TABLE_NAME" BUSINESS;ADDS;DELETES Start Time: Tue Feb 05 07:19:31 2013 Succeeded at Tue Feb 05 07:19:33 2013 (Elapsed Time: 2.00 seconds)
Messages Executing: Analyze "Database Connections\SDE_ACCOUNT.sde\DATA_OWNER_ACCOUNT.TABLE_NAME" BUSINESS;FEATURE;ADDS;DELETES Start Time: Tue Feb 05 08:48:20 2013 ERROR 999999: Error executing function. Table is not multiversion, but must be for this operation Failed to execute (Analyze). Failed at Tue Feb 05 08:48:22 2013 (Elapsed Time: 2.00 seconds)
Solved! Go to Solution.
The SDE account should be very limited, and should NOT be able to update
statistics on spatial tables. The table owner should be the only account
used for statistics management.
- V
When you update the statistics for a feature dataset, statistics for all the feature classes in that feature dataset are updated. If the feature dataset contains a geometric network, the network tables are also updated.
You should update statistics before and after a compress operation, after you add or remove topology rules, and after you have finished importing, loading, or copying data into an ArcSDE geodatabase.
Note that the connected user must be the data owner for the datasets provided.