ORACLE 11G ORA-00933 DROP TABLE ISSUE

system · April 25, 2018, 4:21pm

Hello,

We are upgrading to 4.2.9 and installed ORACLE 11G version.
Created a datastore with Oracle version as 11G and ran a simple job to test. The job writes to a template table. When I run the job I get the following error:

error message for operation : <ORA-00933: SQL command not properly ended.

I tried looking for solutions and tested many different things but not able to find the correct solution for this. Any help is appreciated.

Thank you.

Regards.

jgopalan (BOB member since 2008-02-25)

system · June 7, 2018, 5:37am

Hi.

Possible to share the atl file?

Regards. S

Shazin (BOB member since 2011-07-19)

system · July 16, 2018, 10:10am

Try viewing the ‘Optimised SQL’ of the dataflow first.

Darth Services (BOB member since 2007-11-20)

system · August 22, 2018, 8:02pm

Thank you for the responses.

This was a DBA issue when switching Oracle 9 to Oracle 11. Though our DB was technically upgraded to 11, there were some issues. So Oracle 11 query was running on Oracle 9 DB version and it generated the error as mentioned.
When DBA CORRECTED the issue, our issue was resolved.

Thanks,
Janaki

jgopalan (BOB member since 2008-02-25)