[Tap-Oracle]
Annyone faced that?
I've tryng use lo...
# singer-tapsj
jusolu_coperfield_borges_luz
09/04/2024, 8:05 PM[Tap-Oracle]
Annyone faced that?
I've tryng use log based with oracle tap, but when I try run that error is returned->
PLS-00201: identifier 'DBMS_LOGMNR' must be declared2024-09-04T20:01:20.289120Z [info ] time=2024-09-04 16:01:20 name=singer level=INFO message=supplemental log level for table(E070EMP): ('SAPIENS', 'SYS_C0016837942', 'E070EMP', 'ALL COLUMN LOGGING', 'ALWAYS', 'GENERATED NAME') cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.312088Z [info ] time=2024-09-04 16:01:20 name=singer level=INFO message=Starting LogMiner for ['SAPIENS-E070EMP']: 86922550370 -> 86922671403 cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.312088Z [info ] time=2024-09-04 16:01:20 name=singer level=INFO message=BEGIN cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.312088Z [info ] DBMS_LOGMNR.START_LOGMNR( cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.313093Z [info ] startScn => 86922550370, cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.313093Z [info ] endScn => 86922671403, cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.313093Z [info ] OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.313093Z [info ] DBMS_LOGMNR.COMMITTED_DATA_ONLY + cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.314093Z [info ] DBMS_LOGMNR.CONTINUOUS_MINE); cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.314093Z [info ] END; cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.560926Z [info ] time=2024-09-04 16:01:20 name=singer level=CRITICAL message=ORA-00900: invalid SQL statement cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.561913Z [info ] Traceback (most recent call last): cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.561913Z [info ] File "C:\meltano_oracle\teste_oracle\.meltano\extractors\tap-oracle\venv\Lib\site-packages\tap_oracle\sync_strategies\log_miner.py", line 141, in sync_tables cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.561913Z [info ] state = sync_tables_logminer(cur, streams, state, start_scn_window, stop_scn_window) cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.562922Z [info ] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.562922Z [info ] File "C:\meltano_oracle\teste_oracle\.meltano\extractors\tap-oracle\venv\Lib\site-packages\tap_oracle\sync_strategies\log_miner.py", line 188, in sync_tables_logminer cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.563921Z [info ] cur.execute(start_logmnr_sql) cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.563921Z [info ] cx_Oracle.DatabaseError: ORA-06550: line 5, column 45: cmd_type=elb consumer=False name=tap-oracle producer=True stdio=stderr string_id=tap-oracle2024-09-04T20:01:20.563921Z [info ] PLS-00201: identifier 'DBMS_LOGMNR' must be declared4 Views