-
how to import procedures and triggers
Dear all,
I am trying to perform schemas refresh of my development database with my production database. However when I datapump my data using expdp and impdp I find that I am missing a lot of objects. This is my script to expdp and impdp in 10g R2:
expdp / directory=PROD_DP_DIR dumpfile=prod_ref.dmp schemas=state,scott,employee parallel=2
impdp / dumpfile=prord_ref.dmp directory=DEV_DP_DIR schemas=state,scott,employee logfile=dev.log parallel=2
In production, I have these counts for my state schemas objects:
OBJECT_TYPE COUNT(*)
------------------- ----------
INDEX 16
PROCEDURE 3
TABLE PARTITION 65
TABLE 129
VIEW 27
FUNCTION 1
MATERIALIZED VIEW 4
In development, my object count for this state schemas are:
OBJECT_TYPE COUNT(*)
------------------- ----------
INDEX 10
TABLE PARTITION 65
TABLE 129
Now I need to import these objects which includes views, function, materialized views, procedures, and index. Please advise how I can do that?
Thanks,
Unna.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|