BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Oct 19.

ORACLE 11G ORA-00933 DROP TABLE ISSUE


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
jgopalan
Senior Member
Senior Member



Joined: 25 Feb 2008

Posts: 40
Location: Dallas, Texas


flag
PostPosted: Wed Apr 25, 2018 11:21 am 
Post subject: ORACLE 11G ORA-00933 DROP TABLE ISSUE

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 <drop table>: <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.

_________________
BI developer
Dallas, Texas, USA
Back to top
Shazin
Principal Member
Principal Member



Joined: 19 Jul 2011

Posts: 284
Location: India


flag
PostPosted: Thu Jun 07, 2018 12:37 am 
Post subject: Re: ORACLE 11G ORA-00933 DROP TABLE ISSUE

Hi.

Possible to share the atl file?

Regards. S
Back to top
Darth Services
Principal Member
Principal Member



Joined: 20 Nov 2007

Posts: 342
Location: Death Star Schema


flag
PostPosted: Mon Jul 16, 2018 5:10 am 
Post subject: Re: ORACLE 11G ORA-00933 DROP TABLE ISSUE

Try viewing the 'Optimised SQL' of the dataflow first.
Back to top
jgopalan
Senior Member
Senior Member



Joined: 25 Feb 2008

Posts: 40
Location: Dallas, Texas


flag
PostPosted: Wed Aug 22, 2018 3:02 pm 
Post subject: Re: ORACLE 11G ORA-00933 DROP TABLE ISSUE

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

_________________
BI developer
Dallas, Texas, USA
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0354 seconds using 17 queries. (SQL 0.0060 Parse 0.0009 Other 0.0284)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo