• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4233
  • Last Modified:

Duplicating a profile in a different database

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.

1 Solution
The simplest solution, may be...


The effect of this is to create the profile with "all default limits"  once you have this it will avoid the error on the impdp.

If you want to make the profiles match, then on the source system, do

select * from dba_profiles where profile='SALES_PROFILE' and not limit='DEFAULT'

and then make the corresponding ALTER PROFILE SALES_PROFILE LIMIT <parameter>=<value>.

Commonly profiles are used to limit the maximum number of sessions per user or maximum CPU utilization per query.  Part of your testing may be to validate these limits in your test environment.
VimrulAuthor Commented:
Thank a lot.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now