<div>
The roles are different objects and are not included in schema exports. You need to create required roles before importing.<br />
<br />
R.
</div>


<div>
What other objects are not imported in schema exports ?<br />

</div>


<div>
<div class="content wysiwyg-content">
We are performing datapump export import from 10.2.0.4 non rac to 11.2.0.1 rac .<br />
This is a small database of 15Gb. We have tired creating the tablespaces and users and then importing the dump to target with onlythe schemas/users . This is causing the failure of importing roles.Why are the roles not imported?<br />

</div>
</div>


We are performing datapump export import from 10.2.0.4 non rac to 11.2.0.1 rac .
This is a small database of 15Gb. We have tired creating the tablespaces and users and then importing the dump to target with onlythe schemas/users . This is causing the failure of importing roles.Why are the roles not imported?


The roles are different objects and are not included in schema exports. You need to create required roles before importing.

R.

What other objects are not imported in schema exports ?


datapump export import from 10g to 11g rac

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.