ORA-03291: Invalid truncate option - missing STORAGE keyword

[themikeaustin]

All,

I receive the above message when I attempt to execute the following statements from within a SQL Window:

TRUNCATE TABLE dmart_test.Enrollment_tmp DROP STORAGE

INSERT INTO Enrollment_tmp (EnrollmentID, ElectionCode)
SELECT e.EnrollmentID, se.ElectionCode
FROM finance_ml_qa.Enrollment e
INNER JOIN finance_ml_qa.SubscriberElection se ON
se.SubscriberID = e.SubscriberID
WHERE se.StartDate = e.EffectiveDate

I can highlight each statement individually and run it without any problems, but attempting to run both together generates the error.

Any help appreciated.

TIA,

Mike

 

[mike]

It's my understanding that the SQL window will only run one SQL statement at a time.

You could put semi-colons at the end of each statement, put them in the editor tab of a command window, and then execute it. Both should run.

If you want both in the SQL window without the error message, put a semi-colon at the end of each SQL statement and select the "AutoSelect" preference so it won't automatically try to run both of them. It will just run the one that the cursor is on.

Mike

 

[themikeaustin]

Thanks. I was afraid of that. I scanned the user guide, but couldn't find anything definitive.

 

[William Robertson]

On the plus side, it means you can break up complex SQL queries with blank lines to make them easier to read.