+-----------------------------------------------+
| EMERALIT Data Auto Refresh                    |
| Date: 19:10:01 02/23/17                       |
| Source Server: 172.31.10.56                   |
| Target Server: 172.31.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.

 CREATE SEQUENCE  "EMERALITPRD"."EBB_DIST_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
                            *
ERROR at line 1:
ORA-00955: name is already used by an existing object


 CREATE SEQUENCE  "EMERALITPRD"."LOCAL_DIST_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE
                            *
ERROR at line 1:
ORA-00955: name is already used by an existing object



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 EXECUTE, DEBUG ON "EMERALITPRD"."EMPLOYER_ADDRESS" TO "SPR"
                                  *
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist



Grant succeeded.


Grant succeeded.

+------------------------------+
| RECREATE EMERALIT.CONSTRAINT |
+------------------------------+

Session altered.


Session altered.


Session altered.


Session altered.


Session altered.


Session altered.

ALTER TABLE "EMERALIT"."APPLICANT" ADD CONSTRAINT "PK_APPLICANT" PRIMARY KEY ("ROW_APPLICANT")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."APPLICATION" ADD CONSTRAINT "PK_APPLICATION" PRIMARY KEY ("ROW_APPLICATION")
                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."AR_CUSTOMER" ADD CONSTRAINT "PK_AR_CUSTOMER" PRIMARY KEY ("ROW_AR_CUSTOMER")
                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."AR_CUSTOMER" ADD CONSTRAINT "K0_AR_CUSTOMER" UNIQUE ("CUST_KEY")
                                                                 *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."AR_OPEN_ITEM" ADD CONSTRAINT "PK_AR_OPEN_ITEM" PRIMARY KEY ("ROW_AR_OPEN_ITEM")
                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."AWARD_CTL" ADD CONSTRAINT "PK_AWARD_CTL" PRIMARY KEY ("ROW_AWARD_CTL")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."AWARD_CTL" ADD CONSTRAINT "K0_AWARD_CTL" UNIQUE ("AWARD_CTL_SSN")
                                                             *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."BA_COV_EE" ADD CONSTRAINT "PK_BA_COV_EE" PRIMARY KEY ("ROW_BA_COV_EE")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BA_COV_EE" ADD CONSTRAINT "K0_BA_COV_EE" UNIQUE ("EE_SSN")
                                                             *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."BA_STAT" ADD CONSTRAINT "PK_BA_STAT" PRIMARY KEY ("ROW_BA_STAT")
                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BA_UNIQUE" ADD CONSTRAINT "PK_BA_UNIQUE" PRIMARY KEY ("ROW_BA_UNIQUE")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BATCH_PROCESS" ADD CONSTRAINT "PK_BATCH_PROCESS" PRIMARY KEY ("ROW_BATCH_PROCESS")
                                                                     *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BATCH_PROCESS" ADD CONSTRAINT "K0_BATCH_PROCESS" UNIQUE ("BATP_BATCH_KEY")
                                                                     *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."BC_APPLICATION_MSG" ADD CONSTRAINT "PK_BC_APPLICATION_MSG" PRIMARY KEY ("ROW_BC_APPLICATION_MSG")
                                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BC_BENEFIT_TBL" ADD CONSTRAINT "PK_BC_BENEFIT_TBL" PRIMARY KEY ("ROW_BC_BENEFIT_TBL")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BC_CTL" ADD CONSTRAINT "PK_BC_CTL" PRIMARY KEY ("ROW_BC_CTL")
                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BC_D10_OPTIONS" ADD CONSTRAINT "PK_BC_D10_OPTIONS" PRIMARY KEY ("ROW_BC_D10_OPTIONS")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BC_ELIGIBILITY_TBL" ADD CONSTRAINT "PK_BC_ELIGIBILITY_TBL" PRIMARY KEY ("ROW_BC_ELIGIBILITY_TBL")
                                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BC_ESTIMATE_REQUEST" ADD CONSTRAINT "PK_BC_ESTIMATE_REQUEST" PRIMARY KEY ("ROW_BC_ESTIMATE_REQUEST")
                                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BC_INTER_RESULTS" ADD CONSTRAINT "PK_BC_INTER_RESULTS" PRIMARY KEY ("ROW_BC_INTER_RESULTS")
                                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BC_OPTIONS" ADD CONSTRAINT "PK_BC_OPTIONS" PRIMARY KEY ("ROW_BC_OPTIONS")
                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BC_OVERRIDE" ADD CONSTRAINT "PK_BC_OVERRIDE" PRIMARY KEY ("ROW_BC_OVERRIDE")
                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BC_PROJECTED_CREDITS" ADD CONSTRAINT "PK_BC_PROJECTED_CREDITS" PRIMARY KEY ("ROW_BC_PROJECTED_CREDITS")
                                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BC_RESUMP_RECALC" ADD CONSTRAINT "PK_BC_RESUMP_RECALC" PRIMARY KEY ("ROW_BC_RESUMP_RECALC")
                                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BC_SUMMARY" ADD CONSTRAINT "PK_BC_SUMMARY" PRIMARY KEY ("ROW_BC_SUMMARY")
                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BENEFICIARY" ADD CONSTRAINT "PK_BENEFICIARY" PRIMARY KEY ("ROW_BENEFICIARY")
                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BENEFIT_FLAG" ADD CONSTRAINT "PK_BENEFIT_FLAG" PRIMARY KEY ("ROW_BENEFIT_FLAG")
                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BENEFIT_FLAG" ADD CONSTRAINT "K0_BENEFIT_FLAG" UNIQUE ("BEN_FLAG_KEY")
                                                                   *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."BP_PARAMETER" ADD CONSTRAINT "PK_BP_PARAMETER" PRIMARY KEY ("ROW_BP_PARAMETER")
                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR" ADD CONSTRAINT "PK_BR" PRIMARY KEY ("ROW_BR")
                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR" ADD CONSTRAINT "K0_BR" UNIQUE ("BR_SSN")
                                               *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."BR_AWARD" ADD CONSTRAINT "PK_BR_AWARD" PRIMARY KEY ("ROW_BR_AWARD")
                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR_BC_D10" ADD CONSTRAINT "PK_BR_BC_D10" PRIMARY KEY ("ROW_BR_BC_D10")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR_BC_D10" ADD CONSTRAINT "K0_BR_BC_D10" UNIQUE ("BR_BC_KEY")
                                                             *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."BR_CENSUS" ADD CONSTRAINT "PK_BR_CENSUS" PRIMARY KEY ("ROW_BR_CENSUS")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR_CHECK_ADDR" ADD CONSTRAINT "PK_BR_CHECK_ADDR" PRIMARY KEY ("ROW_BR_CHECK_ADDR")
                                                                     *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR_COV_EE" ADD CONSTRAINT "PK_BR_COV_EE" PRIMARY KEY ("ROW_BR_COV_EE")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR_COV_EE" ADD CONSTRAINT "K0_BR_COV_EE" UNIQUE ("BR_COV_EE_SSN")
                                                             *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."BR_D10_OPTIONS" ADD CONSTRAINT "PK_BR_D10_OPTIONS" PRIMARY KEY ("ROW_BR_D10_OPTIONS")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR_EXTND" ADD CONSTRAINT "PK_BR_EXTND" PRIMARY KEY ("ROW_BR_EXTND")
                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR_EXTND" ADD CONSTRAINT "K0_BR_EXTND" UNIQUE ("BR_EXTND_SSN")
                                                           *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."BR_HIST_CTL" ADD CONSTRAINT "PK_BR_HIST_CTL" PRIMARY KEY ("ROW_BR_HIST_CTL")
                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR_HISTORY" ADD CONSTRAINT "PK_BR_HISTORY" PRIMARY KEY ("ROW_BR_HISTORY")
                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR_LOG" ADD CONSTRAINT "PK_BR_LOG" PRIMARY KEY ("ROW_BR_LOG")
                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR_MONTHLY_VOID" ADD CONSTRAINT "PK_BR_MONTHLY_VOID" PRIMARY KEY ("ROW_BR_MONTHLY_VOID")
                                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR_MONTHLY_VOID" ADD CONSTRAINT "K0_BR_MONTHLY_VOID" UNIQUE ("BR_MVD_DATE_KEY")
                                                                         *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."BR_PAYMENT" ADD CONSTRAINT "PK_BR_PAYMENT" PRIMARY KEY ("ROW_BR_PAYMENT")
                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR_PAYMENT_EXTND" ADD CONSTRAINT "PK_BR_PAYMENT_EXTND" PRIMARY KEY ("ROW_BR_PAYMENT_EXTND")
                                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR_REPORT" ADD CONSTRAINT "PK_BR_REPORT" PRIMARY KEY ("ROW_BR_REPORT")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR_RPT_CTL" ADD CONSTRAINT "PK_BR_RPT_CTL" PRIMARY KEY ("ROW_BR_RPT_CTL")
                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR_UNIQUE" ADD CONSTRAINT "PK_BR_UNIQUE" PRIMARY KEY ("ROW_BR_UNIQUE")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR_VOID" ADD CONSTRAINT "PK_BR_VOID" PRIMARY KEY ("ROW_BR_VOID")
                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."CBAS_PLAN_EXTND" ADD CONSTRAINT "PK_CBAS_PLAN_EXTND" PRIMARY KEY ("ROW_CBAS_PLAN_EXTND")
                                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."CBAS_SSN_EXTND" ADD CONSTRAINT "PK_CBAS_SSN_EXTND" PRIMARY KEY ("ROW_CBAS_SSN_EXTND")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."CBAS_SSN_EXTND" ADD CONSTRAINT "K0_CBAS_SSN_EXTND" UNIQUE ("CBAS_EX_SSN")
                                                                       *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."CBAS_WHS_EXTND" ADD CONSTRAINT "PK_CBAS_WHS_EXTND" PRIMARY KEY ("ROW_CBAS_WHS_EXTND")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."CORRESP_DETAIL" ADD CONSTRAINT "PK_CORRESP_DETAIL" PRIMARY KEY ("ROW_CORRESP_DETAIL")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."CORRESP_FOLLOW_UP" ADD CONSTRAINT "PK_CORRESP_FOLLOW_UP" PRIMARY KEY ("ROW_CORRESP_FOLLOW_UP")
                                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."CORRESP_FOLLOW_UP" ADD CONSTRAINT "K0_CORRESP_FOLLOW_UP" UNIQUE ("CFU_DATE_KEY")
                                                                             *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."CORRESP_HEADER" ADD CONSTRAINT "K0_CORRESP_HEADER" UNIQUE ("CORRESP_NO_KEY")
                                                                       *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."CORRESP_HEADER" ADD CONSTRAINT "PK_CORRESP_HEADER" PRIMARY KEY ("ROW_CORRESP_HEADER")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."CORRESP_NOTES" ADD CONSTRAINT "PK_CORRESP_NOTES" PRIMARY KEY ("ROW_CORRESP_NOTES")
                                                                     *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."CORRESP_SEQ" ADD CONSTRAINT "PK_CORRESP_SEQ" PRIMARY KEY ("ROW_CORRESP_SEQ")
                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."CTL_COUNTERS" ADD CONSTRAINT "PK_CTL_COUNTERS" PRIMARY KEY ("ROW_CTL_COUNTERS")
                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."D10_ADDRESS" ADD CONSTRAINT "PK_D10_ADDRESS" PRIMARY KEY ("ROW_D10_ADDRESS")
                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."DEATH_DATA" ADD CONSTRAINT "PK_DEATH_DATA" PRIMARY KEY ("ROW_DEATH_DATA")
                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."EE_EMPL_HIST" ADD CONSTRAINT "PK_EE_EMPL_HIST" PRIMARY KEY ("ROW_EE_EMPL_HIST")
                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."FORM_FORMAT" ADD CONSTRAINT "PK_FORM_FORMAT" PRIMARY KEY ("ROW_FORM_FORMAT")
                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."FORM_INSTRUCTIONS" ADD CONSTRAINT "PK_FORM_INSTRUCTIONS" PRIMARY KEY ("ROW_FORM_INSTRUCTIONS")
                                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."FORM_OINSTRUCTIONS" ADD CONSTRAINT "PK_FORM_OINSTRUCTIONS" PRIMARY KEY ("ROW_FORM_OINSTRUCTIONS")
                                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."FORM_OTEXT" ADD CONSTRAINT "PK_FORM_OTEXT" PRIMARY KEY ("ROW_FORM_OTEXT")
                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."FORM_PAGE" ADD CONSTRAINT "PK_FORM_PAGE" PRIMARY KEY ("ROW_FORM_PAGE")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."FUND_NAME" ADD CONSTRAINT "PK_FUND_NAME" PRIMARY KEY ("ROW_FUND_NAME")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."FUND_NAME" ADD CONSTRAINT "K0_FUND_NAME" UNIQUE ("FUNN_KEY")
                                                             *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."GEN_LEDGER" ADD CONSTRAINT "PK_GEN_LEDGER" PRIMARY KEY ("ROW_GEN_LEDGER")
                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."GEN_LEDGER" ADD CONSTRAINT "K0_GEN_LEDGER" UNIQUE ("GEN_LEDG_KEY")
                                                               *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."GL_DETAIL" ADD CONSTRAINT "PK_GL_DETAIL" PRIMARY KEY ("ROW_GL_DETAIL")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."HOME_FUND" ADD CONSTRAINT "PK_HOME_FUND" PRIMARY KEY ("ROW_HOME_FUND")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."HOME_FUND" ADD CONSTRAINT "K0_HOME_FUND" UNIQUE ("ID_KEY")
                                                             *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."HOME_FUND_BATCH" ADD CONSTRAINT "PK_HOME_FUND_BATCH" PRIMARY KEY ("ROW_HOME_FUND_BATCH")
                                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."HOME_FUND_BATCH_SSN" ADD CONSTRAINT "PK_HOME_FUND_BATCH_SSN" PRIMARY KEY ("ROW_HOME_FUND_BATCH_SSN")
                                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."IBEW_CARD" ADD CONSTRAINT "PK_IBEW_CARD" PRIMARY KEY ("ROW_IBEW_CARD")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."IBEW_CARD" ADD CONSTRAINT "K0_IBEW_CARD" UNIQUE ("IBEW_CARD_KEY")
                                                             *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."MENU_DEFINITION" ADD CONSTRAINT "PK_MENU_DEFINITION" PRIMARY KEY ("ROW_MENU_DEFINITION")
                                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."MID_MONTH_CTL" ADD CONSTRAINT "PK_MID_MONTH_CTL" PRIMARY KEY ("ROW_MID_MONTH_CTL")
                                                                     *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."MISC_DATA" ADD CONSTRAINT "PK_MISC_DATA" PRIMARY KEY ("ROW_MISC_DATA")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."MISC_DATA" ADD CONSTRAINT "K0_MISC_DATA" UNIQUE ("KEY1")
                                                             *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."PABD_BA_NAME" ADD CONSTRAINT "PK_PABD_BA_NAME" PRIMARY KEY ("ROW_PABD_BA_NAME")
                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."PABD_BR_NAME" ADD CONSTRAINT "PK_PABD_BR_NAME" PRIMARY KEY ("ROW_PABD_BR_NAME")
                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."PABD_NAME_SRCH" ADD CONSTRAINT "PK_PABD_NAME_SRCH" PRIMARY KEY ("ROW_PABD_NAME_SRCH")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."PART_WORK_HISTORY" ADD CONSTRAINT "PK_PART_WORK_HISTORY" PRIMARY KEY ("ROW_PART_WORK_HISTORY")
                                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."PARTICIPANT" ADD CONSTRAINT "PK_PARTICIPANT" PRIMARY KEY ("ROW_PARTICIPANT")
                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."PARTICIPANT" ADD CONSTRAINT "K0_PARTICIPANT" UNIQUE ("SSN_KEY")
                                                                 *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."PARTICIPANT_FLAGS" ADD CONSTRAINT "PK_PARTICIPANT_FLAGS" PRIMARY KEY ("ROW_PARTICIPANT_FLAGS")
                                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."PARTICIPANT_NAME" ADD CONSTRAINT "PK_PARTICIPANT_NAME" PRIMARY KEY ("ROW_PARTICIPANT_NAME")
                                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."PARTICIPANT_NAME" ADD CONSTRAINT "K1_PARTICIPANT_NAME" UNIQUE ("NAME_KEY")
                                                                           *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."PARTICIPANT_PLAN" ADD CONSTRAINT "PK_PARTICIPANT_PLAN" PRIMARY KEY ("ROW_PARTICIPANT_PLAN")
                                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."RSN" ADD CONSTRAINT "PK_RSN" PRIMARY KEY ("ROW_RSN")
                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."RSN" ADD CONSTRAINT "K0_RSN" UNIQUE ("KEY1")
                                                 *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."TABLE_TYPE" ADD CONSTRAINT "PK_TABLE_TYPE" PRIMARY KEY ("ROW_TABLE_TYPE")
                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."USER_ACCESS" ADD CONSTRAINT "PK_USER_ACCESS" PRIMARY KEY ("ROW_USER_ACCESS")
                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."USER_ACCESS" ADD CONSTRAINT "K0_USER_ACCESS" UNIQUE ("ID_NO_KEY")
                                                                 *
ERROR at line 1:
ORA-02261: such unique or primary key already exists in the table


ALTER TABLE "EMERALIT"."WORK_HIST_SUMMARY" ADD CONSTRAINT "PK_WORK_HIST_SUMMARY" PRIMARY KEY ("ROW_WORK_HIST_SUMMARY")
                                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."FORM_FORO" ADD CONSTRAINT "PK_FORM_FORO" PRIMARY KEY ("OWN_FORM_FORO", "POS_FORM_FORO")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."FORM_FORI" ADD CONSTRAINT "PK_FORM_FORI" PRIMARY KEY ("OWN_FORM_FORI", "POS_FORM_FORI")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."PABD_NS" ADD CONSTRAINT "PK_PABD_NS" PRIMARY KEY ("OWN_PABD_NS", "POS_PABD_NS")
                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BA_MISC" ADD CONSTRAINT "PK_BA_MISC" PRIMARY KEY ("OWN_BA_MISC", "POS_BA_MISC")
                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."BR_MISC" ADD CONSTRAINT "PK_BR_MISC" PRIMARY KEY ("OWN_BR_MISC", "POS_BR_MISC")
                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."PARTICIPANT_NAME_STR_MV" ADD CONSTRAINT "PK_PARTICIPANT_NAME1" PRIMARY KEY ("ROW_PARTICIPANT_NAME")
                                                            *
ERROR at line 1:
ORA-02264: name already used by an existing constraint


ALTER TABLE "EMERALIT"."PARTICIPANT_NUM_MV" ADD CONSTRAINT "PK_PARTICIPANT1" PRIMARY KEY ("ROW_PARTICIPANT")
                                                       *
ERROR at line 1:
ORA-02264: name already used by an existing constraint


ALTER TABLE "EMERALIT"."TM_TEMP_IBEW_REQ" ADD CONSTRAINT "TM_TEMP_IBEW_REQ_PK" PRIMARY KEY ("IBEW_ID")
                                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALIT"."APPLICANT" ADD CONSTRAINT "SET_BA_APPLT" FOREIGN KEY ("OWN_BA_APPLT")
                                                             *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."AR_OPEN_ITEM" ADD CONSTRAINT "SET_ARC_AROI" FOREIGN KEY ("OWN_ARC_AROI")
                                                                *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BA_UNIQUE" ADD CONSTRAINT "SET_BA_UNI" FOREIGN KEY ("OWN_BA_UNI")
                                                           *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BC_APPLICATION_MSG" ADD CONSTRAINT "SET_BA_MSGS" FOREIGN KEY ("OWN_BA_MSGS")
                                                                     *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BC_BENEFIT_TBL" ADD CONSTRAINT "SET_BA_BTS" FOREIGN KEY ("OWN_BA_BTS")
                                                                *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BC_D10_OPTIONS" ADD CONSTRAINT "SET_BC_D10_OPTIONS" FOREIGN KEY ("OWN_BC_D10_OPTIONS")
                                                                        *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BC_ELIGIBILITY_TBL" ADD CONSTRAINT "SET_BA_ETS" FOREIGN KEY ("OWN_BA_ETS")
                                                                    *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BC_ESTIMATE_REQUEST" ADD CONSTRAINT "SET_BA_EST_REQS" FOREIGN KEY ("OWN_BA_EST_REQS")
                                                                          *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BC_INTER_RESULTS" ADD CONSTRAINT "SET_BA_MISC2" FOREIGN KEY ("OWN_BA_MISC")
                                                                    *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BC_OPTIONS" ADD CONSTRAINT "SET_BA_MISC3" FOREIGN KEY ("OWN_BA_MISC")
                                                              *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BC_OVERRIDE" ADD CONSTRAINT "SET_BA_MISC4" FOREIGN KEY ("OWN_BA_MISC")
                                                               *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BC_PROJECTED_CREDITS" ADD CONSTRAINT "SET_BA_PCS" FOREIGN KEY ("OWN_BA_PCS")
                                                                      *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BC_RESUMP_RECALC" ADD CONSTRAINT "SET_BA_MISC5" FOREIGN KEY ("OWN_BA_MISC")
                                                                    *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BC_SUMMARY" ADD CONSTRAINT "SET_BA_MISC1" FOREIGN KEY ("OWN_BA_MISC")
                                                              *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BENEFICIARY" ADD CONSTRAINT "SET_BA_BENFS" FOREIGN KEY ("OWN_BA_BENFS")
                                                               *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BP_PARAMETER" ADD CONSTRAINT "SET_BATP_BTP" FOREIGN KEY ("OWN_BATP_BTP")
                                                                *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BR_AWARD" ADD CONSTRAINT "SET_BR_EE_AWD" FOREIGN KEY ("OWN_BR_EE_AWD")
                                                             *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BR_CENSUS" ADD CONSTRAINT "SET_BR_MISC1" FOREIGN KEY ("OWN_BR_MISC")
                                                             *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BR_CHECK_ADDR" ADD CONSTRAINT "SET_BR_MISC2" FOREIGN KEY ("OWN_BR_MISC")
                                                                 *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BR_D10_OPTIONS" ADD CONSTRAINT "SET_BR_D10_OPTIONS" FOREIGN KEY ("OWN_BR_D10_OPTIONS")
                                                                        *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BR_HISTORY" ADD CONSTRAINT "SET_BR_HIST" FOREIGN KEY ("OWN_BR_HIST")
                                                             *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BR_PAYMENT" ADD CONSTRAINT "SET_BR_PAY" FOREIGN KEY ("OWN_BR_PAY")
                                                            *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BR_PAYMENT_EXTND" ADD CONSTRAINT "SET_BR_PAY_EXTND" FOREIGN KEY ("OWN_BR_PAY_EXTND")
                                                                        *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BR_REPORT" ADD CONSTRAINT "SET_BR_RPT" FOREIGN KEY ("OWN_BR_RPT")
                                                           *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BR_UNIQUE" ADD CONSTRAINT "SET_BR_AWD" FOREIGN KEY ("OWN_BR_AWD")
                                                           *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BR_UNIQUE" ADD CONSTRAINT "SET_BR_UNI" FOREIGN KEY ("OWN_BR_UNI")
                                                           *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."BR_VOID" ADD CONSTRAINT "SET_BR_MTH_VOID" FOREIGN KEY ("OWN_BR_MTH_VOID")
                                                              *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."CBAS_PLAN_EXTND" ADD CONSTRAINT "SET_CBAS_PLN_EXT" FOREIGN KEY ("OWN_CBAS_PLN_EXT")
                                                                       *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."CBAS_WHS_EXTND" ADD CONSTRAINT "SET_CBAS_WHS_EXT" FOREIGN KEY ("OWN_CBAS_WHS_EXT")
                                                                      *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."CORRESP_DETAIL" ADD CONSTRAINT "SET_CORS_CORD" FOREIGN KEY ("OWN_CORS_CORD")
                                                                   *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."CORRESP_HEADER" ADD CONSTRAINT "SET_CFU_CORH" FOREIGN KEY ("OWN_CFU_CORH")
                                                                  *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."CORRESP_NOTES" ADD CONSTRAINT "SET_CORH_CORN" FOREIGN KEY ("OWN_CORH_CORN")
                                                                  *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."CORRESP_SEQ" ADD CONSTRAINT "SET_CORH_CORS" FOREIGN KEY ("OWN_CORH_CORS")
                                                                *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."D10_ADDRESS" ADD CONSTRAINT "SET_BR_D10_ADDR" FOREIGN KEY ("OWN_BR_D10_ADDR")
                                                                  *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."DEATH_DATA" ADD CONSTRAINT "SET_PART_DETH" FOREIGN KEY ("OWN_PART_DETH")
                                                               *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."EE_EMPL_HIST" ADD CONSTRAINT "SET_EE_EHS" FOREIGN KEY ("OWN_EE_EHS")
                                                              *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."FORM_INSTRUCTIONS" ADD CONSTRAINT "SET_FORM_FORI1" FOREIGN KEY ("OWN_FORM_FORI")
                                                                       *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."FORM_OINSTRUCTIONS" ADD CONSTRAINT "SET_FORM_FORO2" FOREIGN KEY ("OWN_FORM_FORO")
                                                                        *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."FORM_OTEXT" ADD CONSTRAINT "SET_FORM_FORO1" FOREIGN KEY ("OWN_FORM_FORO")
                                                                *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."FORM_PAGE" ADD CONSTRAINT "SET_FORM_FORI2" FOREIGN KEY ("OWN_FORM_FORI")
                                                               *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."GL_DETAIL" ADD CONSTRAINT "SET_GEN_GEND" FOREIGN KEY ("OWN_GEN_GEND")
                                                             *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."HOME_FUND" ADD CONSTRAINT "SET_FUNN_HFUN" FOREIGN KEY ("OWN_FUNN_HFUN")
                                                              *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."HOME_FUND_BATCH" ADD CONSTRAINT "SET_HFUN_HFB" FOREIGN KEY ("OWN_HFUN_HFB")
                                                                   *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."HOME_FUND_BATCH_SSN" ADD CONSTRAINT "SET_HFUN_BAT_SSN" FOREIGN KEY ("OWN_HFUN_BAT_SSN")
                                                                           *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."IBEW_CARD" ADD CONSTRAINT "SET_PART_IBEW" FOREIGN KEY ("OWN_PART_IBEW")
                                                              *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."PABD_BA_NAME" ADD CONSTRAINT "SET_PABD_NS1" FOREIGN KEY ("OWN_PABD_NS")
                                                                *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."PABD_BR_NAME" ADD CONSTRAINT "SET_PABD_NS2" FOREIGN KEY ("OWN_PABD_NS")
                                                                *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."PART_WORK_HISTORY" ADD CONSTRAINT "SET_PART_PWH" FOREIGN KEY ("OWN_PART_PWH")
                                                                     *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."PARTICIPANT" ADD CONSTRAINT "SET_PXRF_PART" FOREIGN KEY ("OWN_PXRF_PART")
                                                                *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."PARTICIPANT_FLAGS" ADD CONSTRAINT "SET_PART_FLAG" FOREIGN KEY ("OWN_PART_FLAG")
                                                                      *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."PARTICIPANT_PLAN" ADD CONSTRAINT "SET_PART_PARP" FOREIGN KEY ("OWN_PART_PARP")
                                                                     *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."RSN" ADD CONSTRAINT "SET_RSNS" FOREIGN KEY ("OWN_RSNS")
                                                   *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


ALTER TABLE "EMERALIT"."WORK_HIST_SUMMARY" ADD CONSTRAINT "SET_PARP_WHS" FOREIGN KEY ("OWN_PARP_WHS")
                                                                     *
ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table


+---------------------------------+
| RECREATE EMERALITPRD.CONSTRAINT |
+---------------------------------+

Session altered.


Session altered.


Session altered.


Session altered.


Session altered.


Session altered.

ALTER TABLE "EMERALITPRD"."ACCOUNT" ADD CONSTRAINT "PKACCOUNT" PRIMARY KEY ("PID")
                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."AR_EXPORT" ADD CONSTRAINT "PKAR_EXPORT" PRIMARY KEY ("AR_ID")
                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."BANK_ACCOUNT" ADD CONSTRAINT "PKBANK_ACCOUNT" PRIMARY KEY ("BANK_ID")
                                                                     *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."BAT_ADJ_TYPES" ADD CONSTRAINT "PKBAT_ADJ_TYPES" PRIMARY KEY ("BADJT_TYPE")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."BAT_ADJUSTMENTS" ADD CONSTRAINT "PKBAT_ADJUSTMENTS" PRIMARY KEY ("BADJ_ID")
                                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."BATCH_HEADER" ADD CONSTRAINT "PKBATCH_HEADER" PRIMARY KEY ("BAT_ID")
                                                                     *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."BATCH_STATUS" ADD CONSTRAINT "PKBATCH_STATUS" PRIMARY KEY ("BSTAT_CODE")
                                                                     *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."BENEFIT_BOARD" ADD CONSTRAINT "PKBENEFIT_BOARD" PRIMARY KEY ("EBB_NO_KEY")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."BOARD_CONTACT" ADD CONSTRAINT "PKBOARD_CONTACT" PRIMARY KEY ("EBBCON_ID")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."BOARD_HISTORY" ADD CONSTRAINT "PKBOARD_HISTORY" PRIMARY KEY ("EBBHIST_ID")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."CHECKLIST_NEAP" ADD CONSTRAINT "PKCHECKLIST_NEAP" PRIMARY KEY ("CKD_SSN")
                                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."CHECKLIST_EMERALIT" ADD CONSTRAINT "PKCHECKLIST_EMERALIT" PRIMARY KEY ("CKN_SSN")
                                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."CHECKLIST_PART" ADD CONSTRAINT "PKCHECKLIST_PART" PRIMARY KEY ("CKP_SSN")
                                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."COMB_ACTIVATION_HIST" ADD CONSTRAINT "PKCOMB_ACTIVATION_HIST" PRIMARY KEY ("COMBHIST_ID")
                                                                                     *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."COMB_ADDRESS_HIST" ADD CONSTRAINT "PKCOMB_ADDRESS_HIST" PRIMARY KEY ("CADDRHIST_ID")
                                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."COMBINATION_ADDRESS" ADD CONSTRAINT "PKCOMBINATION_ADDRESS" PRIMARY KEY ("COMBADDR_ID")
                                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."COMB_NAME_HIST" ADD CONSTRAINT "PKCOMB_NAME_HIST" PRIMARY KEY ("CNAMEHIST_ID")
                                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."CRR_DEPOSIT" ADD CONSTRAINT "PKCRR_DEPOSIT" PRIMARY KEY ("DEP_ID")
                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."CRR_DETAIL" ADD CONSTRAINT "PKCRR_DETAIL" PRIMARY KEY ("CRRD_ID")
                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."DDHISTORY" ADD CONSTRAINT "PKDDHISTORY" PRIMARY KEY ("PID")
                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."DDLOCATOR" ADD CONSTRAINT "PKDDLOCATOR" PRIMARY KEY ("PID")
                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."DELETED_PARTICIPANTS" ADD CONSTRAINT "PKDELETED_PARTICIPANTS" PRIMARY KEY ("DELPART_ID")
                                                                                     *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."EBB_REIMBURSE_HIST" ADD CONSTRAINT "PKEBB_REIMBURSE_HIST" PRIMARY KEY ("EBBREIM_ID")
                                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."ECH_ADJ_REASONS" ADD CONSTRAINT "PKECH_ADJ_REASONS" PRIMARY KEY ("ECHADJR_REASON_CODE")
                                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."ECH_ADJUSTMENTS" ADD CONSTRAINT "PKECH_ADJUSTMENTS" PRIMARY KEY ("ECHADJ_ID")
                                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."ECH_PLAN_TOTALS" ADD CONSTRAINT "PKECH_PLAN_TOTALS" PRIMARY KEY ("ECHPLAN_ID")
                                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."EMP_COMBINATION" ADD CONSTRAINT "PKEMP_COMBINATION" PRIMARY KEY ("COMB_ID")
                                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."EMPLOYER_CONTRIB_HISTORY" ADD CONSTRAINT "PKEMPLOYER_CONTRIB_HISTORY" PRIMARY KEY ("ECH_ID")
                                                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."EMPLOYER_CONTRIB_PURGE" ADD CONSTRAINT "PKEMPLOYER_CONTRIB_PURGE" PRIMARY KEY ("ECP_ID")
                                                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."EMPLOYER_LINK" ADD CONSTRAINT "PKEMPLOYER_LINK" PRIMARY KEY ("LINK_ID")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."EMPLOYER" ADD CONSTRAINT "PKEMPLOYER" PRIMARY KEY ("EMP_FED_ID")
                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."FEDERAL_ID" ADD CONSTRAINT "PKFEDERAL_ID" PRIMARY KEY ("FED_ID_NEXT")
                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."FED_ID_XREF" ADD CONSTRAINT "PKFED_ID_XREF" PRIMARY KEY ("FX_FED_ID_INPUT")
                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."GL_EXPORT" ADD CONSTRAINT "PKGL_EXPORT" PRIMARY KEY ("GL_ID")
                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."JOB_CLASS" ADD CONSTRAINT "PKJOB_CLASS" PRIMARY KEY ("JOB_CLASS_CODE")
                                                               *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."LOC_ACTIVATION_HIST" ADD CONSTRAINT "PKLOC_ACTIVATION_HIST" PRIMARY KEY ("LOCACT_ID")
                                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."LOCAL_CONTACT" ADD CONSTRAINT "PKLOCAL_CONTACT" PRIMARY KEY ("LOCCON_ID")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."LOCAL_HISTORY" ADD CONSTRAINT "PKLOCAL_HISTORY" PRIMARY KEY ("LOCHIST_ID")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."LOCAL_UNION" ADD CONSTRAINT "PKLOCAL_UNION" PRIMARY KEY ("LOC_UNION_NO_KEY")
                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."MERGE_DETAIL" ADD CONSTRAINT "PKMERGE_DETAIL" PRIMARY KEY ("DET_ID")
                                                                     *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."MERGE_HISTORY" ADD CONSTRAINT "PKMERGE_HISTORY" PRIMARY KEY ("MERGE_ID")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."METHOD" ADD CONSTRAINT "PKMETHOD" PRIMARY KEY ("METHODCODE")
                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."MONEY_RECEIVED" ADD CONSTRAINT "PKMONEY_RECEIVED" PRIMARY KEY ("MONEY_ID")
                                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."MONEY_TYPES" ADD CONSTRAINT "PKMONEY_TYPES" PRIMARY KEY ("MONEY_TYPE_CODE")
                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."MPR_ADJ_TYPES" ADD CONSTRAINT "PKMPR_ADJ_TYPES" PRIMARY KEY ("MADJT_TYPE")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."MPR_ADJUSTMENTS" ADD CONSTRAINT "PKMPR_ADJUSTMENTS" PRIMARY KEY ("MADJ_ID")
                                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."MPR_DETAIL" ADD CONSTRAINT "PKMPR_DETAIL" PRIMARY KEY ("MPRD_ID")
                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."MPR_STATUS" ADD CONSTRAINT "PKMPR_STATUS" PRIMARY KEY ("MSTAT_CODE")
                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."NEAPPARTBAL" ADD CONSTRAINT "PKNEAPPARTBAL" PRIMARY KEY ("SSN")
                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."NEAP_PARTICIPANT" ADD CONSTRAINT "PKNEAP_PARTICIPANT" PRIMARY KEY ("PART_SSN")
                                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."NECA_REGION" ADD CONSTRAINT "PKNECA_REGION" PRIMARY KEY ("NECA_REGION_NO_KEY")
                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."NON_BARGAINING" ADD CONSTRAINT "PKNON_BARGAINING" PRIMARY KEY ("NB_ID")
                                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."PARTICIPATION_AGREEMENT" ADD CONSTRAINT "PKPARTICIPATION_AGREEMENT" PRIMARY KEY ("PA_ID")
                                                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."PERSONPROXY" ADD CONSTRAINT "PKPERSONPROXY" PRIMARY KEY ("PID")
                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."PREPOST_REQUEST" ADD CONSTRAINT "PKPREPOST_REQUEST" PRIMARY KEY ("PPR_BATCH_ID")
                                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."REC_IDS" ADD CONSTRAINT "PKREC_IDS" PRIMARY KEY ("REC_NAME")
                                                           *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."RELATIONSHIP" ADD CONSTRAINT "PKRELATIONSHIP" PRIMARY KEY ("RELATIONSHIPCODE")
                                                                     *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."REQUEST_CALC_PARTICIPANT" ADD CONSTRAINT "PKREQUEST_CALC_PARTICIPANT" PRIMARY KEY ("REQ_ID")
                                                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."REQUEST_DISTRIBUTION" ADD CONSTRAINT "PKREQUEST_DISTRIBUTION" PRIMARY KEY ("REQDIST_REQ_ID")
                                                                                     *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."REQUEST_NEAP_RESULTS" ADD CONSTRAINT "PKREQUEST_NEAP_RESULTS" PRIMARY KEY ("REQRESD_REQ_ID")
                                                                                     *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."ROUTINGNUMBER" ADD CONSTRAINT "PKROUTINGNUMBER" PRIMARY KEY ("PID")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."SUSPENSE_BATCH" ADD CONSTRAINT "PKSUSPENSE_BATCH" PRIMARY KEY ("SBAT_ID")
                                                                         *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."SUSPENSE_LOAD_IN_PROCESS" ADD CONSTRAINT "PKSUSPENSE_LOAD_IN_PROCESS" PRIMARY KEY ("SLIP_SBAT_ID")
                                                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."SUSPENSE_REC_IDS" ADD CONSTRAINT "PKSUSPENSE_REC_IDS" PRIMARY KEY ("SREC_TABLE_NAME")
                                                                             *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."SUSPENSE_VIOLATIONS" ADD CONSTRAINT "PKSUSPENSE_VIOLATIONS" PRIMARY KEY ("SV_VIOLATION_CODE")
                                                                                   *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."TAX_ID_NUMBER" ADD CONSTRAINT "PKTAX_ID_NUMBER" PRIMARY KEY ("TIN_BR_SSN")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."TOPICCODES" ADD CONSTRAINT "PKTOPICCODES" PRIMARY KEY ("TOPICCODE")
                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."FED_ID_LOOKUP" ADD CONSTRAINT "PKFED_ID_LOOKUP" PRIMARY KEY ("FL_CONTR_ROOT")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."MPR_HEADER" ADD CONSTRAINT "PKMPR_HEADER" PRIMARY KEY ("MPR_ID")
                                                                 *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."BENEFIT_BOARD_DISTR" ADD CONSTRAINT "EBB_ID_PK" PRIMARY KEY ("EBB_ID")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."LOCAL_UNION_DISTR" ADD CONSTRAINT "LOCAL_ID_PK" PRIMARY KEY ("LOCAL_ID")
                                                                       *
ERROR at line 1:
ORA-02260: table can have only one primary key


ALTER TABLE "EMERALITPRD"."NEAP_ACCT_BAL" ADD CONSTRAINT "NEAP_ACCT_BAL_PK" PRIMARY KEY ("NEAP_PART_SSN_KEY")
                                                                        *
ERROR at line 1:
ORA-02260: table can have only one primary key



[ 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