Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01006 BIND variable does not exist

3566713Oct 1 2018 — edited Jul 29 2020

Dear Gurus,

When we query dba_constaints from sqlplus we get the required result but as soon as we click on "CONSTRAINTS" tab in SQL developer we get the error ORA-01006.

The issue is only in PDB and working fine in CDB of the same database.Really appreciate the help GURUs are providing each and every time.

SQL> select CONSTRAINT_NAME from dba_constraints where owner='DBSNMP' and table_name='BSLN_METRIC_DEFAULTS';

CONSTRAINT_NAME

--------------------------------------------------------------------------------------------------------------------------------

SYS_C004791

SYS_C004792

SYS_C004793

BSLN_METRIC_DEFAULTS_PK

Error-1.JPGError-2.JPG

This post has been answered by thatJeffSmith-Oracle on Oct 1 2018
Jump to Answer
Comments
Post Details
Added on Oct 1 2018
2 comments
960 views