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
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.usersuser7294900
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.