Problem Truncating tables in Oracle

Help Community
,
1

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?

Regards

Andy

2

Fixed it, just doen’t need a semi colon

3

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