The Definitive Guide to Data Quality
Is it possible to do an "exec dbms_stats" with a Talend job ?
I am trying to execute this statement:
"EXEC DBMS_STATS.GATHER_SCHEMA_STATS('my_schema', cascade=>TRUE)"
with a tOracleRow but I get the error ORA-00900: invalid SQL Statement. It's the same with a ; at the end of the line.
When I execute this statement in SQLPlus/TOAD it works fine.
I'm on Oracle 11g, and Talend 4.0.3.
Any idea please ?
Thx in advance !
Sorry for my english..
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.