Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00901: invalid CREATE command

Ralph HFeb 15 2018 — edited Feb 19 2018

I have a simple ODI interface that reads data from and Oracle table using a custom_template query and writes to a Flat File target.

When I try to run the interface I get and invalid create command error.

I am not creating anything in the interface.

ODI-1226: Step Physical_STEP fails after 1 attempt(s).

ODI-1240: Flow Physical_STEP fails while performing a Generate header-IKM SQL to File Append- operation. This flow loads target table null.

ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-LATAM_EBS_SYN_UNIT (20)" is in error.

ODI-1298: Serial task "SERIAL-EU-LATAM_EBS_SYN_UNIT (20)" failed because child task "Generate header-IKM SQL to File Append- (30)" is in error.

ODI-1228: Task Generate header-IKM SQL to File Append- fails on the target connection EBS_SWMXDEV2.

Caused By: java.sql.SQLSyntaxErrorException: ORA-00901: invalid CREATE command

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 19 2018

Added on Feb 15 2018

#business-intelligence-applications, #data-integrator, #system-management-and-integration

14 comments

3,436 views