<div>
faq: <a href="http://www.orafaq.com/faqiexp.htm" rel="ugc">http://www.orafaq.com/faqiexp.htm</a><br />
q2: imp .... &nbsp;tables=dept<br />

</div>


faq: http://www.orafaq.com/faqiexp.htm [http://www.orafaq.com/faqiexp.htm]
q2: imp ....  tables=dept


<div>
<div class="content wysiwyg-content">
I have a full export from .dmp file of my database. &nbsp;I just found out that a table that needs to be in the database is no longer there. &nbsp;I would like to know two things. &nbsp;First I would like to know how to get a list of the tables in a dump file and secod the command i would use to import just one table from the full export dmp file I have.<br />
Thanks.
</div>
</div>


I have a full export from .dmp file of my database.  I just found out that a table that needs to be in the database is no longer there.  I would like to know two things.  First I would like to know how to get a list of the tables in a dump file and secod the command i would use to import just one table from the full export dmp file I have.
Thanks.

import one table from full export .dmp

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.