We have a few Oracle 11g databases deployed to a SLES 11 environment that are running ArcSDE 10.0 SP4Here is the message I get when I try to run the 'Analyze' tool using the 'sde' account (using ArcGIS Desktop 10.0 SP4): 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)
I can successfully run the 'Analyze' tool using the data owner account: 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)
I had my oracle DBA grant the 'ANALYZE ANY' priv to the 'sde' account and now get the following error when trying to Analyze with the 'sde' account: 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)
I can still successfully Analyze with the data owner account, but it seems that I should be able to do this with the sde admin account as well. Documentation on the Analyze tool: http://help.arcgis.com/en/arcgisdesktop/10.0/help/#/Analyze/0017000000n2000000/Any help/advise? I've worked the data owner account into our Analyze->Compress->Analyze workflows, but we will run into some of these issues when we have more than 1 data owner and the tables that are registered as versioned and are being edited. It almost seems that the 'sde' account does not quite see the 'a' and/or 'd' tables (delta tables). Maybe? Thanks in advance!