Problem Truncating tables in Oracle

I am trying to truncate a table in an Oracle database, the command works fine in SQL Developer, but when I call it using an Execute Non Query activity I get an Oracle error “ORA-03291: invalid truncate option - missing STORAGE keyword”

The SQL command I am running is truncate table idmstg.fsh_user, Sridhar suggested adding drop storage, but that made no difference, any ideas?



Fixed it, just doen’t need a semi colon

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.