My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.