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.