AnsweredAssumed Answered

ArcSDE - unable to compress state tree

Question asked by hammadem on Dec 8, 2014
Latest reply on Feb 10, 2015 by VMania

Good day,


i have been doing compress operations for years and i never stumbled about the issue i am reporting


sdeversion -o compress command is unable to compress state tree. below is what is reported


Error: Underlying DBMS error (-51).

Error: Unable to compress state tree.

ORA-00942: Table or view does not exist


i am running ArcSDE 931 on Oracle 11g R2 on Windows Server 2008


it is basically either the table or view does not exists or SDE does not see it. the question is what table or view am i looking for ? and what could have caused this to happen suddenly ?


appreciate any help