Compare User objects returns an error ORA-00942

[Tigua]

When trying to use the "Compare User Objects" I'm able connect to the target session but when I try to select the target schema next error is prompted "ORA-00942: table or view does not exist"

The problem is probably related to missing privileges. Which views and tables are accessed when one tries to select the target schema in the tool "Compare User Objects"?

Thanks in advance.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[Tigua]

Cause of the error is missing read access on the view sys.dba_users. PL/SQL Developer is executing next query:

SQL = select username from sys.dba_users
union all
select 'PUBLIC' username from dual order by 1

--------------------------------
Eddy Nijs
Global Business Technologies

 

[Marco Kalter]

There are 2 ways to fix this:

1. Obtain select privileges on this view.
2. Go to Tools > Preferences > Oracle / Options and disable the "Use DBA views if available" option.