ora2pg FATAL: _column_info() ORA-00904: "ST_SRID": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 7 in 'SELECT <*>ST

FATAL: _column_info() ORA-00904: "ST_SRID": invalid identifier (DBD ERROR: error possibly near <> indicator at char 7 in 'SELECT <>ST_SRID(c.SHAPE) FROM GIS.YIJILU c')

Open 339131041 opened this issue 2 years ago • 1 comments

ora2pg -b /root/oracle2pg -d -c ora2pg_oracle.conf

FATAL: _column_info() ORA-00904: "ST_SRID": invalid identifier (DBD ERROR: error possibly near <> indicator at char 7 in 'SELECT <>ST_SRID(c.SHAPE) FROM GIS.YIJILU c') DBI::db=HASH(0x1013c80)->disconnect invalidates 2 active statement handles (either destroy statement handles or call finish on them before disconnecting) at /usr/local/share/perl5/Ora2Pg.pm line 14084. Aborting export...

error in latest development code

Sep 13 '22 02:09 339131041

Sorry for the response delay, what is the datatype of the column? A DESC of the table could help. Thanks.

Sep 22 '22 15:09 darold

I faced a similar problem and the difference with tables that were successfully migrated is that the SHAPE field appears, the data type is ST_GEOMETRY. I created a question with a detailed description of my problem (Converting ArcSDE geometry (ST_GEOMETRY) to Postgresql geometry, who has encountered and can help, please unsubscribe. #1528).

Oct 18 '22 11:10 Albert88373

Might be fixed using instruction here https://github.com/darold/ora2pg/issues/1528#issuecomment-1294925035

Oct 29 '22 11:10 darold

ora2pg ora2pg copied to clipboard

FATAL: _column_info() ORA-00904: "ST_SRID": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 7 in 'SELECT <*>ST_SRID(c.SHAPE) FROM GIS.YIJILU c')

ora2pg
ora2pg copied to clipboard

FATAL: _column_info() ORA-00904: "ST_SRID": invalid identifier (DBD ERROR: error possibly near <> indicator at char 7 in 'SELECT <>ST_SRID(c.SHAPE) FROM GIS.YIJILU c')