Hello Dear all ,
I am trying to Import existing objects from one schema to other schema of different databases. I am trying to import a procedure of same name which exists in both schemas.
Note : Both databases are installed in same windows and version of both databases is
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
Can anyone just let me know as whether its possible to replace this object ..
I am aware about table_exists_action=REPLACE command which is applicable to TABLES alone but i need to know is it possible for objects or els only option is to drop from one schema and import it to other.
My try was in this way after taking EXPORT
impdp dumpfile=nitprk1.dmp logfile=nit_tst_imp11.log directory=DATA_PUMP_DIR remap_schema=nitprk:nitprk table_exists_action=REPLACE
But it didnt work out since table_exists_action is only applicable to tables only and not to objects.
So i received error saying as mentioned below :
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
ORA-31684: Object type PROCEDURE:"NITPRK"."ABC" already exists
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Job "SYS"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 12:33:08
Please kindly help me and any suggestions are welcome and appreciate it ..
Thanks & Regards,
Nitesh.