ORA-00905: missing keyword

General Questions/Discussions
1

Hi!
I generate DDL-script and I get follow ALTER-phrase:

ALTER TABLE StaticObject 
  DROP id;

It’s return follow error text:
ORA-00905: missing keyword
But the true version of the ALTER-phrase:

ALTER TABLE StaticObject 
  DROP COLUMN id;

Can I generate ALTER-phrase with “COLUMN”?

2

Hi Eugeny,

Thanks for your post. I’ve forwarded this issue to our engineers to follow-up, and I’ll come back to you once there is any feedback.

Best regards,
Lilian Wong

3

Hi Eugeny,

I would like to let you know that the missed “COLUMN” problem is fixed and please run "VP Suite Update: to update your software to latest patch (sp1_20091203ze or later). Please refer to the following link for details about update to latest patch:

If there is anything we can help, please feel free to ask.

Best regards,
Lilian Wong

4

Thanks!

5

Hi Eugeny,

You are welcome. :slight_smile:

Best regards,
Lilian Wong