When I run the following code in sql*plus (login as system), it outputs the following error:
begin
 dbms_utility.analyze_schema('CLARK','COMPUTE');
end;
 
ORA-02074: cannot ANALYZE TABLE in a distributed transaction
ORA-06512: at "SYS.DBMS_DDL", line 179
ORA-06512: at "SYS.DBMS_UTILITY", line 472
ORA-06512: at line 2

Anyone knows what is this? My Oracle 9.2 is running on Windows XP Prof.

Thanks,

Eric

Reply via email to