title: How to exclude and lookup the value of RecycleBin in Oracle
body: <p>When querying constraints in Oracle 11g, execute the following query.</p>
  <pre><code>SELECT 
                  CC.OWNER as &quot;owner&quot;
              ,   CC.TABLE_NAME as &quot;tableName&quot;
              ,   CC.COLUMN_NAME as &quot;columnName&quot;
              ,   CC.CONSTRAINT_NAME as &quot;constraintName&quot;
              ,   CC.POSITION as &quot;position&quot;
      FROM ALL_CONS_COLUMNS CC 
      WHERE CC.OWNER IN ('&lt;schemaName&gt;')
      ORDER BY CC.POSITION ASC;
  </code></pre>
  <p>However, the data in recyclebin is also searched as shown below.
  (For reference, the owner in the figure below is the schema name Docker.)</p>
  <p><a href="https://i.stack.imgur.com/O1Hn6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/O1Hn6.png" alt="enter image description here" /></a></p>
  <p>I'm running on Mac OS Docker. Does it appear because it is a Docker environment?</p>
  <p>I don't need this data at all, so I want to check it out.</p>
  <p>Any way other than clearing the data in recyclebin with <strong>purge recyclebin</strong> command?</p>