CODEWITHSUNDEEP
sqloracle-databasesyntaxalter-tableora-00905
Alex Moreno
Alex Moreno

Reputation: 729

Oracle error : ORA-00905: Missing keyword on ALTER TABLE

I'm getting the error ORA-00905: Missing keyword with line:

ALTER TABLE Z_Paper_ObjTable ADD SCOPE FOR (institute) IN Z_Institute_ObjTable;

Table Z_Paper_ObjTable has an attribute institute REF Z_Institute_ObjType.

Can anyone help me please?

Upvotes: 0

Views: 3901

Answers (1)

Mat
Mat

Reputation: 206659

According to the alter table docs, the correct syntax would be:

ALTER TABLE Z_Paper_ObjTable ADD (SCOPE FOR (institute) IS Z_Institute_ObjTable);

Parens not optional, and is rather than in.

Upvotes: 2

Related Questions