Clicking the SQL tab to generate DDL for certain views in SQL Developer gets error ORA-31603 (Doc ID 1185443.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle SQL Developer - Version 1.5 to 4.0 [Release 1.5.0 to 4]
Information in this document applies to any platform.
Using SQL Developer 1.5 or 2.1 and clicking the SQL tab to generate DDL for certain views in SQL Developer, error messages could appeared under certain conditions and you will not be able to see the SQL code.

***Checked for relevance on 25-09-2013***

Symptoms

Using SQL Developer 1.5 or 2.1 and clicking the SQL tab to generate DDL for certain views in SQL Developer,  the following error messages could appeared under certain conditions: 
 
ORA-31603: object "LOCATIONS" of type TABLE not found in schema "XXXXX"
ORA-6512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-6512: at "SYS.DBMS_METADATA", line 3261
ORA-6512: at "SYS.DBMS_METADATA", line 4863
ORA-6512: at line 1
 
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms