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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.