Oracle truncate table issue in 7.3.1 (java.sql.SQLSyntaxErrorException: ORA-03291: Invalid truncate option - missing STORAGE keyword)

[TamilM]

Hi Team,

We are using Talend cloud big data platform 7.3.1 version, while running truncate operation in tDBRow component getting the following error.

"java.sql.SQLSyntaxErrorException: ORA-03291: Invalid truncate option - missing STORAGE keyword"

I have tried using Drop storage or Resuse storage option with truncate but no use! kindly suggest.

We are using Oracle version Version 20.2.0.175 and in Oracle component used both Oracle DB version as ' Oracle 12-7 and Oracle 18 or above' but no luck!

query syntax: TRUNCATE TABLE schema.tablename DROP STORAGE;

[Anonymous]

Hello,

ORA-03291: Invalid truncate option - missing STORAGE keyword

Cause: Expected STORAGE keyword.

Action: Either specify DROP STORAGE or REUSE STORAGE.

Any cluster or referential integrity in place?

Best regards

Sabrina