GeneratedcolumnscannotbeusedinCOPY

错误如下

DBD::Pg::db do failed: ERROR: column "transtype" is a generated columnsec., avg: 2520 recs/sec), REPORTSINTERMEDIATETABLE in progress.

DETAIL: Generated columns cannot be used in COPY. at /usr/local/share/perl5/Ora2Pg.pm line 15125.

FATAL: ERROR: column "transtype" is a generated column

DETAIL: Generated columns cannot be used in COPY.

Aborting export...

[========================>] 48/48 rows (100.0%) Table REPORT_TRANS (1 sec., 48 recs/sec)

FATAL: _column_attributes() ORA-03113: end-of-file on communication channel, avg: 2518 recs/sec), REPORT_TRANS in progress.

Process ID: 2752

Session ID: 531 Serial number: 41358 (DBD ERROR: OCIStmtExecute/Describe)

Aborting export...

表如下：

CREATE TABLE report_trans (

ctsid varchar(20) NOT NULL,

transid varchar(20),

ctsname varchar(50),

transname varchar(50),

mome varchar(30),

transtype varchar(30) NOT NULL GENERATED ALWAYS AS ('transtype') STORED

) ;

解决方案：

transtype 修改设置为default 'transtype'