Ora2pg data conversion issue while exporting the Data.

Open Purushotham2728 opened this issue 1 year ago • 1 comments

DBD::pg:: db pg_putcopyend failed :ERROR: invalid byte sequence for encoding "UTF8": 0x00vg : 11 recs/sec Context: copy content, line 1 at /usr/local/share/perl5/Ora2pg.pm line 16849 FATAL : ERROR : invalid byte sequence for encoding "UTF8": 0x00

Sep 18 '24 11:09 Purushotham2728

You should use the same encoding as defined in Oracle. Use action -t SHOW_ENCODING to show Oracle encoding and adjust NLS_* configuration directives in ora2pg.conf

Sep 18 '24 13:09 darold