Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMPDP to import JAVA CLASS and JAVA SOURCE from .DMP file

854689May 31 2011 — edited Aug 24 2012

hi,

I have a schema X, In that schema some of the *"JAVA CLASS" and "JAVA SOURCE"* objects are missing ..
The procedures ,functions..etc objects were updated at X schema..
I have 1 dmp file of Y schema , containing the missing "JAVA CLASS" and "JAVA SOURCE" s.. Can I import the the same to the schema X using IMPDP

i tried using INCLUDE clause but it is not working
eg:

 impdp john1/john1@me11g22 directory=datadump dumpfile=DEVF2WAR.DMP remap_schema=devf2war:john INCLUDE="JAVA CLASS","JAVA CLASS"

but error..

ORA-39001: invalid argument value
ORA-39041: Filter  "INCLUDE" either identifies all object types or no object types.

regards,
jp

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 21 2012

Added on May 31 2011

#database-key-features, #export-import-sql-loader-external-tables

2 comments

15,114 views