Search code examples
sqloracle-databaseoracle-sqldevelopersql-navigator

error when use Sql Navigator

I have error when using tool Sql Navigator 6.2.1: I run command in Sql Navigator it alert error: "ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_UTILITY", line 140 ORA-06512: at line 6"

desc com.zsdddept;

com.zsdddept is table and when i run select command its no error and click table name show properties of table in Sql Navigator no action.

But i run above command in Oracle Sql developer (same user) result no error and show description fields.

What's the reason?

Thanks

Solution

  • The desc command is not a SQL standard. desc is the sqlplus command. SQL Developer runs a big sql query and sql navigator a simple sql query. SQL Navigator® for Oracle Version 6.2.1 does not support ORACLE version 11.2.

    SQL Navigator® for Oracle Version 6.2.1 Release Notes Release Notes September 2009.

    Oracle Database 11g Release 2 (11.2.0.1) 2 April 2010

    You need to buy and install the latest version of SQL Navigator or use the free version of sqlplus or Oracle SQL Developer.