2 Replies Latest reply on Oct 1, 2018 12:10 PM by thatJeffSmith-Oracle

    ORA-01006 BIND variable does not exist

    3566713

      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