Skip to main content
Solved

TX- Oracle connector issue


The TX oracle connector drops and creates the complete table during export.

Is there a way that we can control this behaviour and the table be not dropped ?

This is because we need to move data from Staging Orcle to Main tables based on Triggers and if the table is dropped by TX then the trigger is of no use.

Best answer by JTreadwell

Hi Ritu, 

It seems your colleague Martijn van Norden submitted a support ticket where we were able to resolve the issue. In the future, please keep requests to one area of support to reduce confusion. 

For clarity here is the solution posted in the ticket:

"The only thing that would drop the table is if you deploy the table.
Differential deployment is supported but if this is not turned on it will drop and create the table again.
If you add triggers to the table after deployment you can add a post-deployment script to the table."

Thanks!

View original
Did this topic help you find an answer to your question?

3 replies

JTreadwell
Employee
Forum|alt.badge.img+5
  • Employee
  • 179 replies
  • January 28, 2020

Is the question about the Data Export feature?


  • Author
  • Starter
  • 3 replies
  • January 28, 2020

Ya, the export


JTreadwell
Employee
Forum|alt.badge.img+5
  • Employee
  • 179 replies
  • Answer
  • January 29, 2020

Hi Ritu, 

It seems your colleague Martijn van Norden submitted a support ticket where we were able to resolve the issue. In the future, please keep requests to one area of support to reduce confusion. 

For clarity here is the solution posted in the ticket:

"The only thing that would drop the table is if you deploy the table.
Differential deployment is supported but if this is not turned on it will drop and create the table again.
If you add triggers to the table after deployment you can add a post-deployment script to the table."

Thanks!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings