 |
 |
+-----------------------------------------------+
| EMERALIT Data Auto Refresh |
| Date: 19:10:01 02/23/17 |
| Source Server: 192.168.10.56 |
| Target Server: 192.168.10.242 |
| Source Loc: /u03/flash_recovery_area/DP_DUMP |
| Target Loc: /media/Data/oracle/DP_DUMP |
| Description: Refresh table within data level |
| Author: Amos Geng@MiCORE Solutions, Inc |
| Version: 1.0.0 |
+-----------------------------------------------+
[ 19:10:01 02/23/17 ] Step 01 - Transferring Dump File from Production to Test Server ...
[ 19:12:02 02/23/17 ] Step 02 - Unzipping Dump File ...
[ 19:22:18 02/23/17 ] Step 03 - Creating Folder for SQL statements ...
[ 19:22:18 02/23/17 ] Step 04 - Createing the drop sequence SQL statements ...
[ 19:22:19 02/23/17 ] Step 05 - Transfer GRANT/SEQUENCE/CONSTRAINT SQL statement scripts, and impdp PAR files ...
[ 19:22:20 02/23/17 ] Step 06 - Creating file size log on target server ...
[ 19:22:20 02/23/17 ] Step 07 - Import Prerequisite Checking ...
+-------------------------+
| INVAILD OBJECTS BEFORE |
+-------------------------+
OWNER OBJECT_NAME OBJECT_TYPE
--------------- ------------------------------ -------------------
EMERALITPRD REC_PARSE_DATA_INTO_AUTHORIZ PROCEDURE
EMERALITPRD P_UPDATE_ADDRESS_FROM_PORTAL PROCEDURE
EMERALITPRD AD_TRACK_STAGE PACKAGE BODY
EMERALITPRD P_CREATE_OUTGOING_SCHEDULE PROCEDURE
EMERALITPRD P_INSERT_OUTGOING_SCHEDULE PROCEDURE
EMERALITPRD P_CREATE_OR_UPDATE_SCHEDULE PROCEDURE
EMERALITPRD WORKFLOWHISTORY_REPORT PROCEDURE
EMERALITPRD P_LOAD_IR_FILES PROCEDURE
EMERALITPRD REC_MV_PARTICIPANT_INQUIRY MATERIALIZED VIEW
EMERALIT NEAP_PAIDOUT_REAPPLIED PROCEDURE
EMERALIT WORKFLOWHISTORY_REPORT PROCEDURE
EMERALIT F_GET_SUMMARY_OLD_BALANCE FUNCTION
EMERALIT F_GET_DETAIL_OLD_BALANCE FUNCTION
EMERALIT T_PORTAL_ADDRESS_UPDATE_TYPE TYPE
14 rows selected.
+-------------------------+
| SCHEMA.FILESIZE COMPARE |
+-------------------------+
DUMP .................................. [ PASSED ]
emeralit.sequence ..................... [ PASSED ]
emeralitprd.sequence .................. [ PASSED ]
emeralit.grant ........................ [ PASSED ]
emeralitprd.grant ..................... [ PASSED ]
emeralit.constraint ................... [ PASSED ]
emeralitprd.constraint ................ [ PASSED ]
emeralit.par .......................... [ PASSED ]
emeralitprd.par ....................... [ PASSED ]
All the prerequisite successed.
[ 19:22:20 02/23/17 ] Step 08 - Dropping sequence objects from databse emeralittst2 ...
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
Sequence dropped.
SEQUENCE OBJECTS HAVE BEEN DROPPED. PLEASE REVIEW LOGS FOR SEARCHING ERRORS. THE IMPORT WILL START IN 5 MINUTES...
[* ][ 0%]
[** ][ 5%]
[**** ][ 10%]
[****** ][ 15%]
[******** ][ 20%]
[********** ][ 25%]
[************ ][ 30%]
[************** ][ 35%]
[**************** ][ 40%]
[****************** ][ 45%]
[******************** ][ 50%]
[********************** ][ 55%]
[************************ ][ 60%]
[************************** ][ 65%]
[**************************** ][ 70%]
[****************************** ][ 75%]
[******************************** ][ 80%]
[********************************** ][ 85%]
[************************************ ][ 90%]
[************************************** ][ 95%]
[****************************************][100%]
[ 19:27:07 02/23/17 ] Step 09 - Importing fresh data, process will start in 1 minute ...
##################################################################################
# CAUTION: IMDPD LOGS MUST BE ATTACHED. IF NOT, ORACLE_SID NOT EXPORTED PROPERLY #
##################################################################################
IMPORTING DATA INTO SCHEMA EMERALITPRD...
;;;
Import: Release 11.2.0.1.0 - Production on Fri Feb 17 22:14:27 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_TABLE_01": "/******** AS SYSDBA" parfile=emeralitprd.par
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "EMERALITPRD"."REQUEST_ELIGIBILITY_TABLE" 600.3 MB 16008749 rows
. . imported "EMERALITPRD"."REQUEST_BENEFIT_TABLE" 718.2 MB 18004517 rows
. . imported "EMERALITPRD"."MPR_HEADER" 358.3 MB 2314877 rows
. . imported "EMERALITPRD"."EMPLOYER_CONTRIB_HISTORY" 523.4 MB 5446445 rows
. . imported "EMERALITPRD"."SUSPENSE_DEPOSIT" 10.39 KB 58 rows
. . imported "EMERALITPRD"."REQUEST_MESSAGES" 1.363 GB 813069 rows
. . imported "EMERALITPRD"."ECH_PLAN_TOTALS" 331.3 MB 5772022 rows
. . imported "EMERALITPRD"."ECH_CLASS_BREAKDOWN" 210.2 MB 6680436 rows
. . imported "EMERALITPRD"."DDHISTORY" 142.9 MB 444647 rows
. . imported "EMERALITPRD"."REQUEST_CALC_PARTICIPANT" 206.5 MB 812475 rows
. . imported "EMERALITPRD"."REQUEST_EMERALIT_RESULTS" 137.5 MB 1022683 rows
. . imported "EMERALITPRD"."AR_EXPORT" 82.91 MB 123441 rows
. . imported "EMERALITPRD"."PHONELOG" 105.8 MB 52938 rows
. . imported "EMERALITPRD"."CRR_DETAIL" 113.1 MB 2314464 rows
. . imported "EMERALITPRD"."MPR_ADJUSTMENTS" 49.43 MB 120860 rows
. . imported "EMERALITPRD"."ACCOUNT" 45.66 MB 195579 rows
. . imported "EMERALITPRD"."EMPLOYER_CONTRIB_PURGE" 45.15 MB 455153 rows
. . imported "EMERALITPRD"."REQUEST_NEAP_RESULTS" 32.58 MB 257387 rows
. . imported "EMERALITPRD"."REQUEST_BENEFICIARY" 32.33 MB 369598 rows
. . imported "EMERALITPRD"."EMPLOYER" 32.00 MB 156865 rows
. . imported "EMERALITPRD"."REQUEST_NEAP_ADJUSTMENTS" 31.77 MB 599893 rows
. . imported "EMERALITPRD"."CHECKLIST_EMERALIT" 28.33 MB 185664 rows
. . imported "EMERALITPRD"."COMBINATION_ADDRESS" 26.17 MB 194589 rows
. . imported "EMERALITPRD"."CONVERT_ERROR" 23.88 MB 254306 rows
. . imported "EMERALITPRD"."MLOG$_BATCH_HEADER" 22.05 MB 132261 rows
. . imported "EMERALITPRD"."EMP_COMBINATION" 18.87 MB 193955 rows
. . imported "EMERALITPRD"."SSA_LETTERS" 18.66 MB 250240 rows
. . imported "EMERALITPRD"."NON_BARGAINING" 17.92 MB 233735 rows
. . imported "EMERALITPRD"."COMB_ACTIVATION_HIST" 17.14 MB 206897 rows
. . imported "EMERALITPRD"."CHECKLIST_NEAP" 16.62 MB 119032 rows
. . imported "EMERALITPRD"."GL_EXPORT" 13.83 MB 174052 rows
. . imported "EMERALITPRD"."EMPLOYER_NOTES" 13.67 MB 48138 rows
. . imported "EMERALITPRD"."CHECKLIST_PART" 13.44 MB 216245 rows
. . imported "EMERALITPRD"."DDLOCATOR" 11.97 MB 249221 rows
. . imported "EMERALITPRD"."LSF_HISTORY" 11.68 MB 298947 rows
. . imported "EMERALITPRD"."NEAPPARTBAL" 11.46 MB 116810 rows
. . imported "EMERALITPRD"."AION_NOT_VESTED" 9.174 MB 874786 rows
. . imported "EMERALITPRD"."LOCAL_HISTORY" 9.277 MB 132632 rows
. . imported "EMERALITPRD"."NEAP_PARTICIPANT" 7.446 MB 144261 rows
. . imported "EMERALITPRD"."AR_EXPORT_HISTORY" 8.109 MB 218445 rows
. . imported "EMERALITPRD"."ACCOUNTOWNERSHIP" 5.924 MB 200803 rows
. . imported "EMERALITPRD"."NEAP_ACCT_BAL" 6.483 MB 221078 rows
. . imported "EMERALITPRD"."REQUEST_DISTRIBUTION" 6.423 MB 118697 rows
. . imported "EMERALITPRD"."DELETED_PARTICIPANTS" 5.817 MB 81872 rows
. . imported "EMERALITPRD"."PERSONPROXY" 4.830 MB 268463 rows
. . imported "EMERALITPRD"."MONEY_RECEIVED" 3.820 MB 38558 rows
. . imported "EMERALITPRD"."BOARD_HISTORY" 3.199 MB 36923 rows
. . imported "EMERALITPRD"."VEST_HIST" 3.105 MB 147953 rows
. . imported "EMERALITPRD"."COMB_ADDRESS_HIST" 4.328 MB 42055 rows
. . imported "EMERALITPRD"."SAP_BATCH_HEADER" 3.658 MB 18942 rows
. . imported "EMERALITPRD"."BATCH_HEADER" 3.094 MB 19731 rows
. . imported "EMERALITPRD"."S_ADDRESS_ERROR" 1.824 MB 43718 rows
. . imported "EMERALITPRD"."EMPLOYER_ID" 2.846 MB 156865 rows
. . imported "EMERALITPRD"."A_NEAP_PARTICIPANT_UPDATE" 239.4 KB 2768 rows
. . imported "EMERALITPRD"."SUSPENSE_MPR_HEADER" 191.5 KB 1326 rows
. . imported "EMERALITPRD"."BANK_DETAIL" 256.2 KB 7021 rows
. . imported "EMERALITPRD"."PARTICIPATION_AGREEMENT" 275.9 KB 3919 rows
. . imported "EMERALITPRD"."EBB_REIMBURSE_HIST" 1.362 MB 23538 rows
. . imported "EMERALITPRD"."TAX_ID_NUMBER" 241.8 KB 5894 rows
. . imported "EMERALITPRD"."REQUEST_ALT_PAYEE" 2.106 MB 17806 rows
. . imported "EMERALITPRD"."QDRO" 1.275 MB 5615 rows
. . imported "EMERALITPRD"."SMPR_VIOLATIONS" 174.2 KB 1905 rows
. . imported "EMERALITPRD"."ARN" 54.92 KB 48 rows
. . imported "EMERALITPRD"."BANK_ACCOUNT" 39.43 KB 137 rows
. . imported "EMERALITPRD"."BANK_SUMMARY" 26.67 KB 680 rows
. . imported "EMERALITPRD"."BATCH_STATUS" 6.226 KB 6 rows
. . imported "EMERALITPRD"."BAT_ADJ_TYPES" 6.992 KB 7 rows
. . imported "EMERALITPRD"."BENEFIT_BOARD" 47.06 KB 169 rows
. . imported "EMERALITPRD"."BENEFIT_BOARD_DISTR" 6.632 KB 56 rows
. . imported "EMERALITPRD"."BOARD_CONTACT" 55.58 KB 342 rows
. . imported "EMERALITPRD"."EMPLOYER_LINK" 805.5 KB 8935 rows
. . imported "EMERALITPRD"."BR_SUSPEND_CODES" 6.265 KB 31 rows
. . imported "EMERALITPRD"."CRR_DEPOSIT" 1.942 MB 38165 rows
. . imported "EMERALITPRD"."BR_WORK_CODES" 5.601 KB 5 rows
. . imported "EMERALITPRD"."CLC_DD_SSNS" 57.63 KB 4906 rows
. . imported "EMERALITPRD"."CLC_QUART_SSN_FUND" 6.304 KB 57 rows
. . imported "EMERALITPRD"."CLC_SSN_UNVEST" 27.20 KB 2061 rows
. . imported "EMERALITPRD"."CONSTRUCTION_BOARD" 7.054 KB 168 rows
. . imported "EMERALITPRD"."MLOG$_BAT_ADJUSTMENTS" 844.7 KB 2423 rows
. . imported "EMERALITPRD"."CONSTRUCTION_JOB_CLASS" 6.085 KB 30 rows
. . imported "EMERALITPRD"."CONSTRUCTION_LOCAL" 17.62 KB 1393 rows
. . imported "EMERALITPRD"."EBB_LOCAL_UNION" 131.3 KB 2016 rows
. . imported "EMERALITPRD"."ECH_ADJUSTMENTS" 45.61 KB 910 rows
. . imported "EMERALITPRD"."S_ECH_2013_JC_N" 2.038 MB 15858 rows
. . imported "EMERALITPRD"."ECH_ADJ_REASONS" 5.523 KB 3 rows
. . imported "EMERALITPRD"."ES_EMPLOYEES" 6.414 KB 25 rows
. . imported "EMERALITPRD"."FEDERAL_ID" 5.078 KB 1 rows
. . imported "EMERALITPRD"."FED_ID_LOOKUP" 18.77 KB 329 rows
. . imported "EMERALITPRD"."MLOG$_MONEY_RECEIVED" 963.9 KB 6651 rows
. . imported "EMERALITPRD"."FED_ID_XREF" 104.7 KB 929 rows
. . imported "EMERALITPRD"."FRANKSSN" 24.89 KB 626 rows
. . imported "EMERALITPRD"."IBEW_PREV_REPORTED" 102.4 KB 4518 rows
. . imported "EMERALITPRD"."JATC_FEDS" 8.601 KB 262 rows
. . imported "EMERALITPRD"."JOB_CLASS" 6.882 KB 30 rows
. . imported "EMERALITPRD"."LOCAL_CONTACT" 147.1 KB 1369 rows
. . imported "EMERALITPRD"."LOCAL_UNION" 131.0 KB 1393 rows
. . imported "EMERALITPRD"."LOCAL_UNION_DISTR" 6.851 KB 72 rows
. . imported "EMERALITPRD"."LOC_ACTIVATION_HIST" 105.4 KB 1406 rows
. . imported "EMERALITPRD"."LSF_SHARE_VALUE" 19.89 KB 685 rows
. . imported "EMERALITPRD"."EXPENSE_REIMBURSE" 528.2 KB 10491 rows
. . imported "EMERALITPRD"."MERGE_DETAIL" 115.1 KB 3351 rows
. . imported "EMERALITPRD"."MERGE_HISTORY" 47.38 KB 615 rows
. . imported "EMERALITPRD"."SUSPENSE_CRR_DETAIL" 69.64 KB 1465 rows
. . imported "EMERALITPRD"."METHOD" 6.007 KB 17 rows
. . imported "EMERALITPRD"."MONEY_TYPES" 5.585 KB 4 rows
. . imported "EMERALITPRD"."MPR_ADJ_PARTICIPANT" 110.9 KB 2990 rows
. . imported "EMERALITPRD"."MPR_ADJ_TYPES" 7.648 KB 12 rows
. . imported "EMERALITPRD"."MPR_STANDARDS" 7.664 KB 18 rows
. . imported "EMERALITPRD"."MPR_STATUS" 6.164 KB 5 rows
. . imported "EMERALITPRD"."NEAP_DISTRIBUTION" 93.69 KB 1560 rows
. . imported "EMERALITPRD"."NECA_REGION" 11.13 KB 4 rows
. . imported "EMERALITPRD"."REC_IDS" 7.101 KB 42 rows
. . imported "EMERALITPRD"."REIMBURSEMENT_TABLE" 7.468 KB 5 rows
. . imported "EMERALITPRD"."BAT_ADJUSTMENTS" 457.3 KB 1509 rows
. . imported "EMERALITPRD"."RELATIONSHIP" 5.601 KB 5 rows
. . imported "EMERALITPRD"."SUSPENSE_BATCH" 12.07 KB 1 rows
. . imported "EMERALITPRD"."SUSPENSE_LOAD_IN_PROCESS" 8.898 KB 20 rows
. . imported "EMERALITPRD"."SUSPENSE_REC_IDS" 6.359 KB 1 rows
. . imported "EMERALITPRD"."SUSPENSE_VIOLATIONS" 9.281 KB 20 rows
. . imported "EMERALITPRD"."COMB_NAME_HIST" 434.7 KB 4083 rows
. . imported "EMERALITPRD"."TEMP_DDLOCATOR" 23.46 KB 174 rows
. . imported "EMERALITPRD"."TEMP_DDLOCATOR_BKP" 64.13 KB 175 rows
. . imported "EMERALITPRD"."FUND_REQ" 345.2 KB 9636 rows
. . imported "EMERALITPRD"."TM_TEMP_CLRC_REPORT_2014" 37.10 KB 392 rows
. . imported "EMERALITPRD"."TOPICCODES" 6.359 KB 24 rows
. . imported "EMERALITPRD"."MLOG$_BATCH_STATUS" 0 KB 0 rows
. . imported "EMERALITPRD"."PREPOST_REQUEST" 0 KB 0 rows
. . imported "EMERALITPRD"."SHARE_BAL_HIST" 0 KB 0 rows
. . imported "EMERALITPRD"."PP7_PARTICIPANT" 434.5 KB 3423 rows
. . imported "EMERALITPRD"."SMPRD_VIOLATIONS" 0 KB 0 rows
. . imported "EMERALITPRD"."SUSPENSE_MPR_DETAIL" 0 KB 0 rows
. . imported "EMERALITPRD"."ROUTINGNUMBER" 405.7 KB 11774 rows
. . imported "EMERALITPRD"."REQUEST_WORK_HISTORY" 2.370 GB 34254975 rows
. . imported "EMERALITPRD"."MPR_DETAIL" 2.444 GB 24079758 rows
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
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/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION
Job "SYS"."SYS_IMPORT_TABLE_01" successfully completed at 22:37:39
IMPORTING DATA INTO SCHEMA EMERALIT...
;;;
Import: Release 11.2.0.1.0 - Production on Fri Feb 17 22:37:41 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_TABLE_01": "/******** AS SYSDBA" parfile=emeralit.par
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "EMERALIT"."CBAS_WHS_EXTND" 730.2 MB 12250698 rows
. . imported "EMERALIT"."MLOG$_PARTICIPANT" 438.4 MB 12582055 rows
. . imported "EMERALIT"."PARTICIPANT" 294.0 MB 1559235 rows
. . imported "EMERALIT"."BR_PAYMENT_EXTND" 1.107 GB 11524894 rows
. . imported "EMERALIT"."PARTICIPANT_PLAN" 129.0 MB 1769765 rows
. . imported "EMERALIT"."PARTICIPANT_NUM_MV" 286.6 MB 1497990 rows
. . imported "EMERALIT"."PARTICIPANT_NAME_STR_MV" 62.18 MB 1559236 rows
. . imported "EMERALIT"."PARTICIPANT_NAME" 93.45 MB 1559236 rows
. . imported "EMERALIT"."WORK_HIST_SUMMARY" 1.399 GB 24907605 rows
. . imported "EMERALIT"."DIST_SSN" 42.99 MB 2168768 rows
. . imported "EMERALIT"."PARTICIPANT_FLAGS" 49.59 MB 738746 rows
. . imported "EMERALIT"."BR_UNIQUE" 50.30 MB 298157 rows
. . imported "EMERALIT"."BENEFICIARY" 32.12 MB 172562 rows
. . imported "EMERALIT"."TM_TEMP" 33.87 MB 625470 rows
. . imported "EMERALIT"."PABD_NAME_SRCH" 20.79 MB 336161 rows
. . imported "EMERALIT"."CBAS_PLAN_EXTND" 20.75 MB 1136138 rows
. . imported "EMERALIT"."BR_AWARD" 35.97 MB 261113 rows
. . imported "EMERALIT"."TM_TEMP_IBEW_REQ" 18.16 MB 259449 rows
. . imported "EMERALIT"."TM_TEMP_DOL_ANALYSIS" 17.32 MB 136968 rows
. . imported "EMERALIT"."CBAS_SSN_EXTND" 15.97 MB 1051164 rows
. . imported "EMERALIT"."TM_TEMP_SSA_WORKING" 11.02 MB 140219 rows
. . imported "EMERALIT"."PABD_BR_NAME" 11.17 MB 345136 rows
. . imported "EMERALIT"."IBEW_CARD" 14.33 MB 512180 rows
. . imported "EMERALIT"."BR_CENSUS" 8.447 MB 49771 rows
. . imported "EMERALIT"."DEATH_DATA" 9.326 MB 184176 rows
. . imported "EMERALIT"."BR_VOID" 7.833 MB 68819 rows
. . imported "EMERALIT"."BR_HISTORY" 6.646 MB 15325 rows
. . imported "EMERALIT"."PABD_NS" 7.383 MB 351269 rows
. . imported "EMERALIT"."SSN_AUTHORIZATION" 7.318 MB 93921 rows
. . imported "EMERALIT"."TM_TEMP2013" 5.584 MB 254329 rows
. . imported "EMERALIT"."BC_ELIGIBILITY_TBL" 4.808 MB 95607 rows
. . imported "EMERALIT"."BR" 6.238 MB 282414 rows
. . imported "EMERALIT"."BC_BENEFIT_TBL" 4.911 MB 91696 rows
. . imported "EMERALIT"."TM_TEMP2014" 5.435 MB 247438 rows
. . imported "EMERALIT"."TM_TEMP2015" 5.289 MB 240725 rows
. . imported "EMERALIT"."TM_TEMP2016" 4.551 MB 208644 rows
. . imported "EMERALIT"."BR_CHECK_ADDR" 3.739 MB 25739 rows
. . imported "EMERALIT"."EE_EMPL_HIST" 5.104 MB 100987 rows
. . imported "EMERALIT"."GL_DETAIL" 2.354 MB 37182 rows
. . imported "EMERALIT"."TM_TEMP_NEAP" 4.735 MB 99686 rows
. . imported "EMERALIT"."TM_TEMP_BRSTUFF_EMERALIT" 3.621 MB 108801 rows
. . imported "EMERALIT"."BR_COV_EE" 4.565 MB 240947 rows
. . imported "EMERALIT"."TM_TEMP2012_NEAP" 605.5 KB 40698 rows
. . imported "EMERALIT"."TM_TEMP2013_NEAP" 635.1 KB 42622 rows
. . imported "EMERALIT"."HOME_FUND_BATCH_SSN" 1.827 MB 49355 rows
. . imported "EMERALIT"."TM_TEMP2014_NEAP" 679.3 KB 45519 rows
. . imported "EMERALIT"."D10_ADDRESS" 1.721 MB 11390 rows
. . imported "EMERALIT"."FORM_PAGE" 513.0 KB 4890 rows
. . imported "EMERALIT"."TM_TEMP2015_NEAP" 577.0 KB 38611 rows
. . imported "EMERALIT"."AR_CUSTOMER" 381.6 KB 15226 rows
. . imported "EMERALIT"."TM_TEMP_CHECK_DATE" 1.640 MB 95448 rows
. . imported "EMERALIT"."TM_TEMP_NEAP_WHS_BALANCE" 1.615 MB 102634 rows
. . imported "EMERALIT"."BA_MISC" 323.1 KB 14909 rows
. . imported "EMERALIT"."BC_INTER_RESULTS" 335.5 KB 4741 rows
. . imported "EMERALIT"."TM_TEMP_NEAP_BALANCE" 1.432 MB 98394 rows
. . imported "EMERALIT"."HOME_FUND_BATCH" 199.8 KB 2661 rows
. . imported "EMERALIT"."AWARD_CTL" 2.964 MB 175708 rows
. . imported "EMERALIT"."MISC_DATA" 384.4 KB 177 rows
. . imported "EMERALIT"."USER_ACCESS" 392.8 KB 181 rows
. . imported "EMERALIT"."AR_OPEN_ITEM" 364.9 KB 3566 rows
. . imported "EMERALIT"."APPLICATION" 270.5 KB 6091 rows
. . imported "EMERALIT"."BA_COV_EE" 182.9 KB 5970 rows
. . imported "EMERALIT"."BR_EXTND" 1.924 MB 127485 rows
. . imported "EMERALIT"."BC_OPTIONS" 179.7 KB 4688 rows
. . imported "EMERALIT"."BA_UNIQUE" 931.9 KB 6091 rows
. . imported "EMERALIT"."BC_APPLICATION_MSG" 744.2 KB 7421 rows
. . imported "EMERALIT"."BC_SUMMARY" 184.6 KB 4657 rows
. . imported "EMERALIT"."BR_BC_D10" 245.4 KB 11529 rows
. . imported "EMERALIT"."AWARD_SSN_MVVW" 673.5 KB 62935 rows
. . imported "EMERALIT"."CLC_TEMP_DOLSSNS" 158.6 KB 14439 rows
. . imported "EMERALIT"."PABD_BA_NAME" 251.7 KB 6127 rows
. . imported "EMERALIT"."BR_MISC" 1.568 MB 75512 rows
. . imported "EMERALIT"."BR_REPORT" 747.1 KB 1675 rows
. . imported "EMERALIT"."APPLICANT" 89.89 KB 482 rows
. . imported "EMERALIT"."BATCH_PROCESS" 6.242 KB 58 rows
. . imported "EMERALIT"."BA_STAT" 10.92 KB 2 rows
. . imported "EMERALIT"."BC_CTL" 5.906 KB 1 rows
. . imported "EMERALIT"."BC_ESTIMATE_REQUEST" 13.89 KB 88 rows
. . imported "EMERALIT"."BC_OVERRIDE" 28.04 KB 509 rows
. . imported "EMERALIT"."BC_RESUMP_RECALC" 24.26 KB 292 rows
. . imported "EMERALIT"."BENEFIT_FLAG" 5.453 KB 1 rows
. . imported "EMERALIT"."BP_PARAMETER" 12.76 KB 36 rows
. . imported "EMERALIT"."BR_HIST_CTL" 5.460 KB 1 rows
. . imported "EMERALIT"."BR_LOG" 266.1 KB 54 rows
. . imported "EMERALIT"."BR_MONTHLY_VOID" 10.17 KB 289 rows
. . imported "EMERALIT"."BR_RPT_CTL" 5.460 KB 1 rows
. . imported "EMERALIT"."CORRESP_FOLLOW_UP" 13.49 KB 691 rows
. . imported "EMERALIT"."CORRESP_HEADER" 46.78 KB 764 rows
. . imported "EMERALIT"."CTL_COUNTERS" 5.976 KB 4 rows
. . imported "EMERALIT"."FORM_FORI" 133.2 KB 5929 rows
. . imported "EMERALIT"."FORM_FORMAT" 72.31 KB 999 rows
. . imported "EMERALIT"."FORM_FORO" 27.89 KB 1016 rows
. . imported "EMERALIT"."FORM_INSTRUCTIONS" 74.10 KB 1039 rows
. . imported "EMERALIT"."FORM_OINSTRUCTIONS" 24.76 KB 242 rows
. . imported "EMERALIT"."FORM_OTEXT" 91.08 KB 774 rows
. . imported "EMERALIT"."FUND_NAME" 5.445 KB 1 rows
. . imported "EMERALIT"."GEN_LEDGER" 6.492 KB 36 rows
. . imported "EMERALIT"."HOME_FUND" 84.79 KB 396 rows
. . imported "EMERALIT"."MENU_DEFINITION" 113.5 KB 45 rows
. . imported "EMERALIT"."MID_MONTH_CTL" 5.507 KB 1 rows
. . imported "EMERALIT"."RSN" 43.46 KB 722 rows
. . imported "EMERALIT"."TABLE_TYPE" 7.257 KB 98 rows
. . imported "EMERALIT"."TM_TEMP_BRSTUFF_NEAP" 146.5 KB 4096 rows
. . imported "EMERALIT"."TM_TEMP_CHECK_DATE_NEAP" 9.140 KB 211 rows
. . imported "EMERALIT"."TM_TEMP_STATE" 6.406 KB 60 rows
. . imported "EMERALIT"."BC_D10_OPTIONS" 0 KB 0 rows
. . imported "EMERALIT"."BC_PROJECTED_CREDITS" 0 KB 0 rows
. . imported "EMERALIT"."BR_D10_OPTIONS" 0 KB 0 rows
. . imported "EMERALIT"."CORRESP_DETAIL" 0 KB 0 rows
. . imported "EMERALIT"."CORRESP_NOTES" 0 KB 0 rows
. . imported "EMERALIT"."CORRESP_SEQ" 0 KB 0 rows
. . imported "EMERALIT"."MLOG$_PARTICIPANT_NAME" 0 KB 0 rows
. . imported "EMERALIT"."TM_TEMP_SSA_LETTER_INSERTS" 0 KB 0 rows
. . imported "EMERALIT"."BR_PAYMENT" 1.457 GB 15862396 rows
. . imported "EMERALIT"."PART_WORK_HISTORY" 3.882 GB 38168554 rows
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
ORA-31684: Object type INDEX:"EMERALIT"."PK_PARTICIPANT_NAME1" already exists
ORA-31684: Object type INDEX:"EMERALIT"."PK_PARTICIPANT1" already exists
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
ORA-31684: Object type CONSTRAINT:"EMERALIT"."PK_PARTICIPANT_NAME1" already exists
ORA-31684: Object type CONSTRAINT:"EMERALIT"."PK_PARTICIPANT1" already exists
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"EMERALIT"."PK_PARTICIPANT_NAME1" already exists
ORA-39111: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"EMERALIT"."PK_PARTICIPANT1" already exists
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION
Job "SYS"."SYS_IMPORT_TABLE_01" completed with 6 error(s) at 23:16:01
[ 19:28:08 02/23/17 ] Step 10 - Post import: Recreate SEQUENCE, GRANT, CONSTRAINT ...
+----------------------------+
| RECREATE EMERALIT.SEQUENCE |
+----------------------------+
Session altered.
Session altered.
Session altered.
Session altered.
Session altered.
Session altered.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
+-------------------------------+
| RECREATE EMERALITPRD.SEQUENCE |
+-------------------------------+
Session altered.
Session altered.
Session altered.
Session altered.
Session altered.
Session altered.
Sequence created.
Sequence created.
Session altered.
Session altered.
Session altered.
Session altered.
Session altered.
Session altered.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
Sequence created.
+-------------------------+
| RECREATE EMERALIT.GRANT |
+-------------------------+
Session altered.
Session altered.
Session altered.
Session altered.
Session altered.
Session altered.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
+----------------------------+
| RECREATE EMERALITPRD.GRANT |
+----------------------------+
Session altered.
Session altered.
Session altered.
Session altered.
Session altered.
Session altered.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
+------------------------------+
| RECREATE EMERALIT.CONSTRAINT |
+------------------------------+
Session altered.
Session altered.
Session altered.
Session altered.
Session altered.
Session altered.
[ 19:28:15 02/23/17 ] Step 11 - Post import: Recompile Objects by utlrp.sql ...
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2017-02-23 19:28:15
PL/SQL procedure successfully completed.
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END 2017-02-23 19:28:20
OBJECTS WITH ERRORS
-------------------
0
ERRORS DURING RECOMPILATION
---------------------------
0
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
[ 19:28:25 02/23/17 ] Step 12 - Post import: Invalid Objects After Refresh ...
OWNER OBJECT_NAME OBJECT_TYPE
--------------- ------------------------------ -------------------
EMERALITPRD REC_PARSE_DATA_INTO_AUTHORIZ PROCEDURE
EMERALITPRD P_UPDATE_ADDRESS_FROM_PORTAL PROCEDURE
EMERALITPRD AD_TRACK_STAGE PACKAGE BODY
EMERALITPRD P_INSERT_OUTGOING_SCHEDULE PROCEDURE
EMERALITPRD P_CREATE_OR_UPDATE_SCHEDULE PROCEDURE
EMERALITPRD WORKFLOWHISTORY_REPORT PROCEDURE
EMERALITPRD P_LOAD_IR_FILES PROCEDURE
EMERALIT NEAP_PAIDOUT_REAPPLIED PROCEDURE
EMERALIT WORKFLOWHISTORY_REPORT PROCEDURE
EMERALIT F_GET_SUMMARY_OLD_BALANCE FUNCTION
EMERALIT F_GET_DETAIL_OLD_BALANCE FUNCTION
EMERALIT T_PORTAL_ADDRESS_UPDATE_TYPE TYPE
12 rows selected.
[ 19:28:25 02/23/17 ] Step 13 - Refresh complete
Your Comments