search

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
http://www.ora2pg.com/
GNU General Public License v3.0
1.02k stars 343 forks source link

Procedures are Failing with error DBMS_snapshot #977

Open kirandba-hub opened 4 years ago

kirandba-hub commented 4 years ago

Hi,

When i am creating procedures which migrated from the Oracle using Ora2pg,i am getting below error.

gdsrm_sdm=# \i /etc/ora2pg/GDSRM_SDM_Migration/Procedures/SDM_MAT_VIEW_REFRESH3_GDSRM_SDM_procedure.sql SET psql:/etc/ora2pg/GDSRM_SDM_Migration/Procedures/SDM_MAT_VIEW_REFRESH3_GDSRM_SDM_procedure.sql:24: ERROR: syntax error at or near "DBMS_snapshot" LINE 3: DBMS_snapshot.REFRESH('MV_DIM_EVENT_ATTRIB');

Is there any alternative way in postgres to convert the DBMS_Snapshot.Refresh or any other approach is there to create the procedures like this.

Thanks and Regards, Kiran.

darold commented 4 years ago

Need to be fixed, for the moment there is no automatic translation of DBMS_Snapshot.Refresh but this is trivial to fix.