>> In this scenario i took full backup using full=y option in Data-pump and then imported only one SCHEMA from this full=y dump.
D:\partexp>expdp dumpfile=partexp directory=partexp full=y
;;;
Export: Release 11.2.0.3.0 - Production on Sun Nov 29 15:19:41 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/******** dumpfile=partexp directory=partexp full=y
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 8.001 GB
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/TRIGGER
Processing object type DATABASE_EXPORT/SCHEMA/EVENT/TRIGGER
Processing object type DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW
Processing object type DATABASE_EXPORT/SCHEMA/JOB
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/AUDIT
. . exported "IDMS7"."TBL_HIJRI_CONTROLS" 843.4 MB 1707258 rows
. . exported "HMIS"."AHTRNHST" 501.3 MB 2052541 rows
. . exported "HMIS"."AHTRNHST_B4_OPENING_FINAL_BILL" 499.6 MB 2011846 rows
. . exported "HMIS"."SHSHTDTA" 441.4 MB 5056869 rows
. . exported "HMIS"."OTOCURNC" 411.0 MB 3005537 rows
. . exported "IDMS7"."GLDOCENT" 67.03 KB 301 rows
. . exported "HMIS"."AHTRNHST_20141107" 239.9 MB 986375 rows
. . exported "IDMS7"."ACRTEMP1" 1011. KB 5476 rows
. . exported "IDMS7"."INVSRVITM" 144.8 MB 859728 rows
. . exported "HMIS"."OTORDERS" 117.3 MB 548755 rows
. . exported "HMIS"."MMTRACK_BKUP" 151.1 MB 1807951 rows
. . exported "HMIS"."PHTRNHST" 149.4 MB 1148369 rows
. . exported "HMIS"."SHDESCPT" 95.24 MB 746 rows
. . exported "IDMS7"."INVSRVITM_HAYA" 130.7 MB 775874 rows
. . exported "IDMS7"."GLWORKFD_TMP_D" 99.57 MB 339331 rows
. . exported "HMIS"."MJBAKBON" 17.72 MB 174391 rows
. . exported "HMIS"."HMIS_AUDIT_TRAIL" 60.72 MB 205266 rows
. . exported "IDMS7"."GLDOCHDR" 24.50 KB 31 rows
. . exported "IDMS7"."PHTRNHST_B4_ALI_MIG" 56.69 MB 447149 rows
. . exported "HMIS"."AMPATBIO" 269.8 KB 622 rows
. . exported "IDMS7"."CSH_TRN" 22.47 KB 18 rows
. . exported "IDMS7"."GLWORKFD" 11.05 MB 33734 rows
. . exported "IDMS7"."GLWORKFD_TMP_G" 6.794 MB 21790 rows
. . exported "IDMS7"."GLWORKFH" 1.629 MB 11978 rows
. . exported "IDMS7"."GL_DTLBCH" 459.5 KB 1856 rows
. . exported "IDMS7"."GL_MSTBCH" 315.7 KB 1256 rows
. . exported "IDMS7"."INVDTL" 456.0 KB 4131 rows
. . exported "IDMS7"."INVHDR" 1.104 MB 4041 rows
. . exported "IDMS7"."TOTTAB1" 12.38 MB 103487 rows
. . exported "SAM"."OTORDERS" 1.602 MB 8068 rows
. . exported "HMIS"."AHTRNHST_11102014" 50.04 MB 207847 rows
. . exported "HMIS"."MMMEDFILLOC" 224.9 KB 2314 rows
. . exported "HMIS"."AMIDCARD" 118.0 KB 622 rows
. . exported "HMIS"."ERR_TXT" 101.3 KB 1128 rows
. . exported "HMIS"."FIELDDESC" 118.2 KB 2902 rows
. . exported "HMIS"."IV_PRICES" 45.59 KB 653 rows
. . exported "CMIS"."ENDOCSTP" 52.11 KB 845 rows
. . exported "CMIS"."P_STAMP" 65.05 KB 5628 rows
. . exported "CMIS"."SPECIALEXAM" 89.82 KB 2363 rows
. . exported "CMIS"."TABLEDIC" 82.46 KB 1313 rows
. . exported "CMIS"."TYFINTRT" 51.21 KB 1003 rows
. . exported "CMIS"."WEBCAT" 14.56 KB 33 rows
. . exported "HMIS"."AHLOCHST" 98.78 KB 1473 rows
. . exported "HMIS"."AMADTPRC" 71.78 KB 1772 rows
. . exported "HMIS"."AMADTPRC_BACKUP_INACTIVE" 71.70 KB 1770 rows
. . exported "HMIS"."AMCHCOSN" 63.09 KB 1302 rows
. . exported "HMIS"."AMINSCMP" 16.33 KB 10 rows
. . exported "HMIS"."AMPAKAGE" 19.82 KB 23 rows
. . exported "HMIS"."AMPATACT_B4_OPENING_FINAL_BILL" 97.36 KB 567 rows
. . exported "HMIS"."AMPATBIO_MAK" 106.5 KB 176 rows
. . exported "HMIS"."AMRABCNS" 62.98 KB 293 rows
. . exported "HMIS"."DRUG_CONVER" 85.33 KB 1183 rows
. . exported "HMIS"."G_BOOKS" 51.81 KB 1000 rows
. . exported "HMIS"."G_CUSTOMERS" 63.75 KB 1000 rows
. . exported "IDMS7"."PRPAYROL" 110.7 KB 913 rows
. . exported "IDMS7"."PRPAYROL_12JAN2015" 78.53 KB 533 rows
. . exported "IDMS7"."PRPOSTBAL" 74.67 KB 1565 rows
. . exported "IDMS7"."PRVARCNT" 65.37 KB 774 rows
. . exported "IDMS7"."PRVARVAC" 58.23 KB 541 rows
. . exported "IDMS7"."PYALLF" 62.77 KB 1338 rows
. . exported "IDMS7"."PYTMPCSH" 71.64 KB 368 rows
. . exported "IDMS7"."TBL_ENTRY" 82.30 KB 626 rows
. . exported "IDMS7"."TBL_ENTRY_ABANAMY" 84.46 KB 662 rows
. . exported "IDMS7"."TBL_EQT_ABANAMY" 94.37 KB 1548 rows
. . exported "IDMS7"."TBL_IND" 78.71 KB 457 rows
. . exported "IDMS7"."TBL_IND_ABANAMY" 76.17 KB 437 rows
. . exported "IDMS7"."TYUSRPRF" 42.84 KB 193 rows
. . exported "SYSMAN"."MGMT_ARU_PRODUCT_RELEASE_MAP" 84.79 KB 5956 rows
. . exported "SYSMAN"."MGMT_CATEGORY_MAP" 46.47 KB 637 rows
. . exported "SYSMAN"."MGMT_ECM_SNAPSHOT_MD_COLUMNS" 87.20 KB 839 rows
. . exported "SYSMAN"."MGMT_IP_ELEM_DEFAULT_PARAMS" 31.75 KB 130 rows
. . exported "SYSMAN"."MGMT_JOB_COMMAND_BLOCK_PROCS" 5.921 KB 3 rows
. . exported "SYSMAN"."MGMT_JOB_LARGE_PARAMS" 5.937 KB 2 rows
. . exported "SYSMAN"."MGMT_JOB_PARAMETER" 8.859 KB 2 rows
. . exported "SYSMAN"."MGMT_JOB_SQL_PARAMS" 6.828 KB 7 rows
. . exported "APEX_030200"."WWV_COLUMN_EXCEPTIONS" 5.968 KB 3 rows
. . exported "APEX_030200"."WWV_FLOW_PICK_PAGE_VIEWS" 6.093 KB 5 rows
. . exported "APEX_030200"."WWV_FLOW_PLATFORM_PREFS" 9.007 KB 21 rows
. . exported "APEX_030200"."WWV_FLOW_POPUP_LOV_TEMPLATE" 32.23 KB 10 rows
. . exported "APEX_030200"."WWV_FLOW_QUERY_COLUMN" 9.929 KB 18 rows
. . exported "APEX_030200"."WWV_FLOW_QUERY_CONDITION" 9.601 KB 6 rows
. . exported "APEX_030200"."WWV_FLOW_QUERY_DEFINITION" 7.648 KB 6 rows
. . exported "APEX_030200"."WWV_MIG_RESERVED_WORDS" 5.898 KB 87 rows
. . exported "APEX_030200"."WWV_MIG_RPT_XMLTAGTABLEMAP" 9.132 KB 15 rows
. . exported "CMIS"."APPS" 8.148 KB 7 rows
. . exported "CMIS"."ARCHIVE" 11.03 KB 1 rows
. . exported "CMIS"."AUTHORTBLE" 6.710 KB 3 rows
. . exported "CMIS"."BANKS" 7.437 KB 2 rows
. . exported "CMIS"."BOOKENTRYTBLE" 14.30 KB 8 rows
. . exported "CMIS"."BOOKTYPE" 7.132 KB 5 rows
. . exported "CMIS"."CANCEL" 5.968 KB 4 rows
. . exported "CMIS"."CANISTER" 7.070 KB 6 rows
. . exported "CMIS"."CHAIRS" 6.585 KB 15 rows
. . exported "CMIS"."CHARGES" 7.867 KB 3 rows
. . exported "CMIS"."CITY" 6.25 KB 2 rows
. . exported "CMIS"."CMISDIC" 12.69 KB 264 rows
. . exported "CMIS"."COLCLASS" 6.101 KB 6 rows
. . exported "CMIS"."COMMNAMS" 5.453 KB 4 rows
. . exported "CMIS"."CONTRACT" 6.703 KB 2 rows
. . exported "CMIS"."COUNTRY" 11.88 KB 237 rows
. . exported "CMIS"."DENTALLIB" 6.281 KB 4 rows
. . exported "CMIS"."DENTRAUMA" 5.835 KB 2 rows
. . exported "CMIS"."DERMATHISTORY" 9.664 KB 58 rows
. . exported "CMIS"."DERMATLESIONSETUP" 6.429 KB 6 rows
. . exported "CMIS"."DERMATPROCSETUP" 7.015 KB 20 rows
. . exported "CMIS"."DERMEXIMGLINK" 6.023 KB 18 rows
. . exported "CMIS"."DERMEXIMGMASTER" 7.203 KB 18 rows
. . exported "CMIS"."DERMSETUPDIAG" 8.492 KB 41 rows
. . exported "CMIS"."DETAILS" 7.054 KB 2 rows
. . exported "CMIS"."DEVELOP" 8.312 KB 66 rows
. . exported "CMIS"."DIAGSETUP" 8.796 KB 34 rows
. . exported "CMIS"."DISTRICT" 6.75 KB 5 rows
. . exported "CMIS"."DIVISIONTBLE" 6.757 KB 6 rows
. . exported "CMIS"."DRGGRP" 6.382 KB 23 rows
. . exported "CMIS"."DRUGTABLE" 5.578 KB 12 rows
. . exported "CMIS"."ENDODTA" 19.10 KB 3 rows
. . exported "CMIS"."EXAMSET" 17.52 KB 136 rows
. . exported "CMIS"."EXPENSEDATA" 6.242 KB 1 rows
. . exported "CMIS"."EXPENSETYPES" 5.421 KB 1 rows
. . exported "CMIS"."Echo2" 9.968 KB 13 rows
. . exported "CMIS"."FILLDTA" 8.640 KB 2 rows
. . exported "CMIS"."GCHARTSETUP" 7.117 KB 3 rows
. . exported "CMIS"."GIRL2" 6.546 KB 18 rows
. . exported "CMIS"."GITHISTORY" 13.39 KB 178 rows
. . exported "CMIS"."GITLIB" 6.312 KB 6 rows
. . exported "CMIS"."GITSYMPT" 7.414 KB 69 rows
. . exported "CMIS"."GIT_DIAGS" 6.531 KB 40 rows
. . exported "HMIS"."AMDOCMST" 36.21 KB 73 rows
. . exported "HMIS"."AMFACSTP" 9.453 KB 1 rows
. . exported "HMIS"."AMFINBIL" 5.468 KB 1 rows
. . exported "HMIS"."AMFINCLR" 12.42 KB 61 rows
. . exported "HMIS"."AMFINGDC" 9.664 KB 6 rows
. . exported "HMIS"."AMFINGRP" 7.812 KB 1 rows
. . exported "HMIS"."AMFINSTS" 12.15 KB 1 rows
. . exported "HMIS"."AMFRMACTV" 10.55 KB 21 rows
. . exported "HMIS"."AMGENCALL" 8.585 KB 25 rows
. . exported "HMIS"."AMGREHIJ" 10.36 KB 122 rows
. . exported "HMIS"."AMGROUP" 8.289 KB 2 rows
. . exported "HMIS"."AMGRPMAL" 6.234 KB 1 rows
. . exported "HMIS"."AMHELP" 6.218 KB 10 rows
. . exported "HMIS"."AMHMSSTP" 6.210 KB 1 rows
. . exported "HMIS"."AMLSTACT" 5.468 KB 1 rows
. . exported "HMIS"."AMMENTREQ" 10.56 KB 3 rows
. . exported "HMIS"."AMMTHCMP" 14.05 KB 9 rows
. . exported "HMIS"."AMNRSMST" 41.16 KB 244 rows
. . exported "HMIS"."AMNRSORD" 13.38 KB 3 rows
. . exported "HMIS"."AMNRSSTN" 15.70 KB 8 rows
. . exported "HMIS"."AMPAKAGE_BACKUP_INACTIVE" 19.65 KB 21 rows
. . exported "HMIS"."AMPAKSRV" 9.960 KB 1 rows
. . exported "HMIS"."AMPAKSRV_BACKUP_INACTIVE" 9.976 KB 1 rows
. . exported "HMIS"."AMPATACT_MAK" 37.31 KB 97 rows
. . exported "HMIS"."AMPATGRP" 5.945 KB 2 rows
. . exported "HMIS"."AMPATLMT" 18.32 KB 1 rows
. . exported "HMIS"."AMPATMRG" 11.37 KB 152 rows
. . exported "HMIS"."AMPATOUT" 14.39 KB 19 rows
. . exported "HMIS"."AMPOLCOD" 9.445 KB 1 rows
. . exported "HMIS"."AMPRCAUT" 32.19 KB 1084 rows
. . exported "HMIS"."AMPTGRUP" 11.16 KB 13 rows
. . exported "HMIS"."AMRABCNS_MAK" 31.71 KB 125 rows
. . exported "HMIS"."AMRABMST" 42.64 KB 296 rows
. . exported "HMIS"."AMREPCHR" 5.414 KB 1 rows
. . exported "HMIS"."AMSTFGRP" 8.539 KB 10 rows
. . exported "HMIS"."AMTECCOD" 9.617 KB 4 rows
. . exported "HMIS"."AMUSRGRP" 8.687 KB 2 rows
. . exported "HMIS"."AMWATCRIT" 8.226 KB 1 rows
. . exported "HMIS"."AMWATPRS" 7.070 KB 1 rows
. . exported "HMIS"."ASODATA" 14.84 KB 525 rows
. . exported "HMIS"."AWRABBTN" 9.585 KB 19 rows
. . exported "HMIS"."BMAPNSET" 19.37 KB 1 rows
. . exported "HMIS"."BMDLYSCD" 16.27 KB 14 rows
. . exported "HMIS"."BMFUPGRP" 11.49 KB 32 rows
. . exported "HMIS"."BMLSTNBR" 5.468 KB 1 rows
. . exported "HMIS"."BMRSCMST" 25.79 KB 5 rows
. . exported "HMIS"."BMRSCPRC" 13.51 KB 8 rows
. . exported "HMIS"."BMUSRAUT" 20.71 KB 44 rows
. . exported "HMIS"."BYAPNSTS" 6.335 KB 6 rows
. . exported "HMIS"."CLOCD" 26.25 KB 1602 rows
. . exported "HMIS"."COLCLASS" 6.132 KB 7 rows
. . exported "HMIS"."CONTROL_CHARS" 9.25 KB 135 rows
. . exported "HMIS"."CYDSCVAL" 9.203 KB 41 rows
. . exported "HMIS"."CYMXGNDS" 8.062 KB 9 rows
. . exported "HMIS"."DATE_FORMAT_MASK" 7.664 KB 5 rows
. . exported "HMIS"."DEPT" 6.531 KB 32 rows
. . exported "HMIS"."DISCHARGESETUP" 7.835 KB 39 rows
. . exported "HMIS"."DOCTORS" 14.65 KB 93 rows
. . exported "HMIS"."DRGLOT94" 6.390 KB 94 rows
. . exported "HMIS"."DRUGTRAD" 7.039 KB 70 rows
. . exported "HMIS"."DYPRPGRP" 9.453 KB 1 rows
. . exported "HMIS"."EMACDDTA" 9.726 KB 3 rows
. . exported "HMIS"."EMEMRSTP" 7.593 KB 1 rows
. . exported "HMIS"."EYEMRDOC" 10.56 KB 4 rows
. . exported "HMIS"."EYPATSTS" 8.687 KB 2 rows
. . exported "HMIS"."EYSPCASS" 8.742 KB 3 rows
. . exported "HMIS"."FAM_NAMES" 8.773 KB 30 rows
. . exported "HMIS"."GENERIC_LOV" 7.445 KB 6 rows
. . exported "HMIS"."GLD_DOCSRL_INTG" 8.140 KB 44 rows
. . exported "HMIS"."G_AUTHORS" 29.63 KB 1000 rows
. . exported "HMIS"."G_BOOK_AUTHORS" 16.95 KB 1000 rows
. . exported "HMIS"."HCRRESSTP" 9.031 KB 1 rows
. . exported "HMIS"."HISORYTEMPLATE" 7.289 KB 3 rows
. . exported "HMIS"."HKAREA" 11.54 KB 21 rows
. . exported "HMIS"."HKHKSSCH" 9.953 KB 16 rows
. . exported "HMIS"."MMARCHIVESETUP" 7.062 KB 1 rows
. . exported "HMIS"."MMARCHTYPE" 5.945 KB 7 rows
. . exported "HMIS"."MMAUGROUP" 6.453 KB 7 rows
. . exported "HMIS"."MMAUTAB" 10.48 KB 43 rows
. . exported "HMIS"."MMAUUSR" 15.35 KB 106 rows
. . exported "HMIS"."MMCMISFUN" 15.10 KB 108 rows
. . exported "HMIS"."MMCONSTYPE" 7.203 KB 10 rows
. . exported "HMIS"."MMDEFCOD" 9.054 KB 1 rows
. . exported "HMIS"."MMDISCHARGESETUP" 9.304 KB 43 rows
. . exported "HMIS"."MMDRGHIST" 11.74 KB 19 rows
. . exported "HMIS"."MMEXTREMTY" 6.312 KB 7 rows
. . exported "HMIS"."MMFUNREF" 17.14 KB 44 rows
. . exported "HMIS"."MMUSR_PART" 5.968 KB 7 rows
. . exported "HMIS"."MMVITALNRMRNGSTP" 12.75 KB 1 rows
. . exported "HMIS"."MNTANT1" 23.32 KB 21 rows
. . exported "HMIS"."MNUSRSEL" 11.62 KB 38 rows
. . exported "HMIS"."MQSYSMST" 7.039 KB 1 rows
. . exported "HMIS"."MRMBUTTONSETUP" 6.664 KB 15 rows
. . exported "HMIS"."MRMCOLORSETUP" 8.625 KB 17 rows
. . exported "HMIS"."MRMCRTL" 9.070 KB 43 rows
. . exported "HMIS"."MRMHEADERSETUP" 7.710 KB 20 rows
. . exported "HMIS"."MRMSETUP" 13.65 KB 66 rows
. . exported "HMIS"."MRMSITES" 5.460 KB 3 rows
. . exported "HMIS"."MRMSITESETUP" 8.914 KB 198 rows
. . exported "HMIS"."MRM_GF_SETUP" 20.59 KB 463 rows
. . exported "HMIS"."MRM_GF_SETUP_NEW" 20.25 KB 452 rows
. . exported "HMIS"."MRM_PSR_SETUP" 7.835 KB 2 rows
. . exported "HMIS"."MSFUNSTP" 7.851 KB 2 rows
. . exported "HMIS"."MSGRPSTP" 7.867 KB 2 rows
. . exported "HMIS"."MSGSETUP" 7.476 KB 2 rows
. . exported "HMIS"."MSSNDSTP" 7.812 KB 2 rows
. . exported "HMIS"."NCACTDTL" 15.20 KB 110 rows
. . exported "HMIS"."NCACTSTP" 10.77 KB 14 rows
. . exported "HMIS"."NCADMFRM" 8.593 KB 1 rows
. . exported "HMIS"."NCBLDCOD" 9.335 KB 6 rows
. . exported "HMIS"."NCDGIVNOTM" 12.83 KB 216 rows
. . exported "HMIS"."NCDGNREF" 8.289 KB 7 rows
. . exported "HMIS"."NCDGNRSF" 8.296 KB 7 rows
. . exported "HMIS"."NCDGNSYM" 8.75 KB 8 rows
. . exported "HMIS"."NCDPTTYP" 8 KB 16 rows
. . exported "HMIS"."NCFLTTYP" 10.63 KB 51 rows
. . exported "HMIS"."NCGRDTYP" 13.27 KB 17 rows
. . exported "HMIS"."NCHABCOD" 10.28 KB 38 rows
. . exported "HMIS"."NCHOWADM" 8.773 KB 6 rows
. . exported "HMIS"."NCINDSTP" 9.765 KB 15 rows
. . exported "HMIS"."NCINJCOD" 8.328 KB 2 rows
. . exported "HMIS"."NCINSSTP" 12.38 KB 44 rows
. . exported "HMIS"."NCIVNACTV" 9.726 KB 16 rows
. . exported "HMIS"."NCIVNSTP" 17.42 KB 112 rows
. . exported "HMIS"."NCLIMCOD" 9.632 KB 18 rows
. . exported "HMIS"."NCNRSDGN" 30.09 KB 150 rows
. . exported "HMIS"."NCNRSSCH" 9.429 KB 7 rows
. . exported "HMIS"."NCOTMIND" 8.734 KB 17 rows
. . exported "HMIS"."NCOTMSTP" 17.14 KB 58 rows
. . exported "HMIS"."PMLOCDRG" 35.52 KB 1086 rows
. . exported "HMIS"."PMPCYLOC" 35.78 KB 390 rows
. . exported "HMIS"."PMPMCSTP" 30.32 KB 1 rows
. . exported "HMIS"."PMREQUST" 31.26 KB 77 rows
. . exported "HMIS"."RYSRGSUP" 20.15 KB 114 rows
. . exported "HMIS"."RYSUPLST" 11.95 KB 78 rows
. . exported "HMIS"."RYSUPLST_TMP" 19.34 KB 205 rows
. . exported "HMIS"."RYSUPREQ" 10.78 KB 24 rows
. . exported "HMIS"."SETUPRPT" 6.164 KB 12 rows
. . exported "HMIS"."SHCONFIG" 6.101 KB 14 rows
. . exported "IDMS7"."ACRHFZ_MED_DATA" 9.210 KB 25 rows
. . exported "IDMS7"."ACRPAYDTL_3108204" 17.14 KB 33 rows
. . exported "IDMS7"."ACRPAYHDR_3108204" 37.27 KB 33 rows
. . exported "IDMS7"."ACRPAYTYP" 10.35 KB 12 rows
. . exported "IDMS7"."ACRTEMP" 49.20 KB 195 rows
. . exported "IDMS7"."ACRTEMP2512015" 47.84 KB 188 rows
. . exported "IDMS7"."ACR_CSTBAL" 30.08 KB 401 rows
. . exported "IDMS7"."ACR_CSTGRPBAL" 12.60 KB 29 rows
. . exported "IDMS7"."ACR_HAFZA_REP" 7.101 KB 6 rows
. . exported "IDMS7"."ACR_MIGRTLOG" 5.929 KB 2 rows
. . exported "IDMS7"."ACR_SRLWSL" 5.484 KB 1 rows
. . exported "IDMS7"."ACR_SRL_CUSTGRP_RCPT" 5.968 KB 7 rows
. . exported "IDMS7"."ACR_SRL_INVC" 5.906 KB 2 rows
. . exported "IDMS7"."ACR_SRL_MEMCST" 5.867 KB 2 rows
. . exported "IDMS7"."ACR_SRL_MEMO" 6.070 KB 14 rows
. . exported "IDMS7"."ACR_SRL_PRFM" 5.898 KB 2 rows
. . exported "IDMS7"."ACR_SRL_RCPT" 5.906 KB 2 rows
. . exported "IDMS7"."ACR_SRL_RCPTTMP" 5.906 KB 2 rows
. . exported "IDMS7"."ACR_SRL_RETDEP" 5.906 KB 2 rows
. . exported "IDMS7"."ACR_SRL_TSK" 5.890 KB 2 rows
. . exported "IDMS7"."ACR_SYSPARM" 49.90 KB 2 rows
. . exported "IDMS7"."ACR_SYSPARM_LOG" 83.33 KB 110 rows
. . exported "IDMS7"."AMGREHIJ" 10.36 KB 122 rows
. . exported "IDMS7"."AMGREHIJ1" 9.968 KB 110 rows
. . exported "IDMS7"."ATF" 18.48 KB 512 rows
. . exported "IDMS7"."ATSUBRULES" 6.218 KB 1 rows
. . exported "IDMS7"."ATTPLAN" 8.625 KB 1 rows
. . exported "IDMS7"."ATTRANS" 11.60 KB 85 rows
. . exported "IDMS7"."BDG01_BDGCHPTRS" 9.078 KB 1 rows
. . exported "IDMS7"."BDG01_CNFFILE" 31.69 KB 1 rows
. . exported "IDMS7"."BDG01_MRKFST" 47.22 KB 76 rows
. . exported "IDMS7"."BDG01_SPFFYYR" 13.52 KB 2 rows
. . exported "IDMS7"."BDG01_STUP" 24.12 KB 1 rows
. . exported "IDMS7"."BDG_CATEGORY" 6.882 KB 4 rows
. . exported "IDMS7"."BDG_CATEGORY_USR_APPROV" 6.351 KB 4 rows
. . exported "IDMS7"."BDG_GLCHRACT" 33.71 KB 332 rows
. . exported "IDMS7"."BDG_GROUP" 12.67 KB 100 rows
. . exported "IDMS7"."BDG_LINK_GL" 10 KB 2 rows
. . exported "IDMS7"."BDG_OPN_BALANCE" 9.734 KB 77 rows
. . exported "IDMS7"."BDG_TYP" 10.87 KB 1 rows
. . exported "IDMS7"."BNK_BANKACC" 17.09 KB 9 rows
. . exported "IDMS7"."BNK_CHKRET_CD" 6.687 KB 2 rows
. . exported "IDMS7"."BNK_CHQBOOKMST" 18.21 KB 6 rows
. . exported "IDMS7"."BNK_CHQ_TYPE" 7.046 KB 1 rows
. . exported "IDMS7"."BNK_CSL_SETUP" 10.69 KB 1 rows
. . exported "IDMS7"."BNK_FINTYP" 6.679 KB 3 rows
. . exported "IDMS7"."BNK_GRAPH" 13.17 KB 87 rows
. . exported "IDMS7"."GL_ORD_STUP" 11.69 KB 1 rows
. . exported "IDMS7"."HPRVARVAC" 30.57 KB 523 rows
. . exported "IDMS7"."ICL" 20.42 KB 39 rows
. . exported "IDMS7"."IIF" 9.070 KB 1 rows
. . exported "IDMS7"."IIT" 38.26 KB 21 rows
. . exported "IDMS7"."IIT_BK" 35.85 KB 16 rows
. . exported "IDMS7"."IIW" 17.45 KB 20 rows
. . exported "IDMS7"."ILM" 25.28 KB 212 rows
. . exported "IDMS7"."INTG_SEQ_TBL" 5.085 KB 2 rows
. . exported "IDMS7"."INVDTL_31082014" 41.15 KB 206 rows
. . exported "IDMS7"."INV_LOTSTS" 7.070 KB 2 rows
. . exported "IDMS7"."INV_LOT_LOG" 41.02 KB 411 rows
. . exported "IDMS7"."INV_PCY_FAC" 6.296 KB 2 rows
. . exported "IDMS7"."INV_PURREQ_TMP" 9.585 KB 3 rows
. . exported "IDMS7"."IREQ_LOG" 10.29 KB 1 rows
. . exported "IDMS7"."IRSN" 8.640 KB 1 rows
. . exported "IDMS7"."ITF" 32.53 KB 26 rows
. . exported "IDMS7"."ITF_PATPRCDTL" 8.367 KB 14 rows
. . exported "IDMS7"."ITMFIXMAP" 20.57 KB 58 rows
. . exported "IDMS7"."ITM_LAB" 10.87 KB 79 rows
. . exported "IDMS7"."ITM_PRIC" 7.273 KB 110 rows
. . exported "IDMS7"."IUF" 8.312 KB 5 rows
. . exported "IDMS7"."LOT_UP" 16.19 KB 613 rows
. . exported "IDMS7"."MCM" 35.5 KB 1 rows
. . exported "IDMS7"."MEMODTL1" 34.89 KB 248 rows
. . exported "IDMS7"."MEMODTL1_HAYA" 34.09 KB 240 rows
. . exported "IDMS7"."MEMO_SETUP" 12.77 KB 4 rows
. . exported "IDMS7"."MNUSRSEL" 9.484 KB 10 rows
. . exported "IDMS7"."MNUSRWKS" 15.17 KB 439 rows
. . exported "IDMS7"."MODULE_INST" 9.859 KB 16 rows
. . exported "IDMS7"."MOD_ALERT" 10 KB 9 rows
. . exported "IDMS7"."OBMGRT" 23.67 KB 98 rows
. . exported "IDMS7"."OPN_TEMP" 15.63 KB 289 rows
. . exported "IDMS7"."ORD_CSTADD" 52.02 KB 517 rows
. . exported "IDMS7"."ORD_CSTGRP" 21.57 KB 20 rows
. . exported "IDMS7"."ORD_HIRLVLDEPT" 15.99 KB 113 rows
. . exported "IDMS7"."ORD_SALPRS" 9.523 KB 1 rows
. . exported "IDMS7"."OVERTIME_LIMITS" 7.101 KB 3 rows
. . exported "IDMS7"."PARAMETER_DESCRIPTION" 6.039 KB 9 rows
. . exported "IDMS7"."PAYMTDATA" 11.56 KB 5 rows
. . exported "IDMS7"."PAYTEMP" 5.867 KB 1 rows
. . exported "IDMS7"."PAY_WAY2512015" 35.08 KB 193 rows
. . exported "IDMS7"."PBCATCOL" 18.50 KB 113 rows
. . exported "IDMS7"."PBCATEDT" 8.421 KB 21 rows
. . exported "IDMS7"."PBCATFMT" 6.828 KB 20 rows
. . exported "IDMS7"."PBCATTBL" 15.76 KB 10 rows
. . exported "IDMS7"."PMLOCWC" 9.578 KB 8 rows
. . exported "IDMS7"."PMT_ALERT" 10.42 KB 8 rows
. . exported "IDMS7"."PREFFCDG" 6.781 KB 5 rows
. . exported "IDMS7"."PRFAMREL" 25.96 KB 138 rows
. . exported "IDMS7"."PRFLLCCD" 6.695 KB 1 rows
. . exported "IDMS7"."PRFRNDLG" 6.695 KB 1 rows
. . exported "IDMS7"."PRJBTRSC" 7.906 KB 9 rows
. . exported "IDMS7"."PRJOBCAT" 6.687 KB 1 rows
. . exported "IDMS7"."PRJ_SRV_STP" 6.726 KB 3 rows
. . exported "IDMS7"."PRJ_STP" 15.75 KB 1 rows
. . exported "IDMS7"."PRLNGCOD" 7.25 KB 21 rows
. . exported "IDMS7"."PRVARSAN" 34.50 KB 195 rows
. . exported "ORDDATA"."ORDDCM_VR_DT_MAP" 6.515 KB 32 rows
. . exported "SAM"."EMP" 8.570 KB 14 rows
. . exported "SCOTT"."DEPT" 5.937 KB 4 rows
. . exported "SCOTT"."EMP" 8.570 KB 14 rows
. . exported "SCOTT"."SALGRADE" 5.867 KB 5 rows
. . exported "SYSMAN"."AQ$_MGMT_LOADER_QTABLE_S" 10.75 KB 1 rows
. . exported "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_S" 10.75 KB 1 rows
. . exported "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS" 0 KB 0 rows
. . exported "SYSTEM"."REPCAT$_USER_PARM_VALUES" 0 KB 0 rows
. . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE" 0 KB 0 rows
Master table "SYSTEM"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_FULL_01 is:
D:\PARTEXP\PARTEXP.DMP
Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed at 15:38:14
>> Here i used schemas option as we do in normal schema level import nothing new...
>> You can observe while taking export we have 4 or 5 schemas like HMIS,CMIS,IDMS7 and SAM i imported only SAM schema which contains 2 tables EMP and OTORDERS
D:\app\oracle\impquery> impdp dumpfile=PARTEXP.DMP directory=impquery schemas=sam
Import: Release 11.2.0.3.0 - Production on Sun Nov 29 15:49:05 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Username: system
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/******** dumpfile=PARTEXP.DMP directory=impquery schemas=sam
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "SAM"."OTORDERS" 1.602 MB 8068 rows
. . imported "SAM"."EMP" 8.570 KB 14 rows
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully completed at 15:49:36
Happy Learning...
No comments:
Post a Comment