<div>
Remember that 10g forward, Oracle provides a recycle bin to keep dropped tables safe until the bin is purged. &nbsp;This does not address your speciifc question but rather serves a buffer zone for your whoops.<br />
&nbsp;<br />

</div>


Remember that 10g forward, Oracle provides a recycle bin to keep dropped tables safe until the bin is purged.  This does not address your speciifc question but rather serves a buffer zone for your whoops.
 


<div>
<div class="content wysiwyg-content">
I am writing a script to clean up some unwanted tables in mu database. I grabbed the names of tables using regex. But before i drop them i want to make sure they are not used by any procedure or function in my script. Is there a way to do it?
</div>
</div>


I am writing a script to clean up some unwanted tables in mu database. I grabbed the names of tables using regex. But before i drop them i want to make sure they are not used by any procedure or function in my script. Is there a way to do it?

How to know if a table is used by any object

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.