import dump issues

Posted by Roshan on May 30, 2018; 12:22pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/import-dump-issues-tp6118.html

Oracle Database 11.2.0.4

RHEL 6

 
Hi team,

I have imported 5 tables from a full export dump of a production on a test instance on DNRTOOL schema

 

impdp \"/ as sysdba\" directory=GCIDNR  file=$arch remap_schema=l2tcp:dnrtool tables=l2tcp.gci_preorde

r,l2tcp.gci_ref_bb_offer,l2tcp.gci_ref_billing_ticket,l2tcp.gci_iptv_zte,l2tcp.gci_premium_log log=impgci`(date +"%d%m

%Y%H%M")`.log

 

The export script is shown below.

expdp  \"/ as sysdba\" dumpfile=L2TCP`(date +"%d%m%Y%H%M")`.dmp logfile=L2TCPexpdp.`(date +"%d%m%Y%H%M")`.log FULL=Y parallel=2 directory=myexport

 

The issue is additional stored procedures, functions and views of l2tcp schema have also been imported on DNRTOOL schema. Is there a way I can remove them?


 

Regards,

Roshan