ora2pg 19 doesn't extract all objects mentioned in the TYPE

[buragaddapavan]

i was using ora2pg 18 and it works fine

now i started using ora2pg 19.1 and used same config file . Issue is, it exports only first two object types mentioned in config file

in my case , ora2pg 19 exports only table and partitions....

can u tell me why ora2pg 19 doesnt export all type objects ?

config file :

ORACLE_DSN dbi:Oracle:host=10-119-2-17.ebiz.verizon.com;sid=db12c;port=1521 ORACLE_USER bhmurari ORACLE_PWD welcome123 TYPE TABLE PARTITION SEQUENCE TRIGGER PROCEDURE PACKAGE SYNONYM VIEW GRANT FUNCTION TYPE MVIEW DBLINK DIRECTORY OUTPUT ora2pg_db12c_pgdb_ddl_output10.sql DATA_TYPE DATE:timestamp,LONG:text,LONG RAW:bytea,CLOB:text,NCLOB:text,BLOB:bytea,BFILE:bytea,RAW:bytea,UROWID:oid,ROWID:oid,FLOAT:double precision,DEC:decimal, DECIMAL:decimal,DOUBLE PRECISION:double precision,INT:numeric,INTEGER:numeric,REAL:real,SMALLINT:smallint,BINARY_FLOAT:double precision, BINARY_DOUBLE:double precision,TIMESTAMP:timestamp,XMLTYPE:xml,BINARY_INTEGER:integer,PLS_INTEGER:integer,TIMESTAMP WITH TIME ZONE:timestamp with time zone, TIMESTAMP WITH LOCAL TIME ZONE:timestamp with time zone OUTPUT_DIR /tmp STOP_ON_ERROR 0 SCHEMA PG_DB PACKAGE_AS_SCHEMA 1 FILE_PER_FKEYS 1
FILE_PER_CONSTRAINT 1 PREFIX_PARTITION 1 EXPORT_INVALID 1 FILE_PER_INDEX 1 COMPILE_SCHEMA 1 PG_DSN dbi:Pg:dbname=Onemsgdb;host=msgdb.ccpoyzezuqrd.us-east-1.rds.amazonaws.com;port=5430 PG_USER app PG_PWD welcome123 PG_SCHEMA pg_db

[buragaddapavan]

ora2pg o/p :

[2018-11-28 06:55:03] Ora2Pg version: 19.1 [2018-11-28 06:55:03] Trying to connect to database: dbi:Oracle:host=10-119-2-17.ebiz.verizon.com;sid=db12c;port=1521 DBD::Oracle::dr connect warning: ORA-28002: the password will expire within 7 days (DBD SUCCESS_WITH_INFO: OCISessionBegin) at /usr/local/lib64/perl5/DBI.pm line 677. [2018-11-28 06:55:03] Isolation level: SET TRANSACTION ISOLATION LEVEL READ COMMITTED [2018-11-28 06:55:03] Force Oracle to compile schema PG_DB before code extraction [2018-11-28 06:55:09] Looking forward functions declaration in schema PG_DB . [2018-11-28 06:55:09] Looking at package genfile_pkg... [2018-11-28 06:55:09] Looking at package REPORT01_PKG... [2018-11-28 06:55:09] Retrieving table information... [2018-11-28 06:56:57] [1] Scanning table ACCOUNTMDNINFO (0 rows)... [2018-11-28 06:56:57] [2] Scanning table ACCOUNTS_DTL (183507 rows)... [2018-11-28 06:56:57] [3] Scanning table ALRT_CATEGORY (27 rows)... [2018-11-28 06:56:57] [4] Scanning table ALRT_JOBDETAILS (0 rows)... [2018-11-28 06:56:57] [5] Scanning table ALRT_JOBRUNS (0 rows)... [2018-11-28 06:56:57] [6] Scanning table ALRT_JOBS (20 rows)... [2018-11-28 06:56:57] [7] Scanning table ALRT_SUBSCRIPTIONS (0 rows)... [2018-11-28 06:56:57] [8] Scanning table ALRT_USER_ROLES (4 rows)... [2018-11-28 06:56:57] [9] Scanning table AM_UIM_LETTER (1783510 rows)... [2018-11-28 06:56:57] [10] Scanning table AM_ZIP_MKT_MAP (31477 rows)... [2018-11-28 06:56:57] [11] Scanning table APO_DEENROLLMENT (1 rows)... [2018-11-28 06:56:57] [12] Scanning table APPID_BP_MAPPING (2 rows)... [2018-11-28 06:56:57] [13] Scanning table APPLICATION_ACCESS (3998 rows)... [2018-11-28 06:56:57] [14] Scanning table APPLICATION_ACCESS_BAK (0 rows)... [2018-11-28 06:56:57] [15] Scanning table BACKUP_ASSISTANT_PUSH_TEMP (0 rows)... [2018-11-28 06:56:57] [16] Scanning table BADEMAILS (6 rows)... [2018-11-28 06:56:57] [17] Scanning table BATCHEMAILSVC_ADDRESS (0 rows)... [2018-11-28 06:56:57] [18] Scanning table BATCHEMAILSVC_REQUEST (0 rows)... [2018-11-28 06:56:57] [19] Scanning table BATCHSMS_CUSTOMER_RESPONSES (149010 rows)... [2018-11-28 06:56:57] [20] Scanning table BATCHSMS_DELIVERY_RECEIPTS (3061 rows)... [2018-11-28 06:56:57] [21] Scanning table BATCHSMS_MESSAGES (398084 rows)... [2018-11-28 06:56:57] [22] Scanning table BATCHSMS_MSGS_12MNTS (0 rows)... [2018-11-28 06:56:57] [23] Scanning table BATCH_CPNI_ECPD_MYBUS_VISION (0 rows)... [2018-11-28 06:56:57] [24] Scanning table BATCH_CPNI_REALTIME (21030 rows)... [2018-11-28 06:56:57] [25] Scanning table BATCH_CPNI_SUMMARY (28 rows)... [2018-11-28 06:56:57] [26] Scanning table BATCH_DATA_LOAD (1 rows)... [2018-11-28 06:56:57] [27] Scanning table BATCH_FEED_SMS (6408 rows)... [2018-11-28 06:56:57] [28] Scanning table BATCH_MESSAGES_SUMMARY (0 rows)... [2018-11-28 06:56:57] [29] Scanning table BATCH_SUMMARY (5 rows)... [2018-11-28 06:56:57] [30] Scanning table BILL_READY_INDX (0 rows)... [2018-11-28 06:56:57] [31] Scanning table BPID_INFO (15 rows)... [2018-11-28 06:56:57] [32] Scanning table BP_TO_TEMPLATE_MAPPING (36 rows)... [2018-11-28 06:56:57] [33] Scanning table BS_BATCH_EMAIL_SYNCUP (0 rows)... [2018-11-28 06:56:57] [34] Scanning table BUSINESS_PROCESS (22 rows)... [2018-11-28 06:56:57] [35] Scanning table CAPO_AUDIT_LOGS (103796 rows)... [2018-11-28 06:56:57] [36] Scanning table CAPO_CC_EXPIRE_NOTIFICATION (12 rows)... [2018-11-28 06:56:57] [37] Scanning table CAPO_CHECK_PAYMENTS (4 rows)... [2018-11-28 06:56:57] [38] Scanning table CAPO_CREDITCARD_PAYMENTS (13200 rows)... [2018-11-28 06:56:57] [39] Scanning table CAPO_DECLINED_PAYMENTS (2 rows)... [2018-11-28 06:56:57] [40] Scanning table CAPO_FUTURE_DATED_PAYMENTS (105 rows)... [2018-11-28 06:56:57] [41] Scanning table CAPO_POSTDATED_CHECK_PAYMENTS (2 rows)... [2018-11-28 06:56:57] [42] Scanning table CCC_APP_ACCESS (299 rows)... [2018-11-28 06:56:57] [43] Scanning table CCC_APP_ACCESS_CUST_VALIDATE (272 rows)... [2018-11-28 06:56:57] [44] Scanning table CCC_APP_ACCESS_ORDER_VALIDATE (272 rows)... [2018-11-28 06:56:57] [45] Scanning table CCC_BUSINESS_RULES (1921 rows)... [2018-11-28 06:56:57] [46] Scanning table CCC_BUSINESS_RULES1 (316 rows)... [2018-11-28 06:56:57] [47] Scanning table CCC_CLIENT_AUDIT (438107 rows)... [2018-11-28 06:56:57] [48] Scanning table CCC_CLIENT_AUDIT_NEW (236130 rows)... [2018-11-28 06:56:57] [49] Scanning table CCC_CLIENT_AUDIT_OLD (9577145 rows)... [2018-11-28 06:56:57] [50] Scanning table CCC_CLIENT_AUDIT_REQ_XML (2207238 rows)... [2018-11-28 06:56:58] [51] Scanning table CCC_CLIENT_AUDIT_REQ_XML_BKP (2114807 rows)... [2018-11-28 06:56:58] [52] Scanning table CCC_CLIENT_AUDIT_REQ_XML_OLD (1217347 rows)... [2018-11-28 06:56:58] [53] Scanning table CCC_DELIVERY_RECEIPTS (2856991 rows)... [2018-11-28 06:56:58] [54] Scanning table CCC_DEL_RCPTS_RET (21154202 rows)... [2018-11-28 06:56:58] [55] Scanning table CCC_DM_STATUS (1621450 rows)... [2018-11-28 06:56:58] [56] Scanning table CCC_DUP (0 rows)... [2018-11-28 06:56:58] [57] Scanning table CCC_MESSAGES (6713698 rows)... [2018-11-28 06:56:58] [58] Scanning table CCESDM_ERECYCLE_BATCH (6 rows)... [2018-11-28 06:56:58] [59] Scanning table CCESDM_POSSHIPPINGREQUEST (173673 rows)... [2018-11-28 06:56:58] [60] Scanning table CCES_ALLTEL_ACCOUNTS (146438 rows)... [2018-11-28 06:56:58] [61] Scanning table CCES_ALLTEL_VISION_ACCOUNTS (143466 rows)... [2018-11-28 06:56:58] [62] Scanning table CCES_ALP_ACCTLVL_CONF_LTRS_ST (0 rows)... [2018-11-28 06:56:59] [63] Scanning table CCES_ALP_CONFRM_LTR_NEW_SUMM (0 rows)... [2018-11-28 06:56:59] [64] Scanning table CCES_APPL_REQ_MAPPINGS (0 rows)... [2018-11-28 06:56:59] [65] Scanning table CCES_AREA_CONTACTS (8 rows)... [2018-11-28 06:56:59] [66] Scanning table CCES_AUDIT_CTRL (23 rows)... [2018-11-28 06:56:59] [67] Scanning table CCES_AUDIT_LOGS (1204662 rows)... [2018-11-28 06:56:59] [68] Scanning table CCES_BILL_SHOCK_B2B_FEED (23 rows)... [2018-11-28 06:56:59] [69] Scanning table CCES_CHANGECONTROL_INFO (0 rows)... [2018-11-28 06:56:59] [70] Scanning table CCES_CLNR_SIMP_REQUEST (269 rows)... [2018-11-28 06:56:59] [71] Scanning table CCES_COMMON_BATCH_STATS (849550 rows)... [2018-11-28 06:56:59] [72] Scanning table CCES_CONFACTLUL_FATAL_ERRORS (0 rows)... [2018-11-28 06:56:59] [73] Scanning table CCES_CONFIRM_LETTERS (0 rows)... [2018-11-28 06:56:59] [74] Scanning table CCES_CONFIRM_LETTERS_ST_1 (1 rows)... [2018-11-28 06:56:59] [75] Scanning table CCES_CONFIRM_LETTERS_SUMM (0 rows)... [2018-11-28 06:56:59] [76] Scanning table CCES_CONFIRM_LETTERS_WFM (0 rows)... [2018-11-28 06:56:59] [77] Scanning table CCES_CONFIRM_LTRS_ACCT_DATA (0 rows)... [2018-11-28 06:56:59] [78] Scanning table CCES_CONFIRM_LTRS_TGR_DTLS (0 rows)... [2018-11-28 06:56:59] [79] Scanning table CCES_CONFLTRS_TGR_ACCT_DTLS (0 rows)... [2018-11-28 06:56:59] [80] Scanning table CCES_DATA_METER_REQUESTS (2 rows)... [2018-11-28 06:56:59] [81] Scanning table CCES_DM_BUSINESS_RULES (0 rows)... [2018-11-28 06:56:59] [82] Scanning table CCES_DM_MAPPING (1017 rows)... [2018-11-28 06:56:59] [83] Scanning table CCES_DNC_DETAILS (0 rows)... [2018-11-28 06:56:59] [84] Scanning table CCES_DWH_TRADEIN_GIFTCARD (23073 rows)... [2018-11-28 06:56:59] [85] Scanning table CCES_ECPNI_REQUESTS (362 rows)... [2018-11-28 06:56:59] [86] Scanning table CCES_ECPNI_REQUESTS_B (999 rows)... [2018-11-28 06:56:59] [87] Scanning table CCES_ECPNI_REQUESTS_NEW (0 rows)... [2018-11-28 06:56:59] [88] Scanning table CCES_EDGE_REJECT_EMAILS (5 rows)... [2018-11-28 06:56:59] [89] Scanning table CCES_EMAIL_CONFIRMATIONS (0 rows)... [2018-11-28 06:56:59] [90] Scanning table CCES_EMAIL_CONFIRM_SUMM (0 rows)... [2018-11-28 06:56:59] [91] Scanning table CCES_EMAIL_FEATURE (36 rows)... [2018-11-28 06:56:59] [92] Scanning table CCES_EMAIL_FEATURE_SUMM (98 rows)... [2018-11-28 06:56:59] [93] Scanning table CCES_EMAIL_UPDATES_BUS_RULES (0 rows)... [2018-11-28 06:56:59] [94] Scanning table CCES_EMAP_FTRE_OPTSRV_PRC_MAPO (94622 rows)... [2018-11-28 06:56:59] [95] Scanning table CCES_EMAP_FTRE_OPT_PRC_MAP12 (12327 rows)... [2018-11-28 06:56:59] [96] Scanning table CCES_EMAP_FT_OPT_PRC_M_1021 (248 rows)... [2018-11-28 06:56:59] [97] Scanning table CCES_EMAP_MGT1 (86 rows)... [2018-11-28 06:56:59] [98] Scanning table CCES_EMAP_MGT_1229 (169 rows)... [2018-11-28 06:56:59] [99] Scanning table CCES_EMAP_MGT_CLOB_OLD (1 rows)... [2018-11-28 06:56:59] [100] Scanning table CCES_EMAP_MGT_OLD (301 rows)... [2018-11-28 06:56:59] [101] Scanning table CCES_EMAP_MGT_PROD (1 rows)... [2018-11-28 06:56:59] [102] Scanning table CCES_EMAP_MGT_STAG (72 rows)... [2018-11-28 06:56:59] [103] Scanning table CCES_EMAP_MGT_STAGING_OLD (0 rows)... [2018-11-28 06:56:59] [104] Scanning table CCES_EMAP_MGT_TST (80 rows)... [2018-11-28 06:56:59] [105] Scanning table CCES_FILE_DTLS (0 rows)... [2018-11-28 06:56:59] [106] Scanning table CCES_FIOS_BUNDLE_MESSAGES (277 rows)... [2018-11-28 06:56:59] [107] Scanning table CCES_FTRE_OPTSRV_FOOTNOTES_O (293 rows)... [2018-11-28 06:56:59] [108] Scanning table CCES_FTRE_OPTSRV_FOOT_1021 (16 rows)... [2018-11-28 06:56:59] [109] Scanning table CCES_FTRE_OPTSRV_FTNTS12 (106 rows)... [2018-11-28 06:56:59] [110] Scanning table CCES_GLOBAL_EMAP_UPDATES_OLD (6 rows)... [2018-11-28 06:56:59] [111] Scanning table CCES_GLOBAL_OPTIN_REQUEST (611 rows)... [2018-11-28 06:56:59] [112] Scanning table CCES_GLOBAL_OPTIN_WHITELIST (64 rows)... [2018-11-28 06:56:59] [113] Scanning table CCES_HPC_REQUESTS (98 rows)... [2018-11-28 06:56:59] [114] Scanning table CCES_INHOUSE_MASTER_DATA_STG (244 rows)... [2018-11-28 06:56:59] [115] Scanning table CCES_IUBE_NETWORK_MGMT (5 rows)... [2018-11-28 06:56:59] [116] Scanning table CCES_KRONOS_EMAIL_DTL_MESSAGES (5894 rows)... [2018-11-28 06:56:59] [117] Scanning table CCES_KRONOS_EMAIL_MESSAGES (1436 rows)... [2018-11-28 06:56:59] [118] Scanning table CCES_KRONOS_SMS_MESSAGES (15 rows)... [2018-11-28 06:56:59] [119] Scanning table CCES_LDAP_IDC_SDC_SYNC_UP (0 rows)... [2018-11-28 06:56:59] [120] Scanning table CCES_MHEALTH_STMT_REV_ERR_DATA (141 rows)... [2018-11-28 06:56:59] [121] Scanning table CCES_MLTRY_SPND (884 rows)... [2018-11-28 06:56:59] [122] Scanning table CCES_MOBILE_PAYMENTS (6 rows)... [2018-11-28 06:56:59] [123] Scanning table CCES_MVM_MESSAGES (6 rows)... [2018-11-28 06:56:59] [124] Scanning table CCES_NEW_DATA (43741402 rows)... [2018-11-28 06:56:59] [125] Scanning table CCES_OLD_DATA (46374951 rows)... [2018-11-28 06:56:59] [126] Scanning table CCES_PREPAY_BUNDLE_DETAILS (61 rows)... [2018-11-28 06:56:59] [127] Scanning table CCES_PRODSUPPTOOL_CONSTANTS (14 rows)... [2018-11-28 06:56:59] [128] Scanning table CCES_PROD_CC_INFO (0 rows)... [2018-11-28 06:56:59] [129] Scanning table CCES_REAL_TIME_MDN_DISCONNECT (59758 rows)... [2018-11-28 06:56:59] [130] Scanning table CCES_RESOURCE_CENTRAL_FEED (306 rows)... [2018-11-28 06:56:59] [131] Scanning table CCES_RE_ACT_NOTIFICATION (30521 rows)... [2018-11-28 06:56:59] [132] Scanning table CCES_RIM_3G_PRICE_PLAN (2 rows)... [2018-11-28 06:56:59] [133] Scanning table CCES_RTR_ALLOWANCE_MSGS (1195 rows)... [2018-11-28 06:56:59] [134] Scanning table CCES_RTR_DEVICE_DETAILS (53 rows)... [2018-11-28 06:56:59] [135] Scanning table CCES_SECURE_EBILL_MESSAGES (4814 rows)... [2018-11-28 06:56:59] [136] Scanning table CCES_SMB_AUDIT_LOGS (1388 rows)... [2018-11-28 06:56:59] [137] Scanning table CCES_SMB_ECPD_DATA (2055 rows)... [2018-11-28 06:56:59] [138] Scanning table CCES_SPLIT_BILLING_REQUESTS (592 rows)... [2018-11-28 06:56:59] [139] Scanning table CCES_SPRBNDL_MOC_NOTIFICATIONS (0 rows)... [2018-11-28 06:56:59] [140] Scanning table CCES_SUMMARY (24 rows)... [2018-11-28 06:56:59] [141] Scanning table CCES_TANDC_EMAIL (18911 rows)... [2018-11-28 06:56:59] [142] Scanning table CCES_TERMS_AND_COND_REQUESTS (27210 rows)... [2018-11-28 06:56:59] [143] Scanning table CCES_TERMS_AND_COND_REQUESTS_B (13 rows)... [2018-11-28 06:56:59] [144] Scanning table CCES_TERMS_AND_COND_REQUESTS_S (0 rows)... [2018-11-28 06:56:59] [145] Scanning table CCES_TERMS_AND_COND_REQ_AOL (6752 rows)... [2018-11-28 06:56:59] [146] Scanning table CCES_TERMS_AND_COND_REQ_DVS (60352 rows)... [2018-11-28 06:56:59] [147] Scanning table CCES_TERMS_AND_COND_REQ_DVS2 (59867 rows)... [2018-11-28 06:56:59] [148] Scanning table CCES_TERMS_AND_COND_REQ_VISION (61 rows)... [2018-11-28 06:56:59] [149] Scanning table CCES_TNC_REQUESTS_ERR_LOG (0 rows)... [2018-11-28 06:56:59] [150] Scanning table CCES_TRAN_LOGS (0 rows)... [2018-11-28 06:56:59] [151] Scanning table CCES_UC_REMINDER (8807 rows)... [2018-11-28 06:56:59] [152] Scanning table CCES_USER_TRACKING (1835 rows)... [2018-11-28 06:56:59] [153] Scanning table CCES_VZNAVIG_CAMPAIGN (3 rows)... [2018-11-28 06:56:59] [154] Scanning table CCES_WELCOME_CLOUD_BATCH (77 rows)... [2018-11-28 06:56:59] [155] Scanning table CCMIDDLEWARE_CRM10DEV_011108_J (1402 rows)... [2018-11-28 06:56:59] [156] Scanning table CCMIDDLEWARE_CRM10DEV_093008_J (1421 rows)... [2018-11-28 06:56:59] [157] Scanning table CLNR_PHOTO_DETAILS (28 rows)... [2018-11-28 06:56:59] [158] Scanning table CMP3$217345 (47532 rows)... [2018-11-28 06:56:59] [159] Scanning table COMM_CONFIG (30 rows)... [2018-11-28 06:56:59] [160] Scanning table COMM_REQUEST_AUDIT (1 rows)... [2018-11-28 06:56:59] [161] Scanning table COMM_REQ_REPLAY_MAP (0 rows)... [2018-11-28 06:56:59] [162] Scanning table CONSUMER_FALLOUT (450011 rows)... [2018-11-28 06:56:59] [163] Scanning table CORRUPTED_ACCOUNTS (0 rows)... [2018-11-28 06:56:59] [164] Scanning table CPNI_BACKEND_AUDIT (13452 rows)... [2018-11-28 06:56:59] [165] Scanning table CPNI_BIANNUAL_PROCESSD_OUTPUT (17 rows)... [2018-11-28 06:56:59] [166] Scanning table CPNI_CLIENT_AUDIT (9103 rows)... [2018-11-28 06:56:59] [167] Scanning table CREDIT_CARD_EXPIRATION (171892 rows)... [2018-11-28 06:56:59] [168] Scanning table CREDIT_CARD_EXPIRATION_COPY (52820 rows)... [2018-11-28 06:56:59] [169] Scanning table CREDIT_CARD_EXPIRATION_OLD (12 rows)... [2018-11-28 06:56:59] [170] Scanning table CRM_BACKEND_AUDIT (101 rows)... [2018-11-28 06:56:59] [171] Scanning table CRM_CAMPAIGN_INFO (0 rows)... [2018-11-28 06:56:59] [172] Scanning table CRM_CLIENT_AUDIT (102 rows)... [2018-11-28 06:56:59] [173] Scanning table CRM_MT_SMSMESSAGES (0 rows)... [2018-11-28 06:56:59] [174] Scanning table CRONJOBS_CHECK (6451 rows)... [2018-11-28 06:56:59] [175] Scanning table CRON_JOBS (0 rows)... [2018-11-28 06:56:59] [176] Scanning table CROSS_REFERENCE_CONTACTS (201 rows)... [2018-11-28 06:56:59] [177] Scanning table CUSTUSAGEALERTAPP_PROPERTIES (314 rows)... [2018-11-28 06:56:59] [178] Scanning table DATAMETER_DELIVERY_RECEIPTS (655 rows)... [2018-11-28 06:56:59] [179] Scanning table DATAMETER_MESSAGES (1226 rows)... [2018-11-28 06:56:59] [180] Scanning table DATAPOWER_AUTHENTICATION (2 rows)... [2018-11-28 06:56:59] [181] Scanning table DATAPOWER_DATA_VALIDATION (3 rows)... [2018-11-28 06:56:59] [182] Scanning table DATA_LOAD_DETAILS (1108 rows)... [2018-11-28 06:56:59] [183] Scanning table DATA_METER_REALTIME_REQUESTS (599 rows)... [2018-11-28 06:56:59] [184] Scanning table DATA_USAGE_ALERTS (4 rows)... [2018-11-28 06:57:00] [185] Scanning table DECLINE_PAYMENTS_SMS (669 rows)... [2018-11-28 06:57:00] [186] Scanning table DELIVERY_ACK_ROUTING (201 rows)... [2018-11-28 06:57:00] [187] Scanning table DEP (3 rows)... [2018-11-28 06:57:00] [188] Scanning table DEPT (1 rows)... [2018-11-28 06:57:00] [189] Scanning table DISCONNECTED_MTNS (214 rows)... [2018-11-28 06:57:00] [190] Scanning table DISCONNECTED_MTNS_DETAILS (7772 rows)... [2018-11-28 06:57:00] [191] Scanning table DISCONNECTED_MTNS_DETAILS_ORIG (1227602 rows)... [2018-11-28 06:57:00] [192] Scanning table DMDFEACHK_BACKEND_AUDIT (884 rows)... [2018-11-28 06:57:00] [193] Scanning table DMDFEACHK_BACKEND_AUDIT_OLD (884 rows)... [2018-11-28 06:57:00] [194] Scanning table DMDFEACHK_CLIENT_AUDIT (947 rows)... [2018-11-28 06:57:00] [195] Scanning table DMDFEACHK_CLIENT_AUDIT_OLD (947 rows)... [2018-11-28 06:57:00] [196] Scanning table DMD_PRODUCTS_LIST (0 rows)... [2018-11-28 06:57:00] [197] Scanning table DM_APPSERVER (4 rows)... [2018-11-28 06:57:00] [198] Scanning table DM_APPSERVER_TO_PROP (32 rows)... [2018-11-28 06:57:00] [199] Scanning table DM_PROPERTY_INFO (17 rows)... [2018-11-28 06:57:00] [200] Scanning table DNC_CLEANUP_DETAILS (0 rows)... [2018-11-28 06:57:00] [201] Scanning table DNC_CUST_RECEIPTS (34 rows)... [2018-11-28 06:57:00] [202] Scanning table ECS_ACC_MDN_CLEANUP (0 rows)... [2018-11-28 06:57:00] [203] Scanning table ECS_BILL_READY_EAST (0 rows)... [2018-11-28 06:57:00] [204] Scanning table ECS_BILL_READY_NOTIFICATIONS (70752 rows)... [2018-11-28 06:57:00] [205] Scanning table ECS_BILL_READY_NOTIFIC_CONV (0 rows)... [2018-11-28 06:57:00] [206] Scanning table ECS_BILL_READY_TMP (315418 rows)... [2018-11-28 06:57:00] [207] Scanning table ECS_BILL_READY_TMP_ODC (0 rows)... [2018-11-28 06:57:00] [208] Scanning table ECS_BILL_READY_TMP_SDC (0 rows)... [2018-11-28 06:57:00] [209] Scanning table ECS_BILL_READY_WEST (0 rows)... [2018-11-28 06:57:00] [210] Scanning table ECS_BP_DOCID_MAPPING (2899 rows)... [2018-11-28 06:57:00] [211] Scanning table ECS_FAX_ATTACH (130 rows)... [2018-11-28 06:57:00] [212] Scanning table ECS_FAX_REQUEST (123 rows)... [2018-11-28 06:57:00] [213] Scanning table ECS_I1Y1 (0 rows)... [2018-11-28 06:57:00] [214] Scanning table ECS_ONDEMANDEMAIL_NOTIFICATION (22525 rows)... [2018-11-28 06:57:00] [215] Scanning table ECS_ONDEMANDEMAIL_NOT_TMP (625 rows)... [2018-11-28 06:57:00] [216] Scanning table ECS_OPTOUT (1 rows)... [2018-11-28 06:57:00] [217] Scanning table ECS_PAYMENT_NOTIFICATIONS (4 rows)... [2018-11-28 06:57:00] [218] Scanning table ECS_REPORTS_SUMMARY (230564 rows)... [2018-11-28 06:57:00] [219] Scanning table ECS_TEMPLATES (2441 rows)... [2018-11-28 06:57:00] [220] Scanning table ECS_TEMPLATES_0519 (379 rows)... [2018-11-28 06:57:00] [221] Scanning table ECS_TEMPLATES_09242010 (958 rows)... [2018-11-28 06:57:00] [222] Scanning table ECS_TEMPLATES_1 (0 rows)... [2018-11-28 06:57:00] [223] Scanning table ECS_TEMPLATES_BKUP (977 rows)... [2018-11-28 06:57:00] [224] Scanning table ECS_TEMPLATES_MASTER (371 rows)... [2018-11-28 06:57:00] [225] Scanning table ECS_TEMPLATES_PROD (371 rows)... [2018-11-28 06:57:00] [226] Scanning table ECS_TEMPLATE_ROLE (58 rows)... [2018-11-28 06:57:00] [227] Scanning table ECS_TEMPLATE_STAGING (1 rows)... [2018-11-28 06:57:00] [228] Scanning table ECS_TICKETS (60818 rows)... [2018-11-28 06:57:00] [229] Scanning table ECS_TICKETS_TEST (1 rows)... [2018-11-28 06:57:00] [230] Scanning table EDUCATIONAL_PROMO_CODES (24916 rows)... [2018-11-28 06:57:00] [231] Scanning table EMAILBOX_PURGING (4 rows)... [2018-11-28 06:57:00] [232] Scanning table EMAILSVC_ADDRESS (4580952 rows)... [2018-11-28 06:57:00] [233] Scanning table EMAILSVC_REQUEST (3320743 rows)... [2018-11-28 06:57:00] [234] Scanning table EMAILUNSUBSCRIBE_LOG (1817 rows)... [2018-11-28 06:57:00] [235] Scanning table EMAILVALIDATION_LDAP (6 rows)... [2018-11-28 06:57:00] [236] Scanning table EMAILVALIDATION_VISION (20 rows)... [2018-11-28 06:57:00] [237] Scanning table EMAIL_LAYOUTS (17 rows)... [2018-11-28 06:57:00] [238] Scanning table EMAIL_OPENED (0 rows)... [2018-11-28 06:57:00] [239] Scanning table EMAIL_TEMPLATES (11 rows)... [2018-11-28 06:57:00] [240] Scanning table EMP (12 rows)... [2018-11-28 06:57:00] [241] Scanning table EMPGATEWAY_AUTH_APPLICATION (3 rows)... [2018-11-28 06:57:00] [242] Scanning table EMPLOYEE (0 rows)... [2018-11-28 06:57:00] [243] Scanning table EMPLOYEE_ALERTS_AUDIT_LOGS (2 rows)... [2018-11-28 06:57:00] [244] Scanning table EMPLOYEE_ALERTS_USER_GROUP (0 rows)... [2018-11-28 06:57:00] [245] Scanning table EMPLOYEE_ALERTS_USER_MASTER (1 rows)... [2018-11-28 06:57:00] [246] Scanning table EMPLOYEE_ALERTS_USER_TO_GROUP (2 rows)... [2018-11-28 06:57:00] [247] Scanning table EMP_ALERTS_CUST_LST_CONTACT (3 rows)... [2018-11-28 06:57:00] [248] Scanning table EMP_ALERTS_GRP_CUST_LST (2 rows)... [2018-11-28 06:57:00] [249] Scanning table EQUIPMENT_CHARGEBACK_FEED_SMS (5046 rows)... [2018-11-28 06:57:00] [250] Scanning table ERRORS (0 rows)... [2018-11-28 06:57:00] [251] Scanning table EVNT_HISTORY (29 rows)... [2018-11-28 06:57:00] [252] Scanning table EVNT_MONITORS (3 rows)... [2018-11-28 06:57:00] [253] Scanning table EVNT_SCOPE (2 rows)... [2018-11-28 06:57:00] [254] Scanning table FAILURE_EMAIL_ADDR (2 rows)... [2018-11-28 06:57:00] [255] Scanning table FF_CLEANUP_ACCTS_MDN (0 rows)... [2018-11-28 06:57:00] [256] Scanning table FF_CLEANUP_MDN_UPDATES (25076 rows)... [2018-11-28 06:57:00] [257] Scanning table GBL_WSMS_EXCEPTIONS (22 rows)... [2018-11-28 06:57:00] [258] Scanning table GBL_WSMS_RATES_AND_DIALINGINFO (237 rows)... [2018-11-28 06:57:00] [259] Scanning table GBL_WSMS_ROAMTIER (0 rows)... [2018-11-28 06:57:00] [260] Scanning table GBL_WSMS_SFO_LIST (0 rows)... [2018-11-28 06:57:00] [261] Scanning table GBL_WSMS_TRACK (49352598 rows)... [2018-11-28 06:57:00] [262] Scanning table GENERIC_SMALL_PROJECT_LOADS (9 rows)... [2018-11-28 06:57:00] [263] Scanning table GLOBAL_WSMS_COUNTRY (415 rows)... [2018-11-28 06:57:00] [264] Scanning table GLOBAL_WSMS_COUNTRY1 (415 rows)... [2018-11-28 06:57:00] [265] Scanning table GLOBAL_WSMS_DIALING (1913 rows)... [2018-11-28 06:57:00] [266] Scanning table GLOBAL_WSMS_DIALING1 (1912 rows)... [2018-11-28 06:57:00] [267] Scanning table GLOBAL_WSMS_RATES (3574 rows)... [2018-11-28 06:57:00] [268] Scanning table GLOBAL_WSMS_RATES1 (3570 rows)... [2018-11-28 06:57:00] [269] Scanning table GLOBAL_WSMS_XREF (273 rows)... [2018-11-28 06:57:00] [270] Scanning table INTERACTIVE_SMS_STATE (357267 rows)... [2018-11-28 06:57:00] [271] Scanning table ISMS_AUDIT_LOGS (238842 rows)... [2018-11-28 06:57:00] [272] Scanning table IVR_SELF_SERVICE_ALERTS (7 rows)... [2018-11-28 06:57:00] [273] Scanning table LDAPCUSTOMERRECORDS (72275 rows)... [2018-11-28 06:57:00] [274] Scanning table LDAP_ACCOUNTS (829791 rows)... [2018-11-28 06:57:00] [275] Scanning table LDAP_ACCOUNTS_MDN (17803672 rows)... [2018-11-28 06:57:00] [276] Scanning table LDAP_DATAWAREFEED (63792 rows)... [2018-11-28 06:57:00] [277] Scanning table LDAP_MIGRATE_ACCOUNTS (1430853 rows)... [2018-11-28 06:57:00] [278] Scanning table LETTERVIEWERACCESS (64 rows)... [2018-11-28 06:57:00] [279] Scanning table LETTER_MGT_AUDIT_LOGS_O (0 rows)... [2018-11-28 06:57:00] [280] Scanning table LETTER_PROCESS_CONFIG (8 rows)... [2018-11-28 06:57:00] [281] Scanning table LONG_CODE_MAPPING (12 rows)... [2018-11-28 06:57:00] [282] Scanning table LV_PROPS (0 rows)... [2018-11-28 06:57:00] [283] Scanning table MASTER_DATA_REPOSITORY (125896 rows)... [2018-11-28 06:57:00] [284] Scanning table MASTER_SERVERS_REPOSITORY (528 rows)... [2018-11-28 06:57:00] [285] Scanning table MATCHING_MDN_ACCT (0 rows)... [2018-11-28 06:57:00] [286] Scanning table MCC_CUSTOMER_RESPONSES (1353 rows)... [2018-11-28 06:57:00] [287] Scanning table MCC_DELIVERY_RECEIPTS (35 rows)... [2018-11-28 06:57:00] [288] Scanning table MCC_MESSAGES (184 rows)... [2018-11-28 06:57:00] [289] Scanning table MDN_PID_ITEMID_MAPPING (0 rows)... [2018-11-28 06:57:00] [290] Scanning table MESSAGES_SUMMARY (0 rows)... [2018-11-28 06:57:00] [291] Scanning table MMG_ALERT_CONFIG (0 rows)... [2018-11-28 06:57:00] [292] Scanning table MMG_AUDIT_LOGS (5193498 rows)... [2018-11-28 06:57:00] [293] Scanning table MMG_CALLBACK_OVERRIDE (29 rows)... [2018-11-28 06:57:00] [294] Scanning table MMG_ERROR_LOGS (4255557 rows)... [2018-11-28 06:57:00] [295] Scanning table MMG_SUMMARY_INFO (0 rows)... [2018-11-28 06:57:00] [296] Scanning table MMG_TRANSACTION_DATA (4326519 rows)... [2018-11-28 06:57:00] [297] Scanning table MMG_TRANSACTION_GATEWAY_ID (177628 rows)... [2018-11-28 06:57:00] [298] Scanning table MMS_CONTENT (74 rows)... [2018-11-28 06:57:00] [299] Scanning table MMS_CONTENT_MAPPINGS (1 rows)... [2018-11-28 06:57:00] [300] Scanning table MMS_CONTENT_TYPE (0 rows)... [2018-11-28 06:57:00] [301] Scanning table MMS_DELIVERY_REPORTS (90 rows)... [2018-11-28 06:57:00] [302] Scanning table MMS_DELIVERY_REPORTS_SAT (499 rows)... [2018-11-28 06:57:00] [303] Scanning table MMS_MESSAGES (33 rows)... [2018-11-28 06:57:00] [304] Scanning table MMS_MO (24 rows)... [2018-11-28 06:57:01] [305] Scanning table MQ_ALERT_CONFIG (0 rows)... [2018-11-28 06:57:01] [306] Scanning table MQ_ALERT_RECORDS (0 rows)... [2018-11-28 06:57:01] [307] Scanning table MR_DATA_SMS_STATS (0 rows)... [2018-11-28 06:57:01] [308] Scanning table MR_LOC_SMS_STATS (0 rows)... [2018-11-28 06:57:01] [309] Scanning table MSG_AUDIT_LOGS (1389 rows)... [2018-11-28 06:57:01] [310] Scanning table MSG_AUDIT_LOGS_0818 (17578 rows)... [2018-11-28 06:57:01] [311] Scanning table MSG_CNT_REQ_FOLDER_MAPPINGS (0 rows)... [2018-11-28 06:57:01] [312] Scanning table MSG_LOADTEST_MTN (4341467 rows)... [2018-11-28 06:57:01] [313] Scanning table MTAS_ESB_TRANSACTION (6320 rows)... [2018-11-28 06:57:01] [314] Scanning table MTAS_TRANS (12828 rows)... [2018-11-28 06:57:01] [315] Scanning table MTAS_TRANS_BKUP (4329 rows)... [2018-11-28 06:57:01] [316] Scanning table MTN_CROSS_REFERENCE (0 rows)... [2018-11-28 06:57:01] [317] Scanning table MYACCTSMS_MESSAGES_ORIG (0 rows)... [2018-11-28 06:57:01] [318] Scanning table MYACCTSMS_RESPONSES (2808 rows)... [2018-11-28 06:57:01] [319] Scanning table MY_BIZ_SAC_NOTIF (3838 rows)... [2018-11-28 06:57:01] [320] Scanning table NDR_DATA_ERROR_LOG (1383198 rows)... [2018-11-28 06:57:01] [321] Scanning table NOTIFICATION_BLOCKED_ACCTS (1411 rows)... [2018-11-28 06:57:01] [322] Scanning table NOTIFICATION_SEQUENCE (0 rows)... [2018-11-28 06:57:01] [323] Scanning table OMSG_ALERT_AUDIT (703584 rows)... [2018-11-28 06:57:01] [324] Scanning table OM_ACTIVATION_AUDIT (1252917 rows)... [2018-11-28 06:57:01] [325] Scanning table OM_ERROR_AUDIT (7179 rows)... [2018-11-28 06:57:01] [326] Scanning table ONDEMAND_SMS (0 rows)... [2018-11-28 06:57:01] [327] Scanning table ONDEMAND_SMS_MSG_TEMPLATES (0 rows)... [2018-11-28 06:57:01] [328] Scanning table ONETIME_PAYMENTS (0 rows)... [2018-11-28 06:57:01] [329] Scanning table OPERATIONS_FLEX (0 rows)... [2018-11-28 06:57:01] [330] Scanning table ORDER_DETAILS (0 rows)... [2018-11-28 06:57:01] [331] Scanning table PAGE_MASTER (0 rows)... [2018-11-28 06:57:01] [332] Scanning table PAYMENT_AUDIT_LOGS (0 rows)... [2018-11-28 06:57:01] [333] Scanning table PC_AUDIT_ERROR_TRACE (1071466 rows)... [2018-11-28 06:57:01] [334] Scanning table PC_AUDIT_NOTIFICATION (111323 rows)... [2018-11-28 06:57:01] [335] Scanning table PC_AUDIT_REQUEST (5084693 rows)... [2018-11-28 06:57:01] [336] Scanning table PC_AUDIT_STATUS_MASTER (27 rows)... [2018-11-28 06:57:01] [337] Scanning table PC_CLEANUP_DISC_REASSIGN_MDNS (0 rows)... [2018-11-28 06:57:01] [338] Scanning table PID_ITEMID_MAPPING (137 rows)... [2018-11-28 06:57:01] [339] Scanning table PLSQL_PROFILER_DATA (102 rows)... [2018-11-28 06:57:01] [340] Scanning table PLSQL_PROFILER_RUNS (2 rows)... [2018-11-28 06:57:01] [341] Scanning table PLSQL_PROFILER_UNITS (4 rows)... [2018-11-28 06:57:01] [342] Scanning table POUND_MESSAGES (231484 rows)... [2018-11-28 06:57:01] [343] Scanning table POUND_REQ_STATUS (0 rows)... [2018-11-28 06:57:01] [344] Scanning table PRECISION_AUDIT_INFORMATION (450 rows)... [2018-11-28 06:57:01] [345] Scanning table PREPAY_CUST_RCPT_AUDIT_LOGS (0 rows)... [2018-11-28 06:57:01] [346] Scanning table PREPAY_PAYDETAILS (14 rows)... [2018-11-28 06:57:01] [347] Scanning table PREPAY_PROMOTIONS (36 rows)... [2018-11-28 06:57:01] [348] Scanning table PRICE_PLAN_SMS (23 rows)... [2018-11-28 06:57:01] [349] Scanning table PRLUPDATE_TRANSACTION (0 rows)... [2018-11-28 06:57:01] [350] Scanning table PROBLEM_LOG_DETAILS (87 rows)... [2018-11-28 06:57:01] [351] Scanning table PRODUCTION_TEST_EMAILS (383 rows)... [2018-11-28 06:57:01] [352] Scanning table PRODUCTION_TEST_MTNS (3078 rows)... [2018-11-28 06:57:01] [353] Scanning table QA_SIGN_OFF (5 rows)... [2018-11-28 06:57:01] [354] Scanning table QRTZ_BLOB_TRIGGERS (0 rows)... [2018-11-28 06:57:01] [355] Scanning table QRTZ_CALENDARS (0 rows)... [2018-11-28 06:57:01] [356] Scanning table QRTZ_CRON_TRIGGERS (0 rows)... [2018-11-28 06:57:01] [357] Scanning table QRTZ_FIRED_TRIGGERS (0 rows)... [2018-11-28 06:57:01] [358] Scanning table QRTZ_JOB_DETAILS (0 rows)... [2018-11-28 06:57:01] [359] Scanning table QRTZ_JOB_LISTENERS (0 rows)... [2018-11-28 06:57:01] [360] Scanning table QRTZ_LOCKS (0 rows)... [2018-11-28 06:57:01] [361] Scanning table QRTZ_PAUSED_TRIGGER_GRPS (0 rows)... [2018-11-28 06:57:01] [362] Scanning table QRTZ_SCHEDULER_STATE (0 rows)... [2018-11-28 06:57:01] [363] Scanning table QRTZ_SIMPLE_TRIGGERS (0 rows)... [2018-11-28 06:57:01] [364] Scanning table QRTZ_SIMPROP_TRIGGERS (0 rows)... [2018-11-28 06:57:01] [365] Scanning table QRTZ_TRIGGERS (0 rows)... [2018-11-28 06:57:01] [366] Scanning table QRTZ_TRIGGER_LISTENERS (0 rows)... [2018-11-28 06:57:01] [367] Scanning table QUEUE_BACKUP (0 rows)... [2018-11-28 06:57:01] [368] Scanning table REALTIME_DATA_USAGE_ALERTS (8 rows)... [2018-11-28 06:57:01] [369] Scanning table REF_PREFERENCE_TYPE (12 rows)... [2018-11-28 06:57:01] [370] Scanning table REQUEST_MSG_MAP (0 rows)... [2018-11-28 06:57:01] [371] Scanning table REVERSE_CROSS_REFERENCES (60 rows)... [2018-11-28 06:57:01] [372] Scanning table RIM_3G_PRICE_PLANS_E (34 rows)... [2018-11-28 06:57:01] [373] Scanning table RIM_3G_PRICE_PLANS_E_OLD (40 rows)... [2018-11-28 06:57:01] [374] Scanning table RIM_3G_PRICE_PLANS_S (34 rows)... [2018-11-28 06:57:01] [375] Scanning table RIM_3G_PRICE_PLANS_S_OLD (30 rows)... [2018-11-28 06:57:01] [376] Scanning table ROLE_MASTER (4 rows)... [2018-11-28 06:57:01] [377] Scanning table ROLE_TO_PAGE_MAPPING (33 rows)... [2018-11-28 06:57:01] [378] Scanning table ROLE_TO_USER_MAPPING (379 rows)... [2018-11-28 06:57:01] [379] Scanning table RPTING_CATEGORIES (19 rows)... [2018-11-28 06:57:01] [380] Scanning table RTRSTATS (71348654 rows)... [2018-11-28 06:57:01] [381] Scanning table RTR_4G_TEST_NUMBERS (10 rows)... [2018-11-28 06:57:01] [382] Scanning table RTR_AUDIT_ALERTS_SENT (0 rows)... [2018-11-28 06:57:01] [383] Scanning table RTR_AUDIT_LOG (0 rows)... [2018-11-28 06:57:01] [384] Scanning table RTR_AUDIT_REQUEST (0 rows)... [2018-11-28 06:57:01] [385] Scanning table RTR_INC_ALERTS_AUDIT_LOGS_OLD (3771 rows)... [2018-11-28 06:57:01] [386] Scanning table RTR_MESSAGES (0 rows)... [2018-11-28 06:57:01] [387] Scanning table RTR_PROPERTIES (293 rows)... [2018-11-28 06:57:01] [388] Scanning table RTR_THLD_ALERTS_AUDIT_LOGS (26319 rows)... [2018-11-28 06:57:01] [389] Scanning table RTR_TRANSACTION (0 rows)... [2018-11-28 06:57:01] [390] Scanning table SCRIPT_DETAIL (64 rows)... [2018-11-28 06:57:01] [391] Scanning table SCRIPT_LOG_DETAIL (1157 rows)... [2018-11-28 06:57:01] [392] Scanning table SECURE_EBILL_AUDIT_LOGS (7118 rows)... [2018-11-28 06:57:01] [393] Scanning table SECURE_EBILL_REVO_REPORT (17 rows)... [2018-11-28 06:57:01] [394] Scanning table SEP_DEBUG (581559 rows)... [2018-11-28 06:57:01] [395] Scanning table SHED_STATE (2 rows)... [2018-11-28 06:57:01] [396] Scanning table SIGN_OFF (2 rows)... [2018-11-28 06:57:01] [397] Scanning table SMB_BACKEND_AUDIT (61 rows)... [2018-11-28 06:57:01] [398] Scanning table SMB_BLOB_TRIGGERS (0 rows)... [2018-11-28 06:57:01] [399] Scanning table SMB_CALENDARS (0 rows)... [2018-11-28 06:57:01] [400] Scanning table SMB_CRON_TRIGGERS (1 rows)... [2018-11-28 06:57:01] [401] Scanning table SMB_ERRORS (0 rows)... [2018-11-28 06:57:01] [402] Scanning table SMB_FIRED_TRIGGERS (0 rows)... [2018-11-28 06:57:01] [403] Scanning table SMB_FRONTEND_AUDIT (3948 rows)... [2018-11-28 06:57:01] [404] Scanning table SMB_FRONTEND_AUDIT_CORRID (0 rows)... [2018-11-28 06:57:01] [405] Scanning table SMB_FRONTEND_AUDIT_OLD (37683 rows)... [2018-11-28 06:57:01] [406] Scanning table SMB_JOB_DETAILS (1 rows)... [2018-11-28 06:57:01] [407] Scanning table SMB_JOB_LISTENERS (0 rows)... [2018-11-28 06:57:01] [408] Scanning table SMB_LOCKS (0 rows)... [2018-11-28 06:57:01] [409] Scanning table SMB_PAUSED_TRIGGER_GRPS (0 rows)... [2018-11-28 06:57:01] [410] Scanning table SMB_SCHEDULER_STATE (0 rows)... [2018-11-28 06:57:01] [411] Scanning table SMB_SIMPLE_TRIGGERS (0 rows)... [2018-11-28 06:57:01] [412] Scanning table SMB_TRIGGERS (1 rows)... [2018-11-28 06:57:01] [413] Scanning table SMB_TRIGGER_LISTENERS (0 rows)... [2018-11-28 06:57:01] [414] Scanning table SMS_ACK_MAPPINGS (8 rows)... [2018-11-28 06:57:01] [415] Scanning table SMS_ACK_RULES (5 rows)... [2018-11-28 06:57:01] [416] Scanning table SMS_CROSS_REFERENCES (5679 rows)... [2018-11-28 06:57:01] [417] Scanning table SMS_MO (124 rows)... [2018-11-28 06:57:01] [418] Scanning table SMS_RESPONSE_MAPPING (4 rows)... [2018-11-28 06:57:01] [419] Scanning table SMS_RESPONSE_MAPPINGS (269 rows)... [2018-11-28 06:57:01] [420] Scanning table SMS_RESPONSE_RULES (18 rows)... [2018-11-28 06:57:01] [421] Scanning table SMS_STATS (0 rows)... [2018-11-28 06:57:01] [422] Scanning table SMS_TEMPLATES (16 rows)... [2018-11-28 06:57:01] [423] Scanning table SPC_BACKEND_AUDIT (92075 rows)... [2018-11-28 06:57:01] [424] Scanning table SPC_CLIENT_AUDIT (92059 rows)... [2018-11-28 06:57:01] [425] Scanning table SQLN_EXPLAIN_PLAN (0 rows)... [2018-11-28 06:57:01] [426] Scanning table SQLN_PROF_ANB (24 rows)... [2018-11-28 06:57:01] [427] Scanning table SQLN_PROF_PROFILES (0 rows)... [2018-11-28 06:57:01] [428] Scanning table SQLN_PROF_RUNS (0 rows)... [2018-11-28 06:57:01] [429] Scanning table SQLN_PROF_SESS (10 rows)... [2018-11-28 06:57:01] [430] Scanning table SQLN_PROF_UNITS (0 rows)... [2018-11-28 06:57:01] [431] Scanning table SQLN_PROF_UNIT_HASH (4 rows)... [2018-11-28 06:57:01] [432] Scanning table SRVC_REGISTRY (1 rows)... [2018-11-28 06:57:01] [433] Scanning table STACKABLE_DATA_NOTIFICATIONS (21 rows)... [2018-11-28 06:57:01] [434] Scanning table SUMMARY_JOBS_LOG (5722 rows)... [2018-11-28 06:57:01] [435] Scanning table SUMM_AUDIT_LOGS (4804 rows)... [2018-11-28 06:57:01] [436] Scanning table SUMM_AUDIT_LOGS_DETAIL (91 rows)... [2018-11-28 06:57:01] [437] Scanning table SUMM_AUDIT_REQUEST (23 rows)... [2018-11-28 06:57:01] [438] Scanning table SUMM_CNFM_FATAL_ERRORS (13 rows)... [2018-11-28 06:57:01] [439] Scanning table SUMM_CNFM_LETTERS_SUMM (9 rows)... [2018-11-28 06:57:01] [440] Scanning table SUMM_CNFM_LETTERS_WFM (0 rows)... [2018-11-28 06:57:01] [441] Scanning table SUMM_CNFM_LTRS_TGR_DTLS (0 rows)... [2018-11-28 06:57:01] [442] Scanning table SUMM_CONFIRM_LETTERS (1323 rows)... [2018-11-28 06:57:01] [443] Scanning table SUMM_CPNI_PROCESSING (3472 rows)... [2018-11-28 06:57:01] [444] Scanning table SUMM_EMAIL (35145 rows)... [2018-11-28 06:57:01] [445] Scanning table SUMM_EMAIL_BATCH (0 rows)... [2018-11-28 06:57:01] [446] Scanning table SUMM_MMS (261 rows)... [2018-11-28 06:57:01] [447] Scanning table SUMM_PREFERENCE_RESPONSETIME (4 rows)... [2018-11-28 06:57:01] [448] Scanning table SUMM_SMS_BATCH (1908 rows)... [2018-11-28 06:57:01] [449] Scanning table SUMM_SMS_BATCH_DAY_HR (93 rows)... [2018-11-28 06:57:01] [450] Scanning table SUMM_SMS_MCC (113 rows)... [2018-11-28 06:57:01] [451] Scanning table SUMM_SMS_REALTIME (27326 rows)... [2018-11-28 06:57:01] [452] Scanning table SUMM_SMS_REALTIME_DAY_HR (545 rows)... [2018-11-28 06:57:01] [453] Scanning table SUREPAY_RESELLERS_MIGRATION (206939 rows)... [2018-11-28 06:57:01] [454] Scanning table TEMPLATE_AUDIT (0 rows)... [2018-11-28 06:57:01] [455] Scanning table TEMPLATE_MASTER (4 rows)... [2018-11-28 06:57:01] [456] Scanning table TEMP_ECS_TEMPLATES_20150423 (2633 rows)... [2018-11-28 06:57:01] [457] Scanning table TEST (1 rows)... [2018-11-28 06:57:01] [458] Scanning table TEST1 (4 rows)... [2018-11-28 06:57:01] [459] Scanning table TEST_EMAIL_ADDRESSES (241647 rows)... [2018-11-28 06:57:01] [460] Scanning table TEST_INSERTALL (6 rows)... [2018-11-28 06:57:01] [461] Scanning table TEST_SHA (1 rows)... [2018-11-28 06:57:01] [462] Scanning table TICKET_REPORT (650 rows)... [2018-11-28 06:57:01] [463] Scanning table TMP_ECS_ONDEMANDEMAIL_NOTIF (5619 rows)... [2018-11-28 06:57:01] [464] Scanning table TMP_SMB_FRONTEND_AUDIT_CORRID (0 rows)... [2018-11-28 06:57:01] [465] Scanning table TRANSACTIONREPORT (1499400 rows)... [2018-11-28 06:57:01] [466] Scanning table TRN_MTAS_MAPPING (274 rows)... [2018-11-28 06:57:01] [467] Scanning table UPLOADS (5 rows)... [2018-11-28 06:57:01] [468] Scanning table URL_MASTER (229 rows)... [2018-11-28 06:57:01] [469] Scanning table USAGE_CONTROLS_BETA_TEST_MTNS (35 rows)... [2018-11-28 06:57:01] [470] Scanning table USAGE_CONTROL_REQUEST_MAPPING (53 rows)... [2018-11-28 06:57:01] [471] Scanning table USER_MASTER (365 rows)... [2018-11-28 06:57:01] [472] Scanning table VISIONACCOUNTS_ROLE (1 rows)... [2018-11-28 06:57:01] [473] Scanning table VISIONAM_UPDATE (9 rows)... [2018-11-28 06:57:02] [474] Scanning table V_COS_SFO_MAPPING (0 rows)... [2018-11-28 06:57:02] [475] Scanning table V_RM_BACK_END_TRANSACTION (52370 rows)... [2018-11-28 06:57:02] [476] Scanning table V_RM_FRONT_END_TRANSACTION (0 rows)... [2018-11-28 06:57:02] [477] Scanning table V_ROAM_MON_ALERT_NOTIFICAION (1066191 rows)... [2018-11-28 06:57:02] [478] Scanning table WAP_PUSH_REQUEST_MAPPING (14 rows)... [2018-11-28 06:57:05] Retrieving partitions information... [2018-11-28 06:58:01] Retrieving sequences information... [2018-11-28 06:58:03] Retrieving triggers information... [2018-11-28 06:58:24] Retrieving procedures information... [2018-11-28 06:58:24] Retrieving packages information... [2018-11-28 06:58:24] Found Package: GENFILE_PKG [2018-11-28 06:58:24] Found Package: REPORT01_PKG [2018-11-28 06:58:24] Retrieving synonyms information... [2018-11-28 06:58:25] Retrieving views information... [2018-11-28 06:58:30] View BATCHSMS_MCC_MESSAGES column aliases: [2018-11-28 06:58:30] CHANNEL => column id:1 [2018-11-28 06:58:30] APPLICATION_ID => column id:2 [2018-11-28 06:58:30] NOTIFICATION_TYPE => column id:3 [2018-11-28 06:58:30] NOTIFICATION_DATE => column id:4 [2018-11-28 06:58:30] NOTIFICATION_ADDRESS => column id:5 [2018-11-28 06:58:30] PARAM_LIST => column id:6 [2018-11-28 06:58:30] NOTIFICATION_MESSAGE => column id:7 [2018-11-28 06:58:30] NOTIFICATION_DELIVERY_DATE => column id:8 [2018-11-28 06:58:30] NOTIFICATION_STATUS => column id:9 [2018-11-28 06:58:30] CUST_ID => column id:10 [2018-11-28 06:58:30] MDN => column id:11 [2018-11-28 06:58:30] View BATCHSMS_MCC_MESSAGES1 column aliases: [2018-11-28 06:58:30] CHANNEL => column id:1 [2018-11-28 06:58:30] APPLICATION_ID => column id:2 [2018-11-28 06:58:30] NOTIFICATION_TYPE => column id:3 [2018-11-28 06:58:30] NOTIFICATION_DATE => column id:4 [2018-11-28 06:58:30] NOTIFICATION_ADDRESS => column id:5 [2018-11-28 06:58:30] PARAM_LIST => column id:6 [2018-11-28 06:58:30] NOTIFICATION_MESSAGE => column id:7 [2018-11-28 06:58:30] NOTIFICATION_DELIVERY_DATE => column id:8 [2018-11-28 06:58:30] NOTIFICATION_STATUS => column id:9 [2018-11-28 06:58:30] CUST_ID => column id:10 [2018-11-28 06:58:30] MDN => column id:11 [2018-11-28 06:58:30] GW_MSG_ID => column id:12 [2018-11-28 06:58:30] View BATCHSMS_MCC_MESSAGES_OLD column aliases: [2018-11-28 06:58:30] CHANNEL => column id:1 [2018-11-28 06:58:30] APPLICATION_ID => column id:2 [2018-11-28 06:58:30] NOTIFICATION_TYPE => column id:3 [2018-11-28 06:58:30] NOTIFICATION_DATE => column id:4 [2018-11-28 06:58:30] NOTIFICATION_ADDRESS => column id:5 [2018-11-28 06:58:30] PARAM_LIST => column id:6 [2018-11-28 06:58:30] NOTIFICATION_MESSAGE => column id:7 [2018-11-28 06:58:30] NOTIFICATION_DELIVERY_DATE => column id:8 [2018-11-28 06:58:30] NOTIFICATION_STATUS => column id:9 [2018-11-28 06:58:30] CUST_ID => column id:10 [2018-11-28 06:58:30] MDN => column id:11 [2018-11-28 06:58:30] View BATCHSMS_MSG column aliases: [2018-11-28 06:58:30] CHANNEL => column id:1 [2018-11-28 06:58:30] APPLICATION_ID => column id:2 [2018-11-28 06:58:30] NOTIFICATION_TYPE => column id:3 [2018-11-28 06:58:30] NOTIFICATION_DATE => column id:4 [2018-11-28 06:58:30] NOTIFICATION_ADDRESS => column id:5 [2018-11-28 06:58:30] PARAM_LIST => column id:6 [2018-11-28 06:58:30] NOTIFICATION_MESSAGE => column id:7 [2018-11-28 06:58:30] NOTIFICATION_DELIVERY_DATE => column id:8 [2018-11-28 06:58:30] NOTIFICATION_STATUS => column id:9 [2018-11-28 06:58:30] CUST_ID => column id:10 [2018-11-28 06:58:30] MDN => column id:11 [2018-11-28 06:58:30] View CCC_REPORTING_MESSAGES column aliases: [2018-11-28 06:58:30] BATCH_ID => column id:1 [2018-11-28 06:58:30] SEQUENCE_NUM => column id:2 [2018-11-28 06:58:30] APPLICATION_ID => column id:3 [2018-11-28 06:58:30] REQUEST_TYPE => column id:4 [2018-11-28 06:58:30] MSG_SUBMIT_DATE => column id:5 [2018-11-28 06:58:30] CUST_ID => column id:6 [2018-11-28 06:58:30] MDN => column id:7 [2018-11-28 06:58:30] REPLYTO_NUMBER => column id:8 [2018-11-28 06:58:30] CALLBACK_NUMBER => column id:9 [2018-11-28 06:58:30] EMAIL_FORMAT => column id:10 [2018-11-28 06:58:30] EMAIL_ADDRESS => column id:11 [2018-11-28 06:58:30] MSG_VALIDITY_PERIOD => column id:12 [2018-11-28 06:58:30] MSG_ID => column id:13 [2018-11-28 06:58:30] MESSAGE => column id:14 [2018-11-28 06:58:30] GW_ACK_DATE => column id:15 [2018-11-28 06:58:30] GW_ACK_CODE => column id:16 [2018-11-28 06:58:30] GW_MSG_ID => column id:17 [2018-11-28 06:58:30] SMSC_ACK_DATE => column id:18 [2018-11-28 06:58:30] SMSC_SEQ_NUMBER => column id:19 [2018-11-28 06:58:30] SMSC_DELIVERY_STATUS => column id:20 [2018-11-28 06:58:30] SMSC_ACK_CODE => column id:21 [2018-11-28 06:58:30] SMSC_ACK_TEXT => column id:22 [2018-11-28 06:58:30] MSG_FINAL_STATUS => column id:23 [2018-11-28 06:58:30] EMAIL_LANG_IND => column id:24 [2018-11-28 06:58:30] SOURCE_IND => column id:25 [2018-11-28 06:58:30] PARAM_LIST => column id:26 [2018-11-28 06:58:30] USER_LEVEL => column id:27 [2018-11-28 06:58:30] LANG_IND => column id:28 [2018-11-28 06:58:30] REQUEST_SOURCE => column id:29 [2018-11-28 06:58:30] View CCES_EMAIL_SVC_VIEW column aliases: [2018-11-28 06:58:30] REQ_ID => column id:1 [2018-11-28 06:58:30] MSG_ID => column id:2 [2018-11-28 06:58:30] APP_ID => column id:3 [2018-11-28 06:58:30] MSG_TYPE => column id:4 [2018-11-28 06:58:30] RECEIVED => column id:5 [2018-11-28 06:58:30] MTN => column id:6 [2018-11-28 06:58:30] ACCT_NO => column id:7 [2018-11-28 06:58:30] MSG_FORMAT => column id:8 [2018-11-28 06:58:30] MSG_LANGUAGE => column id:9 [2018-11-28 06:58:30] SOURCE_IND => column id:10 [2018-11-28 06:58:30] DATE_LOADED => column id:11 [2018-11-28 06:58:30] PARAM_LIST => column id:12 [2018-11-28 06:58:30] REQUEST_SOURCE => column id:13 [2018-11-28 06:58:30] EMAIL_ADDR => column id:14 [2018-11-28 06:58:30] EMAIL_ADDR_TYPE => column id:15 [2018-11-28 06:58:30] SEND_STATUS => column id:16 [2018-11-28 06:58:30] SEND_STATUS_CODE => column id:17 [2018-11-28 06:58:30] SENT => column id:18 [2018-11-28 06:58:30] RETURNED => column id:19 [2018-11-28 06:58:30] RETURN_REASON_CD => column id:20 [2018-11-28 06:58:30] RETURN_REASON_DESC => column id:21 [2018-11-28 06:58:30] PROCESSED_FAILURE => column id:22 [2018-11-28 06:58:30] View CCES_MESSAGES column aliases: [2018-11-28 06:58:30] CHANNEL => column id:1 [2018-11-28 06:58:30] APPLICATION_ID => column id:2 [2018-11-28 06:58:30] NOTIFICATION_TYPE => column id:3 [2018-11-28 06:58:30] NOTIFICATION_DATE => column id:4 [2018-11-28 06:58:30] NOTIFICATION_ADDRESS => column id:5 [2018-11-28 06:58:30] PARAM_LIST => column id:6 [2018-11-28 06:58:30] NOTIFICATION_MESSAGE => column id:7 [2018-11-28 06:58:30] NOTIFICATION_DELIVERY_DATE => column id:8 [2018-11-28 06:58:30] NOTIFICATION_STATUS => column id:9 [2018-11-28 06:58:30] View MAIL column aliases: [2018-11-28 06:58:30] EMAIL_ADDR => column id:1 [2018-11-28 06:58:30] SEND_STATUS => column id:2 [2018-11-28 06:58:30] SEND_STATUS_CODE => column id:3 [2018-11-28 06:58:30] SENT => column id:4 [2018-11-28 06:58:30] RETURNED => column id:5 [2018-11-28 06:58:30] RETURN_REASON_CD => column id:6 [2018-11-28 06:58:30] RETURN_REASON_DESC => column id:7 [2018-11-28 06:58:30] PROCESSED_FAILURE => column id:8 [2018-11-28 06:58:30] APP_ID => column id:9 [2018-11-28 06:58:30] MSG_ID => column id:10 [2018-11-28 06:58:30] ACCT_NO => column id:11 [2018-11-28 06:58:30] MTN => column id:12 [2018-11-28 06:58:30] MSG_TYPE => column id:13 [2018-11-28 06:58:30] View MARKETING_MESSAGES column aliases: [2018-11-28 06:58:30] BATCH_ID => column id:1 [2018-11-28 06:58:30] SEQUENCE_NUM => column id:2 [2018-11-28 06:58:30] APPLICATION_ID => column id:3 [2018-11-28 06:58:30] REQUEST_TYPE => column id:4 [2018-11-28 06:58:30] MSG_SUBMIT_DATE => column id:5 [2018-11-28 06:58:30] CUST_ID => column id:6 [2018-11-28 06:58:30] MDN => column id:7 [2018-11-28 06:58:30] REPLYTO_NUMBER => column id:8 [2018-11-28 06:58:30] CALLBACK_NUMBER => column id:9 [2018-11-28 06:58:30] EMAIL_LANG_IND => column id:10 [2018-11-28 06:58:30] EMAIL_FORMAT => column id:11 [2018-11-28 06:58:30] EMAIL_ADDRESS => column id:12 [2018-11-28 06:58:30] MSG_VALIDITY_PERIOD => column id:13 [2018-11-28 06:58:30] MSG_ID => column id:14 [2018-11-28 06:58:30] MESSAGE => column id:15 [2018-11-28 06:58:30] GW_ACK_DATE => column id:16 [2018-11-28 06:58:30] GW_ACK_CODE => column id:17 [2018-11-28 06:58:30] GW_MSG_ID => column id:18 [2018-11-28 06:58:30] PARAM_LIST => column id:19 [2018-11-28 06:58:30] View MYACCTSMS_MESSAGES column aliases: [2018-11-28 06:58:30] BATCH_ID => column id:1 [2018-11-28 06:58:30] SEQUENCE_NUM => column id:2 [2018-11-28 06:58:30] APPLICATION_ID => column id:3 [2018-11-28 06:58:30] REQUEST_TYPE => column id:4 [2018-11-28 06:58:30] MSG_SUBMIT_DATE => column id:5 [2018-11-28 06:58:30] CUST_ID => column id:6 [2018-11-28 06:58:30] MDN => column id:7 [2018-11-28 06:58:30] REPLYTO_NUMBER => column id:8 [2018-11-28 06:58:30] CALLBACK_NUMBER => column id:9 [2018-11-28 06:58:30] EMAIL_FORMAT => column id:10 [2018-11-28 06:58:30] EMAIL_ADDRESS => column id:11 [2018-11-28 06:58:30] MSG_VALIDITY_PERIOD => column id:12 [2018-11-28 06:58:30] MSG_ID => column id:13 [2018-11-28 06:58:30] MESSAGE => column id:14 [2018-11-28 06:58:30] GW_ACK_DATE => column id:15 [2018-11-28 06:58:30] GW_ACK_CODE => column id:16 [2018-11-28 06:58:30] GW_MSG_ID => column id:17 [2018-11-28 06:58:30] SMSC_ACK_DATE => column id:18 [2018-11-28 06:58:30] SMSC_SEQ_NUMBER => column id:19 [2018-11-28 06:58:30] SMSC_DELIVERY_STATUS => column id:20 [2018-11-28 06:58:30] SMSC_ACK_CODE => column id:21 [2018-11-28 06:58:30] SMSC_ACK_TEXT => column id:22 [2018-11-28 06:58:30] MSG_FINAL_STATUS => column id:23 [2018-11-28 06:58:30] EMAIL_LANG_IND => column id:24 [2018-11-28 06:58:30] SOURCE_IND => column id:25 [2018-11-28 06:58:30] PARAM_LIST => column id:26 [2018-11-28 06:58:30] USER_LEVEL => column id:27 [2018-11-28 06:58:30] LANG_IND => column id:28 [2018-11-28 06:58:30] REQUEST_SOURCE => column id:29 [2018-11-28 06:58:30] View V1 column aliases: [2018-11-28 06:58:30] ERROR_MSG => column id:1 [2018-11-28 06:58:30] APPLICATION_ID => column id:2 [2018-11-28 06:58:30] CLASS_NM => column id:3 [2018-11-28 06:58:30] METHOD_NM => column id:4 [2018-11-28 06:58:30] SEVERITY => column id:5 [2018-11-28 06:58:30] SERVER => column id:6 [2018-11-28 06:58:30] CNT => column id:7 [2018-11-28 06:58:30] [1] Scanning BATCHSMS_MCC_MESSAGES... [2018-11-28 06:58:30] [2] Scanning BATCHSMS_MCC_MESSAGES1... [2018-11-28 06:58:30] [3] Scanning BATCHSMS_MCC_MESSAGES_OLD... [2018-11-28 06:58:30] [4] Scanning BATCHSMS_MSG... [2018-11-28 06:58:30] [5] Scanning CCC_REPORTING_MESSAGES... [2018-11-28 06:58:30] [6] Scanning CCES_EMAIL_SVC_VIEW... [2018-11-28 06:58:30] [7] Scanning CCES_MESSAGES... [2018-11-28 06:58:30] [8] Scanning MAIL... [2018-11-28 06:58:30] [9] Scanning MARKETING_MESSAGES... [2018-11-28 06:58:30] [10] Scanning MYACCTSMS_MESSAGES... [2018-11-28 06:58:30] [11] Scanning V1... [2018-11-28 06:58:30] Retrieving users/roles/grants information... [2018-11-28 06:59:40] Retrieving functions information... [2018-11-28 06:59:40] Retrieving user defined types information... [2018-11-28 06:59:41] Retrieving materialized views information... [2018-11-28 07:00:03] Retrieving dblinks information... [2018-11-28 07:00:03] Retrieving directories information... [2018-11-28 07:00:03] Dumping table ACCOUNTMDNINFO... [2018-11-28 07:00:03] Dumping table ACCOUNTS_DTL... [2018-11-28 07:00:03] Dumping table ALRT_CATEGORY... [2018-11-28 07:00:03] Dumping table ALRT_JOBDETAILS... [2018-11-28 07:00:03] Dumping table ALRT_JOBRUNS... [2018-11-28 07:00:03] Dumping table ALRT_JOBS... [2018-11-28 07:00:03] Dumping table ALRT_SUBSCRIPTIONS... [2018-11-28 07:00:03] Dumping table ALRT_USER_ROLES... [2018-11-28 07:00:03] Dumping table AM_UIM_LETTER... [2018-11-28 07:00:03] Dumping table AM_ZIP_MKT_MAP... [2018-11-28 07:00:03] Dumping table APO_DEENROLLMENT... [2018-11-28 07:00:03] Dumping table APPID_BP_MAPPING... [2018-11-28 07:00:03] Dumping table APPLICATION_ACCESS... [2018-11-28 07:00:03] Dumping table APPLICATION_ACCESS_BAK... [2018-11-28 07:00:03] Dumping table BACKUP_ASSISTANT_PUSH_TEMP... [2018-11-28 07:00:03] Dumping table BADEMAILS... [2018-11-28 07:00:03] Dumping table BATCHEMAILSVC_ADDRESS... [2018-11-28 07:00:03] Dumping table BATCHEMAILSVC_REQUEST... [2018-11-28 07:00:03] Dumping table BATCHSMS_CUSTOMER_RESPONSES... [2018-11-28 07:00:03] Dumping table BATCHSMS_DELIVERY_RECEIPTS... [2018-11-28 07:00:03] Dumping table BATCHSMS_MESSAGES... [2018-11-28 07:00:03] Dumping table BATCHSMS_MSGS_12MNTS... [2018-11-28 07:00:03] Dumping table BATCH_CPNI_ECPD_MYBUS_VISION... [2018-11-28 07:00:03] Dumping table BATCH_CPNI_REALTIME... [2018-11-28 07:00:03] Dumping table BATCH_CPNI_SUMMARY... [2018-11-28 07:00:03] Dumping table BATCH_DATA_LOAD... [2018-11-28 07:00:03] Dumping table BATCH_FEED_SMS... [2018-11-28 07:00:03] Dumping table BATCH_MESSAGES_SUMMARY... [2018-11-28 07:00:03] Dumping table BATCH_SUMMARY... [2018-11-28 07:00:03] Dumping table BILL_READY_INDX... [2018-11-28 07:00:03] Dumping table BPID_INFO... [2018-11-28 07:00:03] Dumping table BP_TO_TEMPLATE_MAPPING... [2018-11-28 07:00:03] Dumping table BS_BATCH_EMAIL_SYNCUP... [2018-11-28 07:00:03] Dumping table BUSINESS_PROCESS... [2018-11-28 07:00:03] Dumping table CAPO_AUDIT_LOGS... [2018-11-28 07:00:03] Dumping table CAPO_CC_EXPIRE_NOTIFICATION... [2018-11-28 07:00:03] Dumping table CAPO_CHECK_PAYMENTS... [2018-11-28 07:00:03] Dumping table CAPO_CREDITCARD_PAYMENTS... [2018-11-28 07:00:03] Dumping table CAPO_DECLINED_PAYMENTS... [2018-11-28 07:00:03] Dumping table CAPO_FUTURE_DATED_PAYMENTS... [2018-11-28 07:00:03] Dumping table CAPO_POSTDATED_CHECK_PAYMENTS... [2018-11-28 07:00:03] Dumping table CCC_APP_ACCESS... [2018-11-28 07:00:03] Dumping table CCC_APP_ACCESS_CUST_VALIDATE... [2018-11-28 07:00:03] Dumping table CCC_APP_ACCESS_ORDER_VALIDATE... [2018-11-28 07:00:03] Dumping table CCC_BUSINESS_RULES... [2018-11-28 07:00:04] Dumping table CCC_BUSINESS_RULES1... [2018-11-28 07:00:04] Dumping table CCC_CLIENT_AUDIT... [2018-11-28 07:00:04] Dumping table CCC_CLIENT_AUDIT_NEW... [2018-11-28 07:00:04] Dumping table CCC_CLIENT_AUDIT_OLD... [2018-11-28 07:00:04] Dumping table CCC_CLIENT_AUDIT_REQ_XML... [2018-11-28 07:00:04] Dumping table CCC_CLIENT_AUDIT_REQ_XML_BKP... [2018-11-28 07:00:04] Dumping table CCC_CLIENT_AUDIT_REQ_XML_OLD... [2018-11-28 07:00:04] Dumping table CCC_DELIVERY_RECEIPTS... [2018-11-28 07:00:04] Dumping table CCC_DEL_RCPTS_RET... [2018-11-28 07:00:04] Dumping table CCC_DM_STATUS... [2018-11-28 07:00:04] Dumping table CCC_DUP... [2018-11-28 07:00:04] Dumping table CCC_MESSAGES... [2018-11-28 07:00:04] Dumping table CCESDM_ERECYCLE_BATCH... [2018-11-28 07:00:04] Dumping table CCESDM_POSSHIPPINGREQUEST... [2018-11-28 07:00:04] Dumping table CCES_ALLTEL_ACCOUNTS... [2018-11-28 07:00:04] Dumping table CCES_ALLTEL_VISION_ACCOUNTS... [2018-11-28 07:00:04] Dumping table CCES_ALP_ACCTLVL_CONF_LTRS_ST... [2018-11-28 07:00:04] Dumping table CCES_ALP_CONFRM_LTR_NEW_SUMM... [2018-11-28 07:00:04] Dumping table CCES_APPL_REQ_MAPPINGS... [2018-11-28 07:00:04] Dumping table CCES_AREA_CONTACTS... [2018-11-28 07:00:04] Dumping table CCES_AUDIT_CTRL... [2018-11-28 07:00:04] Dumping table CCES_AUDIT_LOGS... [2018-11-28 07:00:04] Dumping table CCES_BILL_SHOCK_B2B_FEED... [2018-11-28 07:00:04] Dumping table CCES_CHANGECONTROL_INFO... [2018-11-28 07:00:04] Dumping table CCES_CLNR_SIMP_REQUEST... [2018-11-28 07:00:04] Dumping table CCES_COMMON_BATCH_STATS... [2018-11-28 07:00:04] Dumping table CCES_CONFACTLUL_FATAL_ERRORS... [2018-11-28 07:00:04] Dumping table CCES_CONFIRM_LETTERS... [2018-11-28 07:00:04] Dumping table CCES_CONFIRM_LETTERS_ST_1... [2018-11-28 07:00:04] Dumping table CCES_CONFIRM_LETTERS_SUMM... [2018-11-28 07:00:04] Dumping table CCES_CONFIRM_LETTERS_WFM... [2018-11-28 07:00:04] Dumping table CCES_CONFIRM_LTRS_ACCT_DATA... [2018-11-28 07:00:04] Dumping table CCES_CONFIRM_LTRS_TGR_DTLS... [2018-11-28 07:00:04] Dumping table CCES_CONFLTRS_TGR_ACCT_DTLS... [2018-11-28 07:00:04] Dumping table CCES_DATA_METER_REQUESTS... [2018-11-28 07:00:04] Dumping table CCES_DM_BUSINESS_RULES... [2018-11-28 07:00:04] Dumping table CCES_DM_MAPPING... [2018-11-28 07:00:04] Dumping table CCES_DNC_DETAILS... [2018-11-28 07:00:04] Dumping table CCES_DWH_TRADEIN_GIFTCARD... [2018-11-28 07:00:04] Dumping table CCES_ECPNI_REQUESTS... [2018-11-28 07:00:04] Dumping table CCES_ECPNI_REQUESTS_B... [2018-11-28 07:00:04] Dumping table CCES_ECPNI_REQUESTS_NEW... [2018-11-28 07:00:04] Dumping table CCES_EDGE_REJECT_EMAILS... [2018-11-28 07:00:04] Dumping table CCES_EMAIL_CONFIRMATIONS... [2018-11-28 07:00:04] Dumping table CCES_EMAIL_CONFIRM_SUMM... [2018-11-28 07:00:04] Dumping table CCES_EMAIL_FEATURE... [2018-11-28 07:00:04] Dumping table CCES_EMAIL_FEATURE_SUMM... [2018-11-28 07:00:04] Dumping table CCES_EMAIL_UPDATES_BUS_RULES... [2018-11-28 07:00:04] Dumping table CCES_EMAP_FTRE_OPTSRV_PRC_MAPO... [2018-11-28 07:00:04] Dumping table CCES_EMAP_FTRE_OPT_PRC_MAP12... [2018-11-28 07:00:04] Dumping table CCES_EMAP_FT_OPT_PRC_M_1021... [2018-11-28 07:00:04] Dumping table CCES_EMAP_MGT1... [2018-11-28 07:00:04] Dumping table CCES_EMAP_MGT_1229... [2018-11-28 07:00:04] Dumping table CCES_EMAP_MGT_CLOB_OLD... [2018-11-28 07:00:04] Dumping table CCES_EMAP_MGT_OLD... [2018-11-28 07:00:04] Dumping table CCES_EMAP_MGT_PROD... [2018-11-28 07:00:04] Dumping table CCES_EMAP_MGT_STAG... [2018-11-28 07:00:04] Dumping table CCES_EMAP_MGT_STAGING_OLD... [2018-11-28 07:00:04] Dumping table CCES_EMAP_MGT_TST... [2018-11-28 07:00:04] Dumping table CCES_FILE_DTLS... [2018-11-28 07:00:04] Dumping table CCES_FIOS_BUNDLE_MESSAGES... [2018-11-28 07:00:04] Dumping table CCES_FTRE_OPTSRV_FOOTNOTES_O... [2018-11-28 07:00:04] Dumping table CCES_FTRE_OPTSRV_FOOT_1021... [2018-11-28 07:00:04] Dumping table CCES_FTRE_OPTSRV_FTNTS12... [2018-11-28 07:00:04] Dumping table CCES_GLOBAL_EMAP_UPDATES_OLD... [2018-11-28 07:00:04] Dumping table CCES_GLOBAL_OPTIN_REQUEST... [2018-11-28 07:00:04] Dumping table CCES_GLOBAL_OPTIN_WHITELIST... [2018-11-28 07:00:04] Dumping table CCES_HPC_REQUESTS... [2018-11-28 07:00:04] Dumping table CCES_INHOUSE_MASTER_DATA_STG... [2018-11-28 07:00:04] Dumping table CCES_IUBE_NETWORK_MGMT... [2018-11-28 07:00:04] Dumping table CCES_KRONOS_EMAIL_DTL_MESSAGES... [2018-11-28 07:00:04] Dumping table CCES_KRONOS_EMAIL_MESSAGES... [2018-11-28 07:00:04] Dumping table CCES_KRONOS_SMS_MESSAGES... [2018-11-28 07:00:04] Dumping table CCES_LDAP_IDC_SDC_SYNC_UP... [2018-11-28 07:00:04] Dumping table CCES_MHEALTH_STMT_REV_ERR_DATA... [2018-11-28 07:00:04] Dumping table CCES_MLTRY_SPND... [2018-11-28 07:00:04] Dumping table CCES_MOBILE_PAYMENTS... [2018-11-28 07:00:04] Dumping table CCES_MVM_MESSAGES... [2018-11-28 07:00:04] Dumping table CCES_NEW_DATA... [2018-11-28 07:00:04] Dumping table CCES_OLD_DATA... [2018-11-28 07:00:04] Dumping table CCES_PREPAY_BUNDLE_DETAILS... [2018-11-28 07:00:04] Dumping table CCES_PRODSUPPTOOL_CONSTANTS... [2018-11-28 07:00:04] Dumping table CCES_PROD_CC_INFO... [2018-11-28 07:00:04] Dumping table CCES_REAL_TIME_MDN_DISCONNECT... [2018-11-28 07:00:04] Dumping table CCES_RESOURCE_CENTRAL_FEED... [2018-11-28 07:00:04] Dumping table CCES_RE_ACT_NOTIFICATION... [2018-11-28 07:00:04] Dumping table CCES_RIM_3G_PRICE_PLAN... [2018-11-28 07:00:04] Dumping table CCES_RTR_ALLOWANCE_MSGS... [2018-11-28 07:00:04] Dumping table CCES_RTR_DEVICE_DETAILS... [2018-11-28 07:00:04] Dumping table CCES_SECURE_EBILL_MESSAGES... [2018-11-28 07:00:04] Dumping table CCES_SMB_AUDIT_LOGS... [2018-11-28 07:00:04] Dumping table CCES_SMB_ECPD_DATA... [2018-11-28 07:00:04] Dumping table CCES_SPLIT_BILLING_REQUESTS... [2018-11-28 07:00:04] Dumping table CCES_SPRBNDL_MOC_NOTIFICATIONS... [2018-11-28 07:00:04] Dumping table CCES_SUMMARY... [2018-11-28 07:00:04] Dumping table CCES_TANDC_EMAIL... [2018-11-28 07:00:04] Dumping table CCES_TERMS_AND_COND_REQUESTS... [2018-11-28 07:00:04] Dumping table CCES_TERMS_AND_COND_REQUESTS_B... [2018-11-28 07:00:04] Dumping table CCES_TERMS_AND_COND_REQUESTS_S... [2018-11-28 07:00:04] Dumping table CCES_TERMS_AND_COND_REQ_AOL... [2018-11-28 07:00:04] Dumping table CCES_TERMS_AND_COND_REQ_DVS... [2018-11-28 07:00:04] Dumping table CCES_TERMS_AND_COND_REQ_DVS2... [2018-11-28 07:00:04] Dumping table CCES_TERMS_AND_COND_REQ_VISION... [2018-11-28 07:00:04] Dumping table CCES_TNC_REQUESTS_ERR_LOG... [2018-11-28 07:00:04] Dumping table CCES_TRAN_LOGS... [2018-11-28 07:00:04] Dumping table CCES_UC_REMINDER... [2018-11-28 07:00:04] Dumping table CCES_USER_TRACKING... [2018-11-28 07:00:04] Dumping table CCES_VZNAVIG_CAMPAIGN... [2018-11-28 07:00:04] Dumping table CCES_WELCOME_CLOUD_BATCH... [2018-11-28 07:00:04] Dumping table CCMIDDLEWARE_CRM10DEV_011108_J... [2018-11-28 07:00:04] Dumping table CCMIDDLEWARE_CRM10DEV_093008_J... [2018-11-28 07:00:04] Dumping table CLNR_PHOTO_DETAILS... [2018-11-28 07:00:04] Dumping table CMP3$217345... [2018-11-28 07:00:04] Dumping table COMM_CONFIG... [2018-11-28 07:00:04] Dumping table COMM_REQUEST_AUDIT... [2018-11-28 07:00:04] Dumping table COMM_REQ_REPLAY_MAP... [2018-11-28 07:00:04] Dumping table CONSUMER_FALLOUT... [2018-11-28 07:00:04] Dumping table CORRUPTED_ACCOUNTS... [2018-11-28 07:00:04] Dumping table CPNI_BACKEND_AUDIT... [2018-11-28 07:00:04] Dumping table CPNI_BIANNUAL_PROCESSD_OUTPUT... [2018-11-28 07:00:04] Dumping table CPNI_CLIENT_AUDIT... [2018-11-28 07:00:04] Dumping table CREDIT_CARD_EXPIRATION... [2018-11-28 07:00:04] Dumping table CREDIT_CARD_EXPIRATION_COPY... [2018-11-28 07:00:04] Dumping table CREDIT_CARD_EXPIRATION_OLD... [2018-11-28 07:00:04] Dumping table CRM_BACKEND_AUDIT... [2018-11-28 07:00:04] Dumping table CRM_CAMPAIGN_INFO... [2018-11-28 07:00:04] Dumping table CRM_CLIENT_AUDIT... [2018-11-28 07:00:04] Dumping table CRM_MT_SMSMESSAGES... [2018-11-28 07:00:04] Dumping table CRONJOBS_CHECK... [2018-11-28 07:00:04] Dumping table CRON_JOBS... [2018-11-28 07:00:04] Dumping table CROSS_REFERENCE_CONTACTS... [2018-11-28 07:00:04] Dumping table CUSTUSAGEALERTAPP_PROPERTIES... [2018-11-28 07:00:04] Dumping table DATAMETER_DELIVERY_RECEIPTS... [2018-11-28 07:00:04] Dumping table DATAMETER_MESSAGES... [2018-11-28 07:00:04] Dumping table DATAPOWER_AUTHENTICATION... [2018-11-28 07:00:04] Dumping table DATAPOWER_DATA_VALIDATION... [2018-11-28 07:00:04] Dumping table DATA_LOAD_DETAILS... [2018-11-28 07:00:04] Dumping table DATA_METER_REALTIME_REQUESTS... [2018-11-28 07:00:04] Dumping table DATA_USAGE_ALERTS... [2018-11-28 07:00:04] Dumping table DECLINE_PAYMENTS_SMS... [2018-11-28 07:00:04] Dumping table DELIVERY_ACK_ROUTING... [2018-11-28 07:00:04] Dumping table DEP... [2018-11-28 07:00:04] Dumping table DEPT... [2018-11-28 07:00:04] Dumping table DISCONNECTED_MTNS... [2018-11-28 07:00:04] Dumping table DISCONNECTED_MTNS_DETAILS... [2018-11-28 07:00:04] Dumping table DISCONNECTED_MTNS_DETAILS_ORIG... [2018-11-28 07:00:04] Dumping table DMDFEACHK_BACKEND_AUDIT... [2018-11-28 07:00:04] Dumping table DMDFEACHK_BACKEND_AUDIT_OLD... [2018-11-28 07:00:04] Dumping table DMDFEACHK_CLIENT_AUDIT... [2018-11-28 07:00:04] Dumping table DMDFEACHK_CLIENT_AUDIT_OLD... [2018-11-28 07:00:04] Dumping table DMD_PRODUCTS_LIST... [2018-11-28 07:00:04] Dumping table DM_APPSERVER... [2018-11-28 07:00:04] Dumping table DM_APPSERVER_TO_PROP... [2018-11-28 07:00:04] Dumping table DM_PROPERTY_INFO... [2018-11-28 07:00:04] Dumping table DNC_CLEANUP_DETAILS... [2018-11-28 07:00:04] Dumping table DNC_CUST_RECEIPTS... [2018-11-28 07:00:04] Dumping table ECS_ACC_MDN_CLEANUP... [2018-11-28 07:00:04] Dumping table ECS_BILL_READY_EAST... [2018-11-28 07:00:04] Dumping table ECS_BILL_READY_NOTIFICATIONS... [2018-11-28 07:00:04] Dumping table ECS_BILL_READY_NOTIFIC_CONV... [2018-11-28 07:00:04] Dumping table ECS_BILL_READY_TMP... [2018-11-28 07:00:04] Dumping table ECS_BILL_READY_TMP_ODC... [2018-11-28 07:00:04] Dumping table ECS_BILL_READY_TMP_SDC... [2018-11-28 07:00:04] Dumping table ECS_BILL_READY_WEST... [2018-11-28 07:00:04] Dumping table ECS_BP_DOCID_MAPPING... [2018-11-28 07:00:04] Dumping table ECS_FAX_ATTACH... [2018-11-28 07:00:04] Dumping table ECS_FAX_REQUEST... [2018-11-28 07:00:04] Dumping table ECS_I1Y1... [2018-11-28 07:00:04] Dumping table ECS_ONDEMANDEMAIL_NOTIFICATION... [2018-11-28 07:00:04] Dumping table ECS_ONDEMANDEMAIL_NOT_TMP... [2018-11-28 07:00:04] Dumping table ECS_OPTOUT... [2018-11-28 07:00:04] Dumping table ECS_PAYMENT_NOTIFICATIONS... [2018-11-28 07:00:04] Dumping table ECS_REPORTS_SUMMARY... [2018-11-28 07:00:04] Dumping table ECS_TEMPLATES... [2018-11-28 07:00:04] Dumping table ECS_TEMPLATES_0519... [2018-11-28 07:00:04] Dumping table ECS_TEMPLATES_09242010... [2018-11-28 07:00:04] Dumping table ECS_TEMPLATES_1... [2018-11-28 07:00:04] Dumping table ECS_TEMPLATES_BKUP... [2018-11-28 07:00:04] Dumping table ECS_TEMPLATES_MASTER... [2018-11-28 07:00:04] Dumping table ECS_TEMPLATES_PROD... [2018-11-28 07:00:04] Dumping table ECS_TEMPLATE_ROLE... [2018-11-28 07:00:04] Dumping table ECS_TEMPLATE_STAGING... [2018-11-28 07:00:04] Dumping table ECS_TICKETS... [2018-11-28 07:00:04] Dumping table ECS_TICKETS_TEST... [2018-11-28 07:00:04] Dumping table EDUCATIONAL_PROMO_CODES... [2018-11-28 07:00:04] Dumping table EMAILBOX_PURGING... [2018-11-28 07:00:04] Dumping table EMAILSVC_ADDRESS... [2018-11-28 07:00:04] Dumping table EMAILSVC_REQUEST... [2018-11-28 07:00:04] Dumping table EMAILUNSUBSCRIBE_LOG... [2018-11-28 07:00:04] Dumping table EMAILVALIDATION_LDAP... [2018-11-28 07:00:04] Dumping table EMAILVALIDATION_VISION... [2018-11-28 07:00:04] Dumping table EMAIL_LAYOUTS... [2018-11-28 07:00:04] Dumping table EMAIL_OPENED... [2018-11-28 07:00:04] Dumping table EMAIL_TEMPLATES... [2018-11-28 07:00:04] Dumping table EMP... [2018-11-28 07:00:04] Dumping table EMPGATEWAY_AUTH_APPLICATION... [2018-11-28 07:00:04] Dumping table EMPLOYEE... [2018-11-28 07:00:04] Dumping table EMPLOYEE_ALERTS_AUDIT_LOGS... [2018-11-28 07:00:04] Dumping table EMPLOYEE_ALERTS_USER_GROUP... [2018-11-28 07:00:04] Dumping table EMPLOYEE_ALERTS_USER_MASTER... [2018-11-28 07:00:04] Dumping table EMPLOYEE_ALERTS_USER_TO_GROUP... [2018-11-28 07:00:04] Dumping table EMP_ALERTS_CUST_LST_CONTACT... [2018-11-28 07:00:04] Dumping table EMP_ALERTS_GRP_CUST_LST... [2018-11-28 07:00:04] Dumping table EQUIPMENT_CHARGEBACK_FEED_SMS... [2018-11-28 07:00:04] Dumping table ERRORS... [2018-11-28 07:00:04] Dumping table EVNT_HISTORY... [2018-11-28 07:00:04] Dumping table EVNT_MONITORS... [2018-11-28 07:00:04] Dumping table EVNT_SCOPE... [2018-11-28 07:00:04] Dumping table FAILURE_EMAIL_ADDR... [2018-11-28 07:00:04] Dumping table FF_CLEANUP_ACCTS_MDN... [2018-11-28 07:00:04] Dumping table FF_CLEANUP_MDN_UPDATES... [2018-11-28 07:00:04] Dumping table GBL_WSMS_EXCEPTIONS... [2018-11-28 07:00:04] Dumping table GBL_WSMS_RATES_AND_DIALINGINFO... [2018-11-28 07:00:04] Dumping table GBL_WSMS_ROAMTIER... [2018-11-28 07:00:04] Dumping table GBL_WSMS_SFO_LIST... [2018-11-28 07:00:04] Dumping table GBL_WSMS_TRACK... [2018-11-28 07:00:04] Dumping table GENERIC_SMALL_PROJECT_LOADS... [2018-11-28 07:00:04] Dumping table GLOBAL_WSMS_COUNTRY... [2018-11-28 07:00:04] Dumping table GLOBAL_WSMS_COUNTRY1... [2018-11-28 07:00:04] Dumping table GLOBAL_WSMS_DIALING... [2018-11-28 07:00:04] Dumping table GLOBAL_WSMS_DIALING1... [2018-11-28 07:00:04] Dumping table GLOBAL_WSMS_RATES... [2018-11-28 07:00:04] Dumping table GLOBAL_WSMS_RATES1... [2018-11-28 07:00:04] Dumping table GLOBAL_WSMS_XREF... [2018-11-28 07:00:04] Dumping table INTERACTIVE_SMS_STATE... [2018-11-28 07:00:04] Dumping table ISMS_AUDIT_LOGS... [2018-11-28 07:00:04] Dumping table IVR_SELF_SERVICE_ALERTS... [2018-11-28 07:00:04] Dumping table LDAPCUSTOMERRECORDS... [2018-11-28 07:00:04] Dumping table LDAP_ACCOUNTS... [2018-11-28 07:00:04] Dumping table LDAP_ACCOUNTS_MDN... [2018-11-28 07:00:04] Dumping table LDAP_DATAWAREFEED... [2018-11-28 07:00:04] Dumping table LDAP_MIGRATE_ACCOUNTS... [2018-11-28 07:00:04] Dumping table LETTERVIEWERACCESS... [2018-11-28 07:00:04] Dumping table LETTER_MGT_AUDIT_LOGS_O... [2018-11-28 07:00:04] Dumping table LETTER_PROCESS_CONFIG... [2018-11-28 07:00:04] Dumping table LONG_CODE_MAPPING... [2018-11-28 07:00:04] Dumping table LV_PROPS... [2018-11-28 07:00:04] Dumping table MASTER_DATA_REPOSITORY... [2018-11-28 07:00:04] Dumping table MASTER_SERVERS_REPOSITORY... [2018-11-28 07:00:04] Dumping table MATCHING_MDN_ACCT... [2018-11-28 07:00:04] Dumping table MCC_CUSTOMER_RESPONSES... [2018-11-28 07:00:04] Dumping table MCC_DELIVERY_RECEIPTS... [2018-11-28 07:00:04] Dumping table MCC_MESSAGES... [2018-11-28 07:00:04] Dumping table MDN_PID_ITEMID_MAPPING... [2018-11-28 07:00:04] Dumping table MESSAGES_SUMMARY... [2018-11-28 07:00:04] Dumping table MMG_ALERT_CONFIG... [2018-11-28 07:00:04] Dumping table MMG_AUDIT_LOGS... [2018-11-28 07:00:04] Dumping table MMG_CALLBACK_OVERRIDE... [2018-11-28 07:00:04] Dumping table MMG_ERROR_LOGS... [2018-11-28 07:00:04] Dumping table MMG_SUMMARY_INFO... [2018-11-28 07:00:04] Dumping table MMG_TRANSACTION_DATA... [2018-11-28 07:00:04] Dumping table MMG_TRANSACTION_GATEWAY_ID... [2018-11-28 07:00:04] Dumping table MMS_CONTENT... [2018-11-28 07:00:04] Dumping table MMS_CONTENT_MAPPINGS... [2018-11-28 07:00:04] Dumping table MMS_CONTENT_TYPE... [2018-11-28 07:00:04] Dumping table MMS_DELIVERY_REPORTS... [2018-11-28 07:00:04] Dumping table MMS_DELIVERY_REPORTS_SAT... [2018-11-28 07:00:04] Dumping table MMS_MESSAGES... [2018-11-28 07:00:04] Dumping table MMS_MO... [2018-11-28 07:00:04] Dumping table MQ_ALERT_CONFIG... [2018-11-28 07:00:04] Dumping table MQ_ALERT_RECORDS... [2018-11-28 07:00:04] Dumping table MR_DATA_SMS_STATS... [2018-11-28 07:00:04] Dumping table MR_LOC_SMS_STATS... [2018-11-28 07:00:04] Dumping table MSG_AUDIT_LOGS... [2018-11-28 07:00:04] Dumping table MSG_AUDIT_LOGS_0818... [2018-11-28 07:00:04] Dumping table MSG_CNT_REQ_FOLDER_MAPPINGS... [2018-11-28 07:00:04] Dumping table MSG_LOADTEST_MTN... [2018-11-28 07:00:04] Dumping table MTAS_ESB_TRANSACTION... [2018-11-28 07:00:04] Dumping table MTAS_TRANS... [2018-11-28 07:00:04] Dumping table MTAS_TRANS_BKUP... [2018-11-28 07:00:04] Dumping table MTN_CROSS_REFERENCE... [2018-11-28 07:00:04] Dumping table MYACCTSMS_MESSAGES_ORIG... [2018-11-28 07:00:04] Dumping table MYACCTSMS_RESPONSES... [2018-11-28 07:00:04] Dumping table MY_BIZ_SAC_NOTIF... [2018-11-28 07:00:04] Dumping table NDR_DATA_ERROR_LOG... [2018-11-28 07:00:04] Dumping table NOTIFICATION_BLOCKED_ACCTS... [2018-11-28 07:00:04] Dumping table NOTIFICATION_SEQUENCE... [2018-11-28 07:00:04] Dumping table OMSG_ALERT_AUDIT... [2018-11-28 07:00:04] Dumping table OM_ACTIVATION_AUDIT... [2018-11-28 07:00:04] Dumping table OM_ERROR_AUDIT... [2018-11-28 07:00:04] Dumping table ONDEMAND_SMS... [2018-11-28 07:00:04] Dumping table ONDEMAND_SMS_MSG_TEMPLATES... [2018-11-28 07:00:04] Dumping table ONETIME_PAYMENTS... [2018-11-28 07:00:04] Dumping table OPERATIONS_FLEX... [2018-11-28 07:00:04] Dumping table ORDER_DETAILS... [2018-11-28 07:00:04] Dumping table PAGE_MASTER... [2018-11-28 07:00:04] Dumping table PAYMENT_AUDIT_LOGS... [2018-11-28 07:00:04] Dumping table PC_AUDIT_ERROR_TRACE... [2018-11-28 07:00:04] Dumping table PC_AUDIT_NOTIFICATION... [2018-11-28 07:00:04] Dumping table PC_AUDIT_REQUEST... [2018-11-28 07:00:04] Dumping table PC_AUDIT_STATUS_MASTER... [2018-11-28 07:00:04] Dumping table PC_CLEANUP_DISC_REASSIGN_MDNS... [2018-11-28 07:00:04] Dumping table PID_ITEMID_MAPPING... [2018-11-28 07:00:04] Dumping table PLSQL_PROFILER_DATA... [2018-11-28 07:00:04] Dumping table PLSQL_PROFILER_RUNS... [2018-11-28 07:00:04] Dumping table PLSQL_PROFILER_UNITS... [2018-11-28 07:00:04] Dumping table POUND_MESSAGES... [2018-11-28 07:00:04] Dumping table POUND_REQ_STATUS... [2018-11-28 07:00:04] Dumping table PRECISION_AUDIT_INFORMATION... [2018-11-28 07:00:04] Dumping table PREPAY_CUST_RCPT_AUDIT_LOGS... [2018-11-28 07:00:04] Dumping table PREPAY_PAYDETAILS... [2018-11-28 07:00:04] Dumping table PREPAY_PROMOTIONS... [2018-11-28 07:00:04] Dumping table PRICE_PLAN_SMS... [2018-11-28 07:00:04] Dumping table PRLUPDATE_TRANSACTION... [2018-11-28 07:00:04] Dumping table PROBLEM_LOG_DETAILS... [2018-11-28 07:00:04] Dumping table PRODUCTION_TEST_EMAILS... [2018-11-28 07:00:04] Dumping table PRODUCTION_TEST_MTNS... [2018-11-28 07:00:04] Dumping table QA_SIGN_OFF... [2018-11-28 07:00:04] Dumping table QRTZ_BLOB_TRIGGERS... [2018-11-28 07:00:04] Dumping table QRTZ_CALENDARS... [2018-11-28 07:00:04] Dumping table QRTZ_CRON_TRIGGERS... [2018-11-28 07:00:04] Dumping table QRTZ_FIRED_TRIGGERS... [2018-11-28 07:00:04] Dumping table QRTZ_JOB_DETAILS... [2018-11-28 07:00:04] Dumping table QRTZ_JOB_LISTENERS... [2018-11-28 07:00:04] Dumping table QRTZ_LOCKS... [2018-11-28 07:00:04] Dumping table QRTZ_PAUSED_TRIGGER_GRPS... [2018-11-28 07:00:04] Dumping table QRTZ_SCHEDULER_STATE... [2018-11-28 07:00:04] Dumping table QRTZ_SIMPLE_TRIGGERS... [2018-11-28 07:00:04] Dumping table QRTZ_SIMPROP_TRIGGERS... [2018-11-28 07:00:04] Dumping table QRTZ_TRIGGERS... [2018-11-28 07:00:04] Dumping table QRTZ_TRIGGER_LISTENERS... [2018-11-28 07:00:04] Dumping table QUEUE_BACKUP... [2018-11-28 07:00:04] Dumping table REALTIME_DATA_USAGE_ALERTS... [2018-11-28 07:00:04] Dumping table REF_PREFERENCE_TYPE... [2018-11-28 07:00:04] Dumping table REQUEST_MSG_MAP... [2018-11-28 07:00:04] Dumping table REVERSE_CROSS_REFERENCES... [2018-11-28 07:00:04] Dumping table RIM_3G_PRICE_PLANS_E... [2018-11-28 07:00:04] Dumping table RIM_3G_PRICE_PLANS_E_OLD... [2018-11-28 07:00:04] Dumping table RIM_3G_PRICE_PLANS_S... [2018-11-28 07:00:04] Dumping table RIM_3G_PRICE_PLANS_S_OLD... [2018-11-28 07:00:04] Dumping table ROLE_MASTER... [2018-11-28 07:00:04] Dumping table ROLE_TO_PAGE_MAPPING... [2018-11-28 07:00:04] Dumping table ROLE_TO_USER_MAPPING... [2018-11-28 07:00:04] Dumping table RPTING_CATEGORIES... [2018-11-28 07:00:04] Dumping table RTRSTATS... [2018-11-28 07:00:04] Dumping table RTR_4G_TEST_NUMBERS... [2018-11-28 07:00:04] Dumping table RTR_AUDIT_ALERTS_SENT... [2018-11-28 07:00:04] Dumping table RTR_AUDIT_LOG... [2018-11-28 07:00:04] Dumping table RTR_AUDIT_REQUEST... [2018-11-28 07:00:04] Dumping table RTR_INC_ALERTS_AUDIT_LOGS_OLD... [2018-11-28 07:00:04] Dumping table RTR_MESSAGES... [2018-11-28 07:00:04] Dumping table RTR_PROPERTIES... [2018-11-28 07:00:04] Dumping table RTR_THLD_ALERTS_AUDIT_LOGS... [2018-11-28 07:00:04] Dumping table RTR_TRANSACTION... [2018-11-28 07:00:04] Dumping table SCRIPT_DETAIL... [2018-11-28 07:00:04] Dumping table SCRIPT_LOG_DETAIL... [2018-11-28 07:00:04] Dumping table SECURE_EBILL_AUDIT_LOGS... [2018-11-28 07:00:04] Dumping table SECURE_EBILL_REVO_REPORT... [2018-11-28 07:00:04] Dumping table SEP_DEBUG... [2018-11-28 07:00:04] Dumping table SHED_STATE... [2018-11-28 07:00:04] Dumping table SIGN_OFF... [2018-11-28 07:00:04] Dumping table SMB_BACKEND_AUDIT... [2018-11-28 07:00:04] Dumping table SMB_BLOB_TRIGGERS... [2018-11-28 07:00:04] Dumping table SMB_CALENDARS... [2018-11-28 07:00:04] Dumping table SMB_CRON_TRIGGERS... [2018-11-28 07:00:04] Dumping table SMB_ERRORS... [2018-11-28 07:00:04] Dumping table SMB_FIRED_TRIGGERS... [2018-11-28 07:00:04] Dumping table SMB_FRONTEND_AUDIT... [2018-11-28 07:00:04] Dumping table SMB_FRONTEND_AUDIT_CORRID... [2018-11-28 07:00:04] Dumping table SMB_FRONTEND_AUDIT_OLD... [2018-11-28 07:00:04] Dumping table SMB_JOB_DETAILS... [2018-11-28 07:00:04] Dumping table SMB_JOB_LISTENERS... [2018-11-28 07:00:04] Dumping table SMB_LOCKS... [2018-11-28 07:00:04] Dumping table SMB_PAUSED_TRIGGER_GRPS... [2018-11-28 07:00:04] Dumping table SMB_SCHEDULER_STATE... [2018-11-28 07:00:04] Dumping table SMB_SIMPLE_TRIGGERS... [2018-11-28 07:00:04] Dumping table SMB_TRIGGERS... [2018-11-28 07:00:04] Dumping table SMB_TRIGGER_LISTENERS... [2018-11-28 07:00:04] Dumping table SMS_ACK_MAPPINGS... [2018-11-28 07:00:04] Dumping table SMS_ACK_RULES... [2018-11-28 07:00:04] Dumping table SMS_CROSS_REFERENCES... [2018-11-28 07:00:04] Dumping table SMS_MO... [2018-11-28 07:00:04] Dumping table SMS_RESPONSE_MAPPING... [2018-11-28 07:00:04] Dumping table SMS_RESPONSE_MAPPINGS... [2018-11-28 07:00:04] Dumping table SMS_RESPONSE_RULES... [2018-11-28 07:00:04] Dumping table SMS_STATS... [2018-11-28 07:00:04] Dumping table SMS_TEMPLATES... [2018-11-28 07:00:04] Dumping table SPC_BACKEND_AUDIT... [2018-11-28 07:00:04] Dumping table SPC_CLIENT_AUDIT... [2018-11-28 07:00:04] Dumping table SQLN_EXPLAIN_PLAN... [2018-11-28 07:00:04] Dumping table SQLN_PROF_ANB... [2018-11-28 07:00:04] Dumping table SQLN_PROF_PROFILES... [2018-11-28 07:00:04] Dumping table SQLN_PROF_RUNS... [2018-11-28 07:00:04] Dumping table SQLN_PROF_SESS... [2018-11-28 07:00:04] Dumping table SQLN_PROF_UNITS... [2018-11-28 07:00:04] Dumping table SQLN_PROF_UNIT_HASH... [2018-11-28 07:00:04] Dumping table SRVC_REGISTRY... [2018-11-28 07:00:04] Dumping table STACKABLE_DATA_NOTIFICATIONS... [2018-11-28 07:00:04] Dumping table SUMMARY_JOBS_LOG... [2018-11-28 07:00:04] Dumping table SUMM_AUDIT_LOGS... [2018-11-28 07:00:04] Dumping table SUMM_AUDIT_LOGS_DETAIL... [2018-11-28 07:00:04] Dumping table SUMM_AUDIT_REQUEST... [2018-11-28 07:00:04] Dumping table SUMM_CNFM_FATAL_ERRORS... [2018-11-28 07:00:04] Dumping table SUMM_CNFM_LETTERS_SUMM... [2018-11-28 07:00:04] Dumping table SUMM_CNFM_LETTERS_WFM... [2018-11-28 07:00:04] Dumping table SUMM_CNFM_LTRS_TGR_DTLS... [2018-11-28 07:00:04] Dumping table SUMM_CONFIRM_LETTERS... [2018-11-28 07:00:04] Dumping table SUMM_CPNI_PROCESSING... [2018-11-28 07:00:04] Dumping table SUMM_EMAIL... [2018-11-28 07:00:04] Dumping table SUMM_EMAIL_BATCH... [2018-11-28 07:00:04] Dumping table SUMM_MMS... [2018-11-28 07:00:04] Dumping table SUMM_PREFERENCE_RESPONSETIME... [2018-11-28 07:00:04] Dumping table SUMM_SMS_BATCH... [2018-11-28 07:00:04] Dumping table SUMM_SMS_BATCH_DAY_HR... [2018-11-28 07:00:04] Dumping table SUMM_SMS_MCC... [2018-11-28 07:00:04] Dumping table SUMM_SMS_REALTIME... [2018-11-28 07:00:04] Dumping table SUMM_SMS_REALTIME_DAY_HR... [2018-11-28 07:00:04] Dumping table SUREPAY_RESELLERS_MIGRATION... [2018-11-28 07:00:04] Dumping table TEMPLATE_AUDIT... [2018-11-28 07:00:04] Dumping table TEMPLATE_MASTER... [2018-11-28 07:00:04] Dumping table TEMP_ECS_TEMPLATES_20150423... [2018-11-28 07:00:04] Dumping table TEST... [2018-11-28 07:00:04] Dumping table TEST1... [2018-11-28 07:00:04] Dumping table TEST_EMAIL_ADDRESSES... [2018-11-28 07:00:04] Dumping table TEST_INSERTALL... [2018-11-28 07:00:04] Dumping table TEST_SHA... [2018-11-28 07:00:04] Dumping table TICKET_REPORT... [2018-11-28 07:00:04] Dumping table TMP_ECS_ONDEMANDEMAIL_NOTIF... [2018-11-28 07:00:04] Dumping table TMP_SMB_FRONTEND_AUDIT_CORRID... [2018-11-28 07:00:04] Dumping table TRANSACTIONREPORT... [2018-11-28 07:00:04] Dumping table TRN_MTAS_MAPPING... [2018-11-28 07:00:04] Dumping table UPLOADS... [2018-11-28 07:00:04] Dumping table URL_MASTER... [2018-11-28 07:00:04] Dumping table USAGE_CONTROLS_BETA_TEST_MTNS... [2018-11-28 07:00:04] Dumping table USAGE_CONTROL_REQUEST_MAPPING... [2018-11-28 07:00:04] Dumping table USER_MASTER... [2018-11-28 07:00:04] Dumping table VISIONACCOUNTS_ROLE... [2018-11-28 07:00:04] Dumping table VISIONAM_UPDATE... [2018-11-28 07:00:04] Dumping table V_COS_SFO_MAPPING... [2018-11-28 07:00:04] Dumping table V_RM_BACK_END_TRANSACTION... [2018-11-28 07:00:04] Dumping table V_RM_FRONT_END_TRANSACTION... [2018-11-28 07:00:04] Dumping table V_ROAM_MON_ALERT_NOTIFICAION... [2018-11-28 07:00:04] Dumping table WAP_PUSH_REQUEST_MAPPING... [2018-11-28 07:00:04] Dumping indexes to one separate file : INDEXES_ora2pg_db12c_onemsssguat_ddl_output10.sql [2018-11-28 07:00:04] Dumping RI PLSQL_PROFILER_DATA... [2018-11-28 07:00:04] Dumping RI BP_TO_TEMPLATE_MAPPING... [2018-11-28 07:00:04] Dumping RI SMB_TRIGGERS... [2018-11-28 07:00:04] Dumping RI SQLN_PROF_RUNS... [2018-11-28 07:00:04] Dumping RI PLSQL_PROFILER_UNITS... [2018-11-28 07:00:04] Dumping RI SRVC_REGISTRY... [2018-11-28 07:00:04] Dumping RI QRTZ_BLOB_TRIGGERS... [2018-11-28 07:00:04] Dumping RI SMB_BLOB_TRIGGERS... [2018-11-28 07:00:04] Dumping RI CCES_KRONOS_EMAIL_DTL_MESSAGES... [2018-11-28 07:00:04] Dumping RI PC_AUDIT_REQUEST... [2018-11-28 07:00:04] Dumping RI EVNT_SCOPE... [2018-11-28 07:00:04] Dumping RI EVNT_MONITORS... [2018-11-28 07:00:04] Dumping RI SMB_JOB_LISTENERS... [2018-11-28 07:00:04] Dumping RI PC_AUDIT_NOTIFICATION... [2018-11-28 07:00:04] Dumping RI SMB_SIMPLE_TRIGGERS... [2018-11-28 07:00:04] Dumping RI ECS_FAX_ATTACH... [2018-11-28 07:00:04] Dumping RI SMB_CRON_TRIGGERS... [2018-11-28 07:00:04] Dumping RI QRTZ_SIMPLE_TRIGGERS... [2018-11-28 07:00:04] Dumping RI BATCHEMAILSVC_ADDRESS... [2018-11-28 07:00:04] Dumping RI SMS_CROSS_REFERENCES... [2018-11-28 07:00:04] Dumping RI SQLN_PROF_UNIT_HASH... [2018-11-28 07:00:04] Dumping RI ECS_TEMPLATE_STAGING... [2018-11-28 07:00:04] Dumping RI SQLN_PROF_SESS... [2018-11-28 07:00:04] Dumping RI QRTZ_CRON_TRIGGERS... [2018-11-28 07:00:04] Dumping RI APPLICATION_ACCESS_BAK... [2018-11-28 07:00:04] Dumping RI QRTZ_SIMPROP_TRIGGERS... [2018-11-28 07:00:04] Dumping RI SMB_TRIGGER_LISTENERS... [2018-11-28 07:00:04] Dumping RI SQLN_PROF_UNITS... [2018-11-28 07:00:04] Dumping RI QRTZ_TRIGGERS... [2018-11-28 07:00:04] Dumping RI ECS_TEMPLATES... [2018-11-28 07:00:04] Dumping RI SQLN_PROF_ANB... [2018-11-28 07:00:04] Dumping constraints to one separate file : CONSTRAINTS_ora2pg_db12c_onemsssguat_ddl_output10.sql [2018-11-28 07:00:04] Dumping foreign keys to one separate file : FKEYS_ora2pg_db12c_onemsssguat_ddl_output10.sql [2018-11-28 07:00:04] Add partitions definition... [2018-11-28 07:00:08] Dumping partition indexes to file : PARTITION_INDEXES_ora2pg_db12c_onemsssguat_ddl_output10.sql [2018-11-28 07:00:08] Add sequences definition... [2018-11-28 07:00:08] Add triggers definition... [2018-11-28 07:00:08] Dumping trigger PLSQL_PROFILER_RUN_OWNER_TRG defined on table PLSQL_PROFILER_RUNS... [2018-11-28 07:00:08] Add procedures definition... [2018-11-28 07:00:08] Dumping function BC_ECSBILRDYNOTIFI... [2018-11-28 07:00:08] Dumping function BILL_READY_PROC... [2018-11-28 07:00:08] Dumping function BILL_READY_PROC_I2K... [2018-11-28 07:00:08] Dumping function BILL_READY_PROC_I2K_MODIFY... [2018-11-28 07:00:08] Dumping function BILL_READY_PROC_VIS... [2018-11-28 07:00:08] Dumping function BILL_READY_PROC_VIS_BCK... [2018-11-28 07:00:08] Dumping function BILL_READY_PROC_VIS_MODIFY... [2018-11-28 07:00:08] Dumping function BILL_READY_VTEXT_REMOVE... [2018-11-28 07:00:08] Dumping function CCES_AUDIT_LOGS_PROC... [2018-11-28 07:00:08] Dumping function CCES_GLOBAL_EMAP... [2018-11-28 07:00:08] Dumping function CHECK_PAYMNTS_PROC... [2018-11-28 07:00:08] Dumping function CREATE_BILL_READY_EMAILS_RPT...

-- WARNING: parameters order has been changed by Ora2Pg to move parameters with default values at end -- Original order was: create_bill_ready_emails_rpt( output_dir text, report_date text DEFAULT TO_CHAR (SYSDATE, 'MM/DD/YYYY') , total_records OUT numeric ) -- You will need to manually reorder parameters in the function calls [2018-11-28 07:00:09] Dumping function CREATE_BILL_REPRINT_REPORT...

-- WARNING: parameters order has been changed by Ora2Pg to move parameters with default values at end -- Original order was: create_bill_reprint_report( output_dir text, report_date text DEFAULT TO_CHAR(SYSDATE, 'MM/DD/YYYY'), total_records OUT numeric ) -- You will need to manually reorder parameters in the function calls [2018-11-28 07:00:09] Dumping function CREATE_SUMM_AUDIT_LOGS... [2018-11-28 07:00:09] Dumping function CREATE_SUMM_AUDIT_LOGS_DETAIL... [2018-11-28 07:00:09] Dumping function CREATE_SUMM_AUDIT_REQUEST... [2018-11-28 07:00:09] Dumping function CREATE_SUMM_CNFM_FATAL_ERRORS... [2018-11-28 07:00:09] Dumping function CREATE_SUMM_CNFM_LETTERS_SUMM... [2018-11-28 07:00:09] Dumping function CREATE_SUMM_CNFM_LETTERS_WFM... [2018-11-28 07:00:09] Dumping function CREATE_SUMM_CNFM_LTRS_TGR_DTLS... [2018-11-28 07:00:09] Dumping function CREATE_SUMM_CONFIRM_LETTERS... [2018-11-28 07:00:09] Dumping function CREATE_SUMM_CPNI_PROCESSING... [2018-11-28 07:00:09] Dumping function CREATE_SUMM_EMAIL... [2018-11-28 07:00:09] Dumping function CREATE_SUMM_MMS... [2018-11-28 07:00:09] Dumping function CREATE_SUMM_PREF_RESPTIME... [2018-11-28 07:00:09] Dumping function CREATE_SUMM_SMS_BATCH... [2018-11-28 07:00:09] Dumping function CREATE_SUMM_SMS_BATCH_DAYHR... [2018-11-28 07:00:09] Dumping function CREATE_SUMM_SMS_MCC... [2018-11-28 07:00:09] Dumping function CREATE_SUMM_SMS_REALTIME... [2018-11-28 07:00:09] Dumping function CREATE_SUMM_SMS_REALTIME_DAYHR... [2018-11-28 07:00:09] Dumping function CREDITCARD_PAYMNTS_PROC... [2018-11-28 07:00:09] Dumping function EMAILINFO_MSG_BYMSGID_PROC... [2018-11-28 07:00:09] Dumping function MONITORRETURNEDBILLREADY... [2018-11-28 07:00:09] Dumping function P10... [2018-11-28 07:00:09] Dumping function PAY_CONFIRM_VTEXT_REMOVE... [2018-11-28 07:00:09] Dumping function P_CREATE_3GDM_WAP_PUSH_FILE... [2018-11-28 07:00:10] Dumping function P_CREATE_BATCH_FALLOUT_FILE... [2018-11-28 07:00:10] Dumping function P_CREATE_CAL_UIMFILE... [2018-11-28 07:00:10] Dumping function P_CREATE_CAL_VISIONREMARKFILE... [2018-11-28 07:00:10] Dumping function P_CREATE_CONFIRM_LTRS_UIM... [2018-11-28 07:00:11] Dumping function P_CREATE_CONSUMER_FALLOUT_FILE... [2018-11-28 07:00:11] Dumping function P_CREATE_CPNI_LTR... [2018-11-28 07:00:11] Dumping function P_CREATE_DATAMETER_FILES... [2018-11-28 07:00:11] Dumping function P_CREATE_GETEMAILADDRESS... [2018-11-28 07:00:11] Dumping function P_CREATE_HIBBERT_FILE... [2018-11-28 07:00:11] Dumping function P_CREATE_IVR_LS_LETTER_FILES... [2018-11-28 07:00:11] Dumping function P_CREATE_LETTER_FILES... [2018-11-28 07:00:12] Dumping function P_CREATE_SOCO_FILE... [2018-11-28 07:00:12] Dumping function P_CREATE_TEST1... [2018-11-28 07:00:12] Dumping function P_DWH_GIFTCARD_FAILEDEMAILS... [2018-11-28 07:00:12] Dumping function P_FETCH_CPNI_BATCH_RECORDS... [2018-11-28 07:00:13] Dumping function P_GLOBAL_EMAP_UPDS_PRC... [2018-11-28 07:00:13] Dumping function P_MONITORRETURNEDEMAILS... [2018-11-28 07:00:13] Dumping function P_TANDCSCANFAILEDMSGS... [2018-11-28 07:00:13] Dumping function P_TANDCSCANFAILEDMSGSESN... [2018-11-28 07:00:13] Dumping function P_TANDCSCANFAILEDMSGS_TEMP... [2018-11-28 07:00:13] Dumping function P_TEMP... [2018-11-28 07:00:13] Dumping function P_UPDATEMYACCT_MTN... [2018-11-28 07:00:13] Dumping function P_UPDATE_OLDEST_MTN... [2018-11-28 07:00:13] Dumping function REFRESH_INFO... [2018-11-28 07:00:13] Dumping function RUN_SUMMARY_PROCS... [2018-11-28 07:00:13] Dumping function SP_TEST... [2018-11-28 07:00:14] Translating of 62 functions took: 6 wallclock secs ( 5.84 usr + 0.00 sys = 5.84 CPU) [2018-11-28 07:00:14] Total time to translate all functions with 1 process: 6 wallclock secs ( 5.84 usr + 0.00 sys = 5.84 CPU) [2018-11-28 07:00:14] Add packages definition... [2018-11-28 07:00:14] Dumping package genfile_pkg... [2018-11-28 07:00:14] Parsing function genfile_pkg.getndmdata... [2018-11-28 07:00:14] Dumping package REPORT01_PKG... [2018-11-28 07:00:14] Parsing function report01_pkg.batchreport... [2018-11-28 07:00:14] Parsing function report01_pkg.auditreport... [2018-11-28 07:00:14] Add synonyms definition... [2018-11-28 07:00:14] Add views definition... [2018-11-28 07:00:14] Adding view MARKETING_MESSAGES... [2018-11-28 07:00:14] Adding view BATCHSMS_MSG... [2018-11-28 07:00:14] Adding view CCC_REPORTING_MESSAGES... [2018-11-28 07:00:14] Adding view CCES_EMAIL_SVC_VIEW... [2018-11-28 07:00:14] Adding view BATCHSMS_MCC_MESSAGES1... [2018-11-28 07:00:14] Adding view MAIL... [2018-11-28 07:00:14] Adding view MYACCTSMS_MESSAGES... [2018-11-28 07:00:14] Adding view V1... [2018-11-28 07:00:14] Adding view BATCHSMS_MCC_MESSAGES... [2018-11-28 07:00:14] Adding view BATCHSMS_MCC_MESSAGES_OLD... [2018-11-28 07:00:14] Adding view CCES_MESSAGES... [2018-11-28 07:00:14] Add users/roles/grants privileges... [2018-11-28 07:00:14] Add functions definition... [2018-11-28 07:00:14] Dumping function IS_ACC_INDEXED... [2018-11-28 07:00:14] Dumping function IS_ACC_INDEXED_BCK... [2018-11-28 07:00:14] Dumping function MOD_RET... [2018-11-28 07:00:14] Dumping function TRUNCATE_CCES_ALLTEL_ACCT... [2018-11-28 07:00:14] Translating of 4 functions took: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) [2018-11-28 07:00:14] Total time to translate all functions with 1 process: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) [2018-11-28 07:00:14] Add custom types definition... [2018-11-28 07:00:14] Add materialized views definition... [2018-11-28 07:00:14] Add dblink definition... [2018-11-28 07:00:14] Add directory definition...

[darold]

The problem with multiple export type is that they use the same output file when it is not prefixed by the object name. Here ora2pg_db12c_pgdb_ddl_output10.sql and default to output.sql.

Commit 6a1d7ec tries to solve this issue by using export type as prefix to the output file, ex: sequence_output.sql or table_output.sql.

IMHO I think this use of multiple export should be deprecated, I really advise to use the project mode:

ora2pg --init_project my_mig_prj
cd my_mig_prj/
[edit config/ora2pg.conf to set the Oracle connection and the schema to export]
sh export_all.sh

Everything will be well stored on disk. With multiple export types everything will go in a single directory.

[buragaddapavan]

Still same issue...

Now output file created as directory_output.sql and it doesn't have all objects specificed in the config file

[darold]

Each export type might have his own dedicated output file, your directory_output.sql file containts only the DIRECTORY objects.

[buragaddapavan]

No... Still same issue...

directory_output.sql file contains table and partition DDL'S

[darold]

I can reproduce the problem but it will not been solved quickly, I really recommend you to use the project mode as explained above.

[darold]

Commit ff453be solves this issue.