PostgreSQL La base de donnees la plus sophistiquee au monde.

Forums PostgreSQL.fr

Le forum officiel de la communauté francophone de PostgreSQL

Vous n'êtes pas identifié(e).

#1 12/01/2018 15:01:28

ml
Membre

Migration Oracle PgSQL : Erreur d'extraction "Erreur de segmentation"

Bonjour,

Je tente de faire une migration d'un schéma Oracle d'une t'aille d’environ 4,5Go or après plusieurs essais cela plante et toujours au même moment.

Ci-après la log


[root@srvr ora2pg]# ora2pg
[========================>] 320/320 tables (100.0%) end of scanning.
[>                        ]   0/320 tables (0.0%) end of scanning.
[========================>] 320/320 tables (100.0%) end of table export.
[========================>] 0/0 packages (100.0%) end of output.
[========================>] 0/0 rows (100.0%) Table AA_BACC (0 recs/sec)
[>                        ]       0/7268477 total rows (0.0%) - (0 sec., avg: 0 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BARG (0 recs/sec)
[>                        ]       0/7268477 total rows (0.0%) - (0 sec., avg: 0 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BART (0 recs/sec)
[>                        ]       0/7268477 total rows (0.0%) - (0 sec., avg: 0 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BBAP (0 recs/sec)
[>                        ]       0/7268477 total rows (0.0%) - (0 sec., avg: 0 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BCCF (0 recs/sec)
[>                        ]       0/7268477 total rows (0.0%) - (0 sec., avg: 0 recs/sec).
[========================>] 19/19 rows (100.0%) Table AA_BCDP (19 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (0 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BCFO (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (0 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BCOM (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (0 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BCON (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (0 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BDAC (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (0 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BDAV (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (0 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BDCO (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (0 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BDES (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (0 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BEXB (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (0 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BFAC (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BFOU (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BFRA (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BHEX (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BINT (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BLCL (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BLCN (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BLCO (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BLCP (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BLDA (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BLED (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BLEF (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BLEP (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BLFA (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BLFL (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BLIV (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BLLI (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BLLL (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (1 sec., avg: 19 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BLMA (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (2 sec., avg: 9 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BLOC (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (2 sec., avg: 9 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BLSE (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (2 sec., avg: 9 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BMAR (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (2 sec., avg: 9 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BMAU (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (2 sec., avg: 9 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BODC (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (2 sec., avg: 9 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BPCO (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (2 sec., avg: 9 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BRET (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (2 sec., avg: 9 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BSBE (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (2 sec., avg: 9 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BSBQ (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (2 sec., avg: 9 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_BSIT (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (2 sec., avg: 9 recs/sec).
[========================>] 0/0 rows (100.0%) Table AA_WCAF (0 recs/sec)
[>                        ]      19/7268477 total rows (0.0%) - (2 sec., avg: 9 recs/sec).
[========================>] 4755230/4640777 rows (102.5%) Table AB_DEVT (2449 recs/sec)
[===============>         ] 4755249/7268477 total rows (65.4%) - (1943 sec., avg: 2447 recs/sec).
[========================>] 0/0 rows (100.0%) Table AB_HLIG (0 recs/sec)
[===============>         ] 4755249/7268477 total rows (65.4%) - (1943 sec., avg: 2447 recs/sec).
[========================>] 1/1 rows (100.0%) Table AB_ICOM (1 recs/sec)
[===============>         ] 4755250/7268477 total rows (65.4%) - (1943 sec., avg: 2447 recs/sec).
[========================>] 0/0 rows (100.0%) Table AB_IDEC (0 recs/sec)
[===============>         ] 4755250/7268477 total rows (65.4%) - (1943 sec., avg: 2447 recs/sec).
[========================>] 0/0 rows (100.0%) Table AB_IDEM (0 recs/sec)
[===============>         ] 4755250/7268477 total rows (65.4%) - (1943 sec., avg: 2447 recs/sec).
[========================>] 53/53 rows (100.0%) Table AB_IECR (53 recs/sec)
[===============>         ] 4755303/7268477 total rows (65.4%) - (1944 sec., avg: 2446 recs/sec).
[========================>] 0/0 rows (100.0%) Table AB_ILIG (0 recs/sec)
[===============>         ] 4755303/7268477 total rows (65.4%) - (1944 sec., avg: 2446 recs/sec).
[========================>] 16/16 rows (100.0%) Table AB_IMEV (16 recs/sec)
[===============>         ] 4755319/7268477 total rows (65.4%) - (1944 sec., avg: 2446 recs/sec).
[========================>] 12/12 rows (100.0%) Table AB_IMVT (12 recs/sec)
[===============>         ] 4755331/7268477 total rows (65.4%) - (1944 sec., avg: 2446 recs/sec).
[========================>] 58/58 rows (100.0%) Table AB_ISCE (58 recs/sec)
[===============>         ] 4755389/7268477 total rows (65.4%) - (1944 sec., avg: 2446 recs/sec).
[========================>] 11/11 rows (100.0%) Table AB_ISCH (11 recs/sec)
[===============>         ] 4755400/7268477 total rows (65.4%) - (1944 sec., avg: 2446 recs/sec).
[========================>] 1/1 rows (100.0%) Table AB_PCPT (1 recs/sec)
[===============>         ] 4755401/7268477 total rows (65.4%) - (1944 sec., avg: 2446 recs/sec).
[========================>] 474/474 rows (100.0%) Table ACC (474 recs/sec)
[===============>         ] 4755875/7268477 total rows (65.4%) - (1944 sec., avg: 2446 recs/sec).
[========================>] 2/2 rows (100.0%) Table ACD (2 recs/sec)
[===============>         ] 4755877/7268477 total rows (65.4%) - (1944 sec., avg: 2446 recs/sec).
[========================>] 1/1 rows (100.0%) Table ACE (1 recs/sec)
[===============>         ] 4755878/7268477 total rows (65.4%) - (1944 sec., avg: 2446 recs/sec).
[========================>] 0/0 rows (100.0%) Table AFF (0 recs/sec)
[===============>         ] 4755878/7268477 total rows (65.4%) - (1944 sec., avg: 2446 recs/sec).
[========================>] 10/10 rows (100.0%) Table AGT (10 recs/sec)
[===============>         ] 4755888/7268477 total rows (65.4%) - (1944 sec., avg: 2446 recs/sec).
[========================>] 134628/134628 rows (100.0%) Table AMT (1979 recs/sec)
[================>        ] 4890516/7268477 total rows (67.3%) - (2012 sec., avg: 2430 recs/sec).
[========================>] 0/0 rows (100.0%) Table AMT_1FSDP (0 recs/sec)
[================>        ] 4890516/7268477 total rows (67.3%) - (2012 sec., avg: 2430 recs/sec).
[========================>] 0/0 rows (100.0%) Table ANN (0 recs/sec)
[================>        ] 4890516/7268477 total rows (67.3%) - (2012 sec., avg: 2430 recs/sec).
[========================>] 0/0 rows (100.0%) Table APR (0 recs/sec)
[================>        ] 4890516/7268477 total rows (67.3%) - (2012 sec., avg: 2430 recs/sec).
[========================>] 1/1 rows (100.0%) Table APW (1 recs/sec)
[================>        ] 4890517/7268477 total rows (67.3%) - (2012 sec., avg: 2430 recs/sec).
[========================>] 0/0 rows (100.0%) Table AP_IDFI (0 recs/sec)
[================>        ] 4890517/7268477 total rows (67.3%) - (2013 sec., avg: 2429 recs/sec).
[========================>] 0/0 rows (100.0%) Table AP_IFIN (0 recs/sec)
[================>        ] 4890517/7268477 total rows (67.3%) - (2013 sec., avg: 2429 recs/sec).
[========================>] 0/0 rows (100.0%) Table AP_IIMM (0 recs/sec)
[================>        ] 4890517/7268477 total rows (67.3%) - (2013 sec., avg: 2429 recs/sec).
[========================>] 0/0 rows (100.0%) Table AP_IPRG (0 recs/sec)
[================>        ] 4890517/7268477 total rows (67.3%) - (2013 sec., avg: 2429 recs/sec).
[========================>] 1/1 rows (100.0%) Table ASS (1 recs/sec)
[================>        ] 4890518/7268477 total rows (67.3%) - (2013 sec., avg: 2429 recs/sec).
[========================>] 24327/23901 rows (101.8%) Table BC2 (24327 recs/sec)
[================>        ] 4914845/7268477 total rows (67.6%) - (2014 sec., avg: 2440 recs/sec).
[========================>] 24327/24327 rows (100.0%) Table BCO (1158 recs/sec)
[================>        ] 4939172/7268477 total rows (68.0%) - (2035 sec., avg: 2427 recs/sec).
[========================>] 0/0 rows (100.0%) Table BDG (0 recs/sec)
[================>        ] 4939172/7268477 total rows (68.0%) - (2035 sec., avg: 2427 recs/sec).
[========================>] 0/0 rows (100.0%) Table BPH (0 recs/sec)
[================>        ] 4939172/7268477 total rows (68.0%) - (2035 sec., avg: 2427 recs/sec).
[========================>] 0/0 rows (100.0%) Table CAI (0 recs/sec)
[================>        ] 4939172/7268477 total rows (68.0%) - (2035 sec., avg: 2427 recs/sec).
[========================>] 838/838 rows (100.0%) Table CCAMT (838 recs/sec)
[================>        ] 4940010/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 11/11 rows (100.0%) Table CHA (11 recs/sec)
[================>        ] 4940021/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 0/0 rows (100.0%) Table CHL (0 recs/sec)
[================>        ] 4940021/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 2/2 rows (100.0%) Table CIB (2 recs/sec)
[================>        ] 4940023/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 6/6 rows (100.0%) Table CID (6 recs/sec)
[================>        ] 4940029/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 6/6 rows (100.0%) Table CIG (6 recs/sec)
[================>        ] 4940035/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 18/18 rows (100.0%) Table CIP (18 recs/sec)
[================>        ] 4940053/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 470/470 rows (100.0%) Table CLD (470 recs/sec)
[================>        ] 4940523/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 0/0 rows (100.0%) Table CLF (0 recs/sec)
[================>        ] 4940523/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 148/146 rows (101.4%) Table CLG (148 recs/sec)
[================>        ] 4940671/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 0/0 rows (100.0%) Table CMD (0 recs/sec)
[================>        ] 4940671/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 67/67 rows (100.0%) Table CNT (67 recs/sec)
[================>        ] 4940738/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 0/0 rows (100.0%) Table CON (0 recs/sec)
[================>        ] 4940738/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_DFIC (0 recs/sec)
[================>        ] 4940738/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_ECLA (0 recs/sec)
[================>        ] 4940738/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_ECRU (0 recs/sec)
[================>        ] 4940738/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_EEDF (0 recs/sec)
[================>        ] 4940738/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 1/1 rows (100.0%) Table CO_EEDI (1 recs/sec)
[================>        ] 4940739/7268477 total rows (68.0%) - (2036 sec., avg: 2426 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_EELK (0 recs/sec)
[================>        ] 4940739/7268477 total rows (68.0%) - (2037 sec., avg: 2425 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_EERU (0 recs/sec)
[================>        ] 4940739/7268477 total rows (68.0%) - (2037 sec., avg: 2425 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_EEVA (0 recs/sec)
[================>        ] 4940739/7268477 total rows (68.0%) - (2037 sec., avg: 2425 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_EEVE (0 recs/sec)
[================>        ] 4940739/7268477 total rows (68.0%) - (2037 sec., avg: 2425 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_EEVK (0 recs/sec)
[================>        ] 4940739/7268477 total rows (68.0%) - (2037 sec., avg: 2425 recs/sec).
[========================>] 4/4 rows (100.0%) Table CO_EEVP (4 recs/sec)
[================>        ] 4940743/7268477 total rows (68.0%) - (2037 sec., avg: 2425 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_EEXT (0 recs/sec)
[================>        ] 4940743/7268477 total rows (68.0%) - (2037 sec., avg: 2425 recs/sec).
[========================>] 3920/3920 rows (100.0%) Table CO_EKSL (3920 recs/sec)
[================>        ] 4944663/7268477 total rows (68.0%) - (2037 sec., avg: 2427 recs/sec).
[========================>] 155/155 rows (100.0%) Table CO_EKSR (155 recs/sec)
[================>        ] 4944818/7268477 total rows (68.0%) - (2038 sec., avg: 2426 recs/sec).
[========================>] 28/28 rows (100.0%) Table CO_EPRK (28 recs/sec)
[================>        ] 4944846/7268477 total rows (68.0%) - (2038 sec., avg: 2426 recs/sec).
[========================>] 188/188 rows (100.0%) Table CO_EPVA (188 recs/sec)
[================>        ] 4945034/7268477 total rows (68.0%) - (2038 sec., avg: 2426 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PAID (0 recs/sec)
[================>        ] 4945034/7268477 total rows (68.0%) - (2038 sec., avg: 2426 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PAIF (0 recs/sec)
[================>        ] 4945034/7268477 total rows (68.0%) - (2038 sec., avg: 2426 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PASS (0 recs/sec)
[================>        ] 4945034/7268477 total rows (68.0%) - (2038 sec., avg: 2426 recs/sec).
[========================>] 5316/5316 rows (100.0%) Table CO_PCHP (2658 recs/sec)
[================>        ] 4950350/7268477 total rows (68.1%) - (2040 sec., avg: 2426 recs/sec).
[========================>] 134/134 rows (100.0%) Table CO_PCOM (134 recs/sec)
[================>        ] 4950484/7268477 total rows (68.1%) - (2040 sec., avg: 2426 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PCRP (0 recs/sec)
[================>        ] 4950484/7268477 total rows (68.1%) - (2040 sec., avg: 2426 recs/sec).
[========================>] 13/13 rows (100.0%) Table CO_PDEV (13 recs/sec)
[================>        ] 4950497/7268477 total rows (68.1%) - (2040 sec., avg: 2426 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PDFI (0 recs/sec)
[================>        ] 4950497/7268477 total rows (68.1%) - (2040 sec., avg: 2426 recs/sec).
[========================>] 6517/6517 rows (100.0%) Table CO_PDIC (1629 recs/sec)
[================>        ] 4957014/7268477 total rows (68.2%) - (2044 sec., avg: 2425 recs/sec).
[========================>] 375/375 rows (100.0%) Table CO_PDSP (375 recs/sec)
[================>        ] 4957389/7268477 total rows (68.2%) - (2044 sec., avg: 2425 recs/sec).
[========================>] 132/132 rows (100.0%) Table CO_PDST (132 recs/sec)
[================>        ] 4957521/7268477 total rows (68.2%) - (2044 sec., avg: 2425 recs/sec).
[========================>] 128/128 rows (100.0%) Table CO_PDTB (128 recs/sec)
[================>        ] 4957649/7268477 total rows (68.2%) - (2044 sec., avg: 2425 recs/sec).
[========================>] 24/24 rows (100.0%) Table CO_PDTC (24 recs/sec)
[================>        ] 4957673/7268477 total rows (68.2%) - (2044 sec., avg: 2425 recs/sec).
[========================>] 2/2 rows (100.0%) Table CO_PDTL (2 recs/sec)
[================>        ] 4957675/7268477 total rows (68.2%) - (2044 sec., avg: 2425 recs/sec).
[========================>] 102/102 rows (100.0%) Table CO_PDTM (102 recs/sec)
[================>        ] 4957777/7268477 total rows (68.2%) - (2044 sec., avg: 2425 recs/sec).
[========================>] 17/17 rows (100.0%) Table CO_PEFI (17 recs/sec)
[================>        ] 4957794/7268477 total rows (68.2%) - (2044 sec., avg: 2425 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PEMA (0 recs/sec)
[================>        ] 4957794/7268477 total rows (68.2%) - (2044 sec., avg: 2425 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PERM (0 recs/sec)
[================>        ] 4957794/7268477 total rows (68.2%) - (2044 sec., avg: 2425 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PESE (0 recs/sec)
[================>        ] 4957794/7268477 total rows (68.2%) - (2044 sec., avg: 2425 recs/sec).
[========================>] 24/24 rows (100.0%) Table CO_PETC (24 recs/sec)
[================>        ] 4957818/7268477 total rows (68.2%) - (2044 sec., avg: 2425 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PETR (0 recs/sec)
[================>        ] 4957818/7268477 total rows (68.2%) - (2044 sec., avg: 2425 recs/sec).
[========================>] 195/195 rows (100.0%) Table CO_PFCM (195 recs/sec)
[================>        ] 4958013/7268477 total rows (68.2%) - (2045 sec., avg: 2424 recs/sec).
[========================>] 30/30 rows (100.0%) Table CO_PFCP (30 recs/sec)
[================>        ] 4958043/7268477 total rows (68.2%) - (2045 sec., avg: 2424 recs/sec).
[========================>] 99/99 rows (100.0%) Table CO_PFCT (99 recs/sec)
[================>        ] 4958142/7268477 total rows (68.2%) - (2045 sec., avg: 2424 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PFDB (0 recs/sec)
[================>        ] 4958142/7268477 total rows (68.2%) - (2045 sec., avg: 2424 recs/sec).
[========================>] 1/1 rows (100.0%) Table CO_PFMT (1 recs/sec)
[================>        ] 4958143/7268477 total rows (68.2%) - (2045 sec., avg: 2424 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PHAB (0 recs/sec)
[================>        ] 4958143/7268477 total rows (68.2%) - (2045 sec., avg: 2424 recs/sec).
[========================>] 8/8 rows (100.0%) Table CO_PHMO (8 recs/sec)
[================>        ] 4958151/7268477 total rows (68.2%) - (2045 sec., avg: 2424 recs/sec).
[========================>] 3/3 rows (100.0%) Table CO_PLAN (3 recs/sec)
[================>        ] 4958154/7268477 total rows (68.2%) - (2045 sec., avg: 2424 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PLAS (0 recs/sec)
[================>        ] 4958154/7268477 total rows (68.2%) - (2045 sec., avg: 2424 recs/sec).
[========================>] 152/152 rows (100.0%) Table CO_PLFK (152 recs/sec)
[================>        ] 4958306/7268477 total rows (68.2%) - (2045 sec., avg: 2424 recs/sec).
[========================>] 25353/25245 rows (100.4%) Table CO_PLIB (6338 recs/sec)
[================>        ] 4983659/7268477 total rows (68.6%) - (2049 sec., avg: 2432 recs/sec).
[========================>] 821/821 rows (100.0%) Table CO_PLNK (821 recs/sec)
[================>        ] 4984480/7268477 total rows (68.6%) - (2049 sec., avg: 2432 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PLRM (0 recs/sec)
[================>        ] 4984480/7268477 total rows (68.6%) - (2049 sec., avg: 2432 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PLSE (0 recs/sec)
[================>        ] 4984480/7268477 total rows (68.6%) - (2049 sec., avg: 2432 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PLTR (0 recs/sec)
[================>        ] 4984480/7268477 total rows (68.6%) - (2049 sec., avg: 2432 recs/sec).
[========================>] 18/18 rows (100.0%) Table CO_PMAC (18 recs/sec)
[================>        ] 4984498/7268477 total rows (68.6%) - (2049 sec., avg: 2432 recs/sec).
[========================>] 1695/1695 rows (100.0%) Table CO_PMEN (1695 recs/sec)
[================>        ] 4986193/7268477 total rows (68.6%) - (2049 sec., avg: 2433 recs/sec).
[========================>] 1627/1627 rows (100.0%) Table CO_PMES (1627 recs/sec)
[================>        ] 4987820/7268477 total rows (68.6%) - (2050 sec., avg: 2433 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PMMD (0 recs/sec)
[================>        ] 4987820/7268477 total rows (68.6%) - (2050 sec., avg: 2433 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PMME (0 recs/sec)
[================>        ] 4987820/7268477 total rows (68.6%) - (2050 sec., avg: 2433 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PMNC (0 recs/sec)
[================>        ] 4987820/7268477 total rows (68.6%) - (2050 sec., avg: 2433 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PMNT (0 recs/sec)
[================>        ] 4987820/7268477 total rows (68.6%) - (2050 sec., avg: 2433 recs/sec).
[========================>] 15/15 rows (100.0%) Table CO_PMOD (15 recs/sec)
[================>        ] 4987835/7268477 total rows (68.6%) - (2050 sec., avg: 2433 recs/sec).
[========================>] 58/58 rows (100.0%) Table CO_PMRU (58 recs/sec)
[================>        ] 4987893/7268477 total rows (68.6%) - (2050 sec., avg: 2433 recs/sec).
[========================>] 12/12 rows (100.0%) Table CO_PNUM (12 recs/sec)
[================>        ] 4987905/7268477 total rows (68.6%) - (2050 sec., avg: 2433 recs/sec).
[========================>] 559/559 rows (100.0%) Table CO_POCC (559 recs/sec)
[================>        ] 4988464/7268477 total rows (68.6%) - (2050 sec., avg: 2433 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_POCR (0 recs/sec)
[================>        ] 4988464/7268477 total rows (68.6%) - (2050 sec., avg: 2433 recs/sec).
[========================>] 1/1 rows (100.0%) Table CO_PPNI (1 recs/sec)
[================>        ] 4988465/7268477 total rows (68.6%) - (2050 sec., avg: 2433 recs/sec).
[========================>] 2/2 rows (100.0%) Table CO_PPRD (2 recs/sec)
[================>        ] 4988467/7268477 total rows (68.6%) - (2051 sec., avg: 2432 recs/sec).
[========================>] 2/2 rows (100.0%) Table CO_PPRF (2 recs/sec)
[================>        ] 4988469/7268477 total rows (68.6%) - (2051 sec., avg: 2432 recs/sec).
[========================>] 3477/3477 rows (100.0%) Table CO_PREQ (3477 recs/sec)
[================>        ] 4991946/7268477 total rows (68.7%) - (2051 sec., avg: 2433 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PRFP (0 recs/sec)
[================>        ] 4991946/7268477 total rows (68.7%) - (2052 sec., avg: 2432 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PRFU (0 recs/sec)
[================>        ] 4991946/7268477 total rows (68.7%) - (2052 sec., avg: 2432 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PRGP (0 recs/sec)
[================>        ] 4991946/7268477 total rows (68.7%) - (2052 sec., avg: 2432 recs/sec).
[========================>] 3603/3603 rows (100.0%) Table CO_PRTB (3603 recs/sec)
[================>        ] 4995549/7268477 total rows (68.7%) - (2052 sec., avg: 2434 recs/sec).
[========================>] 162/162 rows (100.0%) Table CO_PRTL (162 recs/sec)
[================>        ] 4995711/7268477 total rows (68.7%) - (2052 sec., avg: 2434 recs/sec).
[========================>] 19/19 rows (100.0%) Table CO_PSEL (19 recs/sec)
[================>        ] 4995730/7268477 total rows (68.7%) - (2052 sec., avg: 2434 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PSRU (0 recs/sec)
[================>        ] 4995730/7268477 total rows (68.7%) - (2052 sec., avg: 2434 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PSVA (0 recs/sec)
[================>        ] 4995730/7268477 total rows (68.7%) - (2052 sec., avg: 2434 recs/sec).
[========================>] 98/98 rows (100.0%) Table CO_PTAB (98 recs/sec)
[================>        ] 4995828/7268477 total rows (68.7%) - (2053 sec., avg: 2433 recs/sec).
[========================>] 1/1 rows (100.0%) Table CO_PUTI (1 recs/sec)
[================>        ] 4995829/7268477 total rows (68.7%) - (2053 sec., avg: 2433 recs/sec).
[========================>] 0/0 rows (100.0%) Table CO_PWFE (0 recs/sec)
[================>        ] 4995829/7268477 total rows (68.7%) - (2053 sec., avg: 2433 recs/sec).
[========================>] 37/37 rows (100.0%) Table CPT (37 recs/sec)
[================>        ] 4995866/7268477 total rows (68.7%) - (2053 sec., avg: 2433 recs/sec).
[========================>] 0/0 rows (100.0%) Table CRA (0 recs/sec)
[================>        ] 4995866/7268477 total rows (68.7%) - (2053 sec., avg: 2433 recs/sec).
[=======================> ] 23536/23967 rows (98.2%) Table CRD (11768 recs/sec)
[================>        ] 5019402/7268477 total rows (69.1%) - (2055 sec., avg: 2442 recs/sec).
[========================>] 0/0 rows (100.0%) Table CRE (0 recs/sec)
[================>        ] 5019402/7268477 total rows (69.1%) - (2055 sec., avg: 2442 recs/sec).
[========================>] 9537/9516 rows (100.2%) Table CRG (9537 recs/sec)
[================>        ] 5028939/7268477 total rows (69.2%) - (2055 sec., avg: 2447 recs/sec).
[========================>] 0/0 rows (100.0%) Table CSA (0 recs/sec)
[================>        ] 5028939/7268477 total rows (69.2%) - (2055 sec., avg: 2447 recs/sec).
[========================>] 0/0 rows (100.0%) Table DEM (0 recs/sec)
[================>        ] 5028939/7268477 total rows (69.2%) - (2055 sec., avg: 2447 recs/sec).
[========================>] 12/12 rows (100.0%) Table DEV (12 recs/sec)
[================>        ] 5028951/7268477 total rows (69.2%) - (2055 sec., avg: 2447 recs/sec).
[========================>] 10398/10398 rows (100.0%) Table DIC (5199 recs/sec)
[================>        ] 5039349/7268477 total rows (69.3%) - (2057 sec., avg: 2449 recs/sec).
[========================>] 10/10 rows (100.0%) Table DLF (10 recs/sec)
[================>        ] 5039359/7268477 total rows (69.3%) - (2057 sec., avg: 2449 recs/sec).
[========================>] 376/367 rows (102.5%) Table DME (376 recs/sec)
[================>        ] 5039735/7268477 total rows (69.3%) - (2057 sec., avg: 2450 recs/sec).
[========================>] 0/0 rows (100.0%) Table DMI (0 recs/sec)
[================>        ] 5039735/7268477 total rows (69.3%) - (2057 sec., avg: 2450 recs/sec).
[========================>] 7446/7446 rows (100.0%) Table DRT (7446 recs/sec)
[================>        ] 5047181/7268477 total rows (69.4%) - (2058 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table DSB (0 recs/sec)
[================>        ] 5047181/7268477 total rows (69.4%) - (2058 sec., avg: 2452 recs/sec).
[========================>] 70/69 rows (101.4%) Table DTM (70 recs/sec)
[================>        ] 5047251/7268477 total rows (69.4%) - (2058 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EAT (0 recs/sec)
[================>        ] 5047251/7268477 total rows (69.4%) - (2058 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table ECA (0 recs/sec)
[================>        ] 5047251/7268477 total rows (69.4%) - (2058 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table ECL (0 recs/sec)
[================>        ] 5047251/7268477 total rows (69.4%) - (2058 sec., avg: 2452 recs/sec).
[========================>] 4893/4872 rows (100.4%) Table EDD (4893 recs/sec)
[================>        ] 5052144/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 287/285 rows (100.7%) Table EDG (287 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BAPT (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BCAT (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BCMD (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BEXB (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BIND (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BLAA (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BLAB (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BLAI (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BLAP (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BLAS (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BLCA (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BLCF (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BLCP (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BLDA (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BLPC (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BNET (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BNET_W (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BNPL (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BNPL_W (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BNPR (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BNPR_W (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BPAR (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EP_BPRO (0 recs/sec)
[================>        ] 5052431/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 99/99 rows (100.0%) Table ETB (99 recs/sec)
[================>        ] 5052530/7268477 total rows (69.5%) - (2060 sec., avg: 2452 recs/sec).
[========================>] 0/0 rows (100.0%) Table EXB (0 recs/sec)
[================>        ] 5052530/7268477 total rows (69.5%) - (2061 sec., avg: 2451 recs/sec).
[========================>] 629/629 rows (100.0%) Table EXE (629 recs/sec)
[================>        ] 5053159/7268477 total rows (69.5%) - (2061 sec., avg: 2451 recs/sec).
[========================>] 0/0 rows (100.0%) Table EXP (0 recs/sec)
[================>        ] 5053159/7268477 total rows (69.5%) - (2061 sec., avg: 2451 recs/sec).
[========================>] 0/0 rows (100.0%) Table EX_DDSO (0 recs/sec)
[================>        ] 5053159/7268477 total rows (69.5%) - (2061 sec., avg: 2451 recs/sec).
[========================>] 0/0 rows (100.0%) Table EX_DDST (0 recs/sec)
[================>        ] 5053159/7268477 total rows (69.5%) - (2061 sec., avg: 2451 recs/sec).
[========================>] 0/0 rows (100.0%) Table EX_DESO (0 recs/sec)
[================>        ] 5053159/7268477 total rows (69.5%) - (2061 sec., avg: 2451 recs/sec).
[========================>] 0/0 rows (100.0%) Table EX_DEST (0 recs/sec)
[================>        ] 5053159/7268477 total rows (69.5%) - (2061 sec., avg: 2451 recs/sec).
[========================>] 28/28 rows (100.0%) Table EX_PBAT (28 recs/sec)
[================>        ] 5053187/7268477 total rows (69.5%) - (2061 sec., avg: 2451 recs/sec).
[========================>] 4/4 rows (100.0%) Table EX_PENV (4 recs/sec)
[================>        ] 5053191/7268477 total rows (69.5%) - (2061 sec., avg: 2451 recs/sec).
[========================>] 0/0 rows (100.0%) Table EX_WCRE (0 recs/sec)
[================>        ] 5053191/7268477 total rows (69.5%) - (2061 sec., avg: 2451 recs/sec).
[========================>] 0/0 rows (100.0%) Table FIN (0 recs/sec)
[================>        ] 5053191/7268477 total rows (69.5%) - (2061 sec., avg: 2451 recs/sec).
[========================>] 26/26 rows (100.0%) Table FIT (26 recs/sec)
[================>        ] 5053217/7268477 total rows (69.5%) - (2061 sec., avg: 2451 recs/sec).
[========================>] 74/74 rows (100.0%) Table FLX (74 recs/sec)
[================>        ] 5053291/7268477 total rows (69.5%) - (2061 sec., avg: 2451 recs/sec).
[========================>] 0/0 rows (100.0%) Table GRD (0 recs/sec)
[================>        ] 5053291/7268477 total rows (69.5%) - (2061 sec., avg: 2451 recs/sec).
[========================>] 0/0 rows (100.0%) Table GRG (0 recs/sec)
[================>        ] 5053291/7268477 total rows (69.5%) - (2061 sec., avg: 2451 recs/sec).
[========================>] 1507571/1482308 rows (101.7%) Table HIS (3263 recs/sec)
[=====================>   ] 6560862/7268477 total rows (90.3%) - (2523 sec., avg: 2600 recs/sec).
[=======================> ] 63538/63619 rows (99.9%) Table HIS_AMT (7942 recs/sec)
[=====================>   ] 6624400/7268477 total rows (91.1%) - (2531 sec., avg: 2617 recs/sec).
[========================>] 12798/12798 rows (100.0%) Table HIS_BCO (6399 recs/sec)
[=====================>   ] 6637198/7268477 total rows (91.3%) - (2533 sec., avg: 2620 recs/sec).
[========================>] 0/0 rows (100.0%) Table HIS_BDG (0 recs/sec)
[=====================>   ] 6637198/7268477 total rows (91.3%) - (2533 sec., avg: 2620 recs/sec).
[========================>] 0/0 rows (100.0%) Table HIS_BPH (0 recs/sec)
[=====================>   ] 6637198/7268477 total rows (91.3%) - (2533 sec., avg: 2620 recs/sec).
[========================>] 0/0 rows (100.0%) Table HIS_CAI (0 recs/sec)
[=====================>   ] 6637198/7268477 total rows (91.3%) - (2533 sec., avg: 2620 recs/sec).
[========================>] 0/0 rows (100.0%) Table HIS_CHA (0 recs/sec)
[=====================>   ] 6637198/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 0/0 rows (100.0%) Table HIS_CMD (0 recs/sec)
[=====================>   ] 6637198/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 35/35 rows (100.0%) Table HIS_CNT (35 recs/sec)
[=====================>   ] 6637233/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 0/0 rows (100.0%) Table HIS_CRE (0 recs/sec)
[=====================>   ] 6637233/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 0/0 rows (100.0%) Table HIS_DEM (0 recs/sec)
[=====================>   ] 6637233/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 12/12 rows (100.0%) Table HIS_DEV (12 recs/sec)
[=====================>   ] 6637245/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 747/747 rows (100.0%) Table HIS_DIC (747 recs/sec)
[=====================>   ] 6637992/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 0/0 rows (100.0%) Table HIS_DMI (0 recs/sec)
[=====================>   ] 6637992/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 11/11 rows (100.0%) Table HIS_DZE (11 recs/sec)
[=====================>   ] 6638003/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 0/0 rows (100.0%) Table HIS_FIN (0 recs/sec)
[=====================>   ] 6638003/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 0/0 rows (100.0%) Table HIS_LIV (0 recs/sec)
[=====================>   ] 6638003/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 0/0 rows (100.0%) Table HIS_NV1 (0 recs/sec)
[=====================>   ] 6638003/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 0/0 rows (100.0%) Table HIS_NV2 (0 recs/sec)
[=====================>   ] 6638003/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 66/66 rows (100.0%) Table HIS_PAR (66 recs/sec)
[=====================>   ] 6638069/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 0/0 rows (100.0%) Table HIS_PBG (0 recs/sec)
[=====================>   ] 6638069/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 0/0 rows (100.0%) Table HIS_PCE (0 recs/sec)
[=====================>   ] 6638069/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 0/0 rows (100.0%) Table HIS_PLN (0 recs/sec)
[=====================>   ] 6638069/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 20/20 rows (100.0%) Table HIS_SOC (20 recs/sec)
[=====================>   ] 6638089/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 0/0 rows (100.0%) Table HIS_SUB (0 recs/sec)
[=====================>   ] 6638089/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 0/0 rows (100.0%) Table HIS_UGB (0 recs/sec)
[=====================>   ] 6638089/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 1/1 rows (100.0%) Table IC1 (1 recs/sec)
[=====================>   ] 6638090/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 103/103 rows (100.0%) Table IC2 (103 recs/sec)
[=====================>   ] 6638193/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 5/5 rows (100.0%) Table IC3 (5 recs/sec)
[=====================>   ] 6638198/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 21/21 rows (100.0%) Table IC4 (21 recs/sec)
[=====================>   ] 6638219/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 14/14 rows (100.0%) Table IC5 (14 recs/sec)
[=====================>   ] 6638233/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[========================>] 599/599 rows (100.0%) Table IC6 (599 recs/sec)
[=====================>   ] 6638832/7268477 total rows (91.3%) - (2534 sec., avg: 2619 recs/sec).
[=======================> ] 2559/2581 rows (99.1%) Table IC7 (2559 recs/sec)
[=====================>   ] 6641391/7268477 total rows (91.4%) - (2536 sec., avg: 2618 recs/sec).
[========================>] 344/344 rows (100.0%) Table IC8 (344 recs/sec)
[=====================>   ] 6641735/7268477 total rows (91.4%) - (2536 sec., avg: 2618 recs/sec).
[========================>] 0/0 rows (100.0%) Table LCB (0 recs/sec)
[=====================>   ] 6641735/7268477 total rows (91.4%) - (2536 sec., avg: 2618 recs/sec).
[========================>] 0/0 rows (100.0%) Table LCP (0 recs/sec)
[=====================>   ] 6641735/7268477 total rows (91.4%) - (2536 sec., avg: 2618 recs/sec).
[========================>] 5327/5327 rows (100.0%) Table LIB (5327 recs/sec)
[=====================>   ] 6647062/7268477 total rows (91.5%) - (2536 sec., avg: 2621 recs/sec).
[========================>] 0/0 rows (100.0%) Table LIV (0 recs/sec)
[=====================>   ] 6647062/7268477 total rows (91.5%) - (2536 sec., avg: 2621 recs/sec).
[========================>] 154/154 rows (100.0%) Table MAC (154 recs/sec)
[=====================>   ] 6647216/7268477 total rows (91.5%) - (2536 sec., avg: 2621 recs/sec).
[========================>] 1695/1695 rows (100.0%) Table MCD (1695 recs/sec)
[=====================>   ] 6648911/7268477 total rows (91.5%) - (2537 sec., avg: 2620 recs/sec).
[========================>] 159/159 rows (100.0%) Table MCG (159 recs/sec)
[=====================>   ] 6649070/7268477 total rows (91.5%) - (2537 sec., avg: 2620 recs/sec).
[========================>] 0/0 rows (100.0%) Table MII (0 recs/sec)
[=====================>   ] 6649070/7268477 total rows (91.5%) - (2537 sec., avg: 2620 recs/sec).
[========================>] 34/34 rows (100.0%) Table MOD (34 recs/sec)
[=====================>   ] 6649104/7268477 total rows (91.5%) - (2537 sec., avg: 2620 recs/sec).
[========================>] 176/174 rows (101.1%) Table MPE (176 recs/sec)
[=====================>   ] 6649280/7268477 total rows (91.5%) - (2537 sec., avg: 2620 recs/sec).
[========================>] 0/0 rows (100.0%) Table MPR (0 recs/sec)
[=====================>   ] 6649280/7268477 total rows (91.5%) - (2537 sec., avg: 2620 recs/sec).
[========================>] 0/0 rows (100.0%) Table MXX (0 recs/sec)
[=====================>   ] 6649280/7268477 total rows (91.5%) - (2537 sec., avg: 2620 recs/sec).
[========================>] 32/32 rows (100.0%) Table NUA (32 recs/sec)
[=====================>   ] 6649312/7268477 total rows (91.5%) - (2537 sec., avg: 2620 recs/sec).
[========================>] 0/0 rows (100.0%) Table NV1 (0 recs/sec)
[=====================>   ] 6649312/7268477 total rows (91.5%) - (2537 sec., avg: 2620 recs/sec).
[========================>] 0/0 rows (100.0%) Table NV2 (0 recs/sec)
[=====================>   ] 6649312/7268477 total rows (91.5%) - (2537 sec., avg: 2620 recs/sec).
Erreur de segmentation>   ] 6509538/7268477 rows (89.6%) on total estimated data (2537 sec., avg: 2565 recs/sec)


J'ai déjà fais une migration d'un schéma plus petit 29Mo et cela a fonctionné sans problème..

Serait-ce dû à une micro coupure réseaux ? J'ai des doutes car cela plante exactement au même endroit ? La dernière ligne est identique :
Erreur de segmentation>   ] 6509538/7268477 rows (89.6%) on total estimated data (2537 sec., avg: 2565 recs/sec)

Merci pour vos lumières !  smile

Dernière modification par ml (15/01/2018 11:17:26)

Hors ligne

#2 12/01/2018 17:51:59

ml
Membre

Re : Migration Oracle PgSQL : Erreur d'extraction "Erreur de segmentation"

Aucunes idées ?  sad  sad

Hors ligne

#3 12/01/2018 18:26:00

gleu
Administrateur

Re : Migration Oracle PgSQL : Erreur d'extraction "Erreur de segmentation"

Comme l'erreur est un segfault, peu de chance que ça provienne d'ora2pg. Ça peut être soit une mauvaise installation, soit un problème avec le driver oracle.

Hors ligne

#4 12/01/2018 18:38:49

ml
Membre

Re : Migration Oracle PgSQL : Erreur d'extraction "Erreur de segmentation"

Merci pour ton retour, je trouve cela néanmoins curieux car j'utilise le même Ora2pg installé lors de ma précédente migration.
Si il y avait une mauvaise installation, ça ne planterait pas dès le début ??
Je vais refaire la migration du schéma précédent pour vérifier ..

Dernière modification par ml (12/01/2018 18:40:20)

Hors ligne

#5 15/01/2018 11:17:00

ml
Membre

Re : Migration Oracle PgSQL : Erreur d'extraction "Erreur de segmentation"

gleu a écrit :

Comme l'erreur est un segfault, peu de chance que ça provienne d'ora2pg. Ça peut être soit une mauvaise installation, soit un problème avec le driver oracle.

Bonjour


je viens d'effectuer un test avec le schéma et il n'y aucun problème cela fonctionne très bien.


[root@srv ora2pg]# ora2pg
[========================>] 8/8 tables (100.0%) end of scanning.
[>                        ] 0/8 tables (0.0%) end of scanning.
[========================>] 8/8 tables (100.0%) end of table export.
[========================>] 0/0 packages (100.0%) end of output.
[========================>] 671/656 rows (102.3%) Table CORIM_DOCNUM_LOGAPP (671 recs/sec)
[>                        ]    671/342316 total rows (0.2%) - (0 sec., avg: 671 recs/sec).
[========================>] 2258/2229 rows (101.3%) Table CORIM_FILE_LOGAPP (2258 recs/sec)
[>                        ]   2929/342316 total rows (0.9%) - (0 sec., avg: 2929 recs/sec).
[========================>] 2885/2687 rows (107.4%) Table CORIM_IDOC_LOGAPP (2885 recs/sec)
[>                        ]   5814/342316 total rows (1.7%) - (1 sec., avg: 5814 recs/sec).
[========================>] 6/6 rows (100.0%) Table REF_PHASE_LOGAPP (6 recs/sec)
[>                        ]   5820/342316 total rows (1.7%) - (1 sec., avg: 5820 recs/sec).
[========================>] 290022/287926 rows (100.7%) Table RUN_PHASE_LOGAPP (48337 recs/sec)
[====================>    ] 295842/342316 total rows (86.4%) - (7 sec., avg: 42263 recs/sec).
[========================>] 50839/48812 rows (104.2%) Table RUN_SAP_LOGAPP (10167 recs/sec)
[========================>] 346681/342316 total rows (101.3%) - (12 sec., avg: 28890 recs/sec).
[========================>] 0/0 rows (100.0%) Table TMP1_MSEG (0 recs/sec)
[========================>] 346681/342316 total rows (101.3%) - (12 sec., avg: 28890 recs/sec).
[========================>] 0/0 rows (100.0%) Table TMP2_MSEG (0 recs/sec)
[========================>] 346681/342316 total rows (101.3%) - (12 sec., avg: 28890 recs/sec).
[========================>] 342316/342316 rows (100.0%) on total estimated data (12 sec., avg: 28526 recs/sec)
[========================>] 0/0 views (100.0%) end of output.
[========================>] 0/0 sequences (100.0%) end of output.
[========================>] 1/1 triggers (100.0%) end of output.
[========================>] 0/0 functions (100.0%) end of functions export.
[========================>] 1/1 procedures (100.0%) end of procedures export.
[========================>] 0/0 types (100.0%) end of output.
[========================>] 0/0 partitions (100.0%) end of output.


L'installation est donc correcte.



Auriez-vous une autre idée ?

Hors ligne

#6 15/01/2018 16:55:01

rjuju
Administrateur

Re : Migration Oracle PgSQL : Erreur d'extraction "Erreur de segmentation"

Y a-t-il plus de logs générés quelques part ? Pourriez-vous obtenir une stacktrace du processus ?  Quelle version de perl utilisez-vous ?  Je suppose que le problème est dû à des données spécifiques dans la table qui suit NV2.  Pouvez-vous voir si tenter la migration de cette table uniquement reproduit bien le problème, et si vous pouvez identifier dans celle-ci des données non conventionnelles ?

Hors ligne

Pied de page des forums