<div>
I don't understand the question.<br />
<br />
Without importing the tables how do you expect procedures to compile?<br />
<br />
Importing specific types of objects is described in the online docs. &nbsp;Is this the original exp/imp or the datapump expdp/impdp?<br />
<br />
What are you wanting to do?
</div>


I don't understand the question.

Without importing the tables how do you expect procedures to compile?

Importing specific types of objects is described in the online docs.  Is this the original exp/imp or the datapump expdp/impdp?

What are you wanting to do?

<div>
<div class="content wysiwyg-content">
Hello,<br />
I try to import a dump of a database 10G data to a database 11G data. No object is compressed yet the volume of objects increases. <br />
How can I import only all objects of a schema without indexes, tables and constraints? because I can not recompile all objects <br />
thank you
</div>
</div>


Hello,
I try to import a dump of a database 10G data to a database 11G data. No object is compressed yet the volume of objects increases. 
How can I import only all objects of a schema without indexes, tables and constraints? because I can not recompile all objects 
thank you

question about import dump with impdp

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.