ALTER TABLE ADD field getting ORA-00942 error

1
votes

I run the following command:

ALTER TABLE users
ADD date_terminated DATE DEFAULT SYSDATE NULL;
Commit;

and I get the following error message:

SQL Error: ORA-00942: table or view does not exist 00942. 00000 - "table or view does not exist"

*Cause:
*Action:

When I select * from users, I get records. Can someone tell me what I am doing wrong here?

1
sqloracle
Just a note, you try to add a column, and you get rows when you select. – jarlh
try adding schema name as alter table YOUR_SCHMEA.users – user7294900
Maybe users is a synonym? – a_horse_with_no_name
As an aside, what do you expect from 'DEFAULT SYSDATE NULL'? And there is no need to COMMIT DDL. – EdStevens

1 Answers

0
votes

This was a permissions issue: I did not use the owner of the table to alter the table. Switching to a connection with those credentials fixed the issue.