ORA-210000 Oracle error: ORA-00942: table or view does not exist | Adobe Higher Education
Skip to main content
Level 3
December 17, 2020
해결됨

ORA-210000 Oracle error: ORA-00942: table or view does not exist

  • December 17, 2020
  • 2 답변들
  • 2983 조회

Hi Team,

 

In order to have the follow up and better solution to understand, from the following blog wanted to continue discussion.

 

Please help me to find the solution for this.

 

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/ora-210000-oracle-error-ora-00942-table-or-view-does-not-exist/qaq-p/390946/comment-id/7917#M7917

 

Thanks,

Sachin

 

 

이 주제는 답변이 닫혔습니다.
최고의 답변: sachincs1991

Hi @prasannakumarmarru ,

 

We could not find what is the exact issue?

But the issue is resolved now.

 

What we did is, Created new workflow and delivery and triggered the campiagn.

But still its question for us, what exactly caused this issue?

 

Thanks,

Sachin

2 답변

prasannakumarmarru
Level 4
December 20, 2020

@sachincs1991  Have you tried enabling SQL logs on delivery analysis? This might help you understand when is that temp table gettign deleted.

 

If this is not happening any longer, this may not be useful to troubleshoot. 

 

sachincs1991작성자답변
Level 3
December 21, 2020

Hi @prasannakumarmarru ,

 

We could not find what is the exact issue?

But the issue is resolved now.

 

What we did is, Created new workflow and delivery and triggered the campiagn.

But still its question for us, what exactly caused this issue?

 

Thanks,

Sachin