#1486: Oracle 11 g - Warning ORA-00905: missing keyword

tariqrahiman reported 2008-05-21T21:26:50Z · last modified 2008-05-27T21:19:24Z

Dev	NielsGron
QA	NielsGron

Priority	Low
Complexity	Easy

Component	Q Analyzer
Version	07.0

Oracle 11g

Execute in Query Analyser

CREATE TABLE HR.tariq (
c1 VARCHAR2(25) NULL
)
GO

drop TABLE HR.TARIQ
GO

Describe Error: Failed to execute EXPLAIN plan: ORA-00905: missing keyword

0 record(s) affected

All Comments (2) Change History

NielsGron 2008-05-21T22:56:34Z

It seems that "Show Execution Plan" button was on.

Explain Plan is not valid for DROP statements

http://lbd.epfl.ch/f/teaching/courses/oracle8i/server.815/a67775/ch13_exp.htm#838

"The EXPLAIN PLAN statement displays execution plans chosen by the Oracle optimizer for SELECT, UPDATE, INSERT, and DELETE statements"

NielsGron 2008-05-27T21:19:24Z

Works as designed.