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

TamilM — Sat, 16 Nov 2024 00:11:09 GMT

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;

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

Anonymous — Mon, 10 May 2021 09:33:06 GMT

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

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

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

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