<div>
<div class="content wysiwyg-content">
Dear all,<br />
I have a schema (incentive) in dev database. Incentive schema has been assigned a profile &quot;sales_profile&quot; . I exported the full schema to test database using datapump &nbsp;tool with parameter NETWORK_LINK. (initiated the export from Test database being the local)<br />
Now I am trying to import and remap the schema to a new user called Test_Incentive in the test database. I am receiving the error &quot;&nbsp;ORA-02380: Profile Sales_Profile doesn't exist&quot;<br />
Question#1 : Can't I remap the schema if the schema is part of a profile and that profile doesn't exist in the new database?<br />
Question #2: If that is the case than I want to duplicate the schema in my test database - how do I duplicate the profile in the Test database?<br />
Thanks a lot in advance.<br />
<br />
<br />

</div>
</div>


Dear all,
I have a schema (incentive) in dev database. Incentive schema has been assigned a profile "sales_profile" . I exported the full schema to test database using datapump  tool with parameter NETWORK_LINK. (initiated the export from Test database being the local)
Now I am trying to import and remap the schema to a new user called Test_Incentive in the test database. I am receiving the error " ORA-02380: Profile Sales_Profile doesn't exist"
Question#1 : Can't I remap the schema if the schema is part of a profile and that profile doesn't exist in the new database?
Question #2: If that is the case than I want to duplicate the schema in my test database - how do I duplicate the profile in the Test database?
Thanks a lot in advance.




Duplicating a profile in a different database

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.