Skip to main content
Solved

Truncating an Oracle Table Slow even with Drop any table

  • June 21, 2013
  • 1 reply
  • 48 views
D
Forum|alt.badge.img
We have to use an ETL account to write to our Oracle feature classes in the geodatabase.  We are using SDE 10.1 on Oracle 11g.

 

 

We have granted the ETL account and ETL role DROP ANY TABLE but the writer still behaves like it is doing deletes.  We can make this work in our SQL database but are having problems in Oracle.

 

 

What are we missing?  Using the Schema owner is not a option.

 

Thanks

 

Deb

Best answer by david_r

Hi,

 

 

try to truncate the table with an SQLExecutor and something like

 

 

truncate table myschema.mytable

 

 

and see how it compares performance-wise. If this is equally slow, the problem most probably lies outside of FME.

 

 

David
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

david_r
Celebrity
  • david_rCelebrity
  • Best Answer
  • June 24, 2013
Hi,

 

 

try to truncate the table with an SQLExecutor and something like

 

 

truncate table myschema.mytable

 

 

and see how it compares performance-wise. If this is equally slow, the problem most probably lies outside of FME.

 

 

David

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.