ORA-01835

ORA-01835 day of week conflicts with Julian date - This means your weekday in input is wrong. ORA-01835 This error message is also a bit confusing, especially if you were not using a Julian date at all; the error messages probably reflects how Oracle calculates dates. You are likely to encounter this error when you are do testing or some how construct a string to be parsed by to_date or to_timestamp. It just means that you specified an incorrect weekday for a date. Like today, April 17, 2024 is a Wednesday. ...

April 17, 2024 · 2 min · Øyvind Isene

ORA-01950

The error message ORA-01950 should be easy to solve, but perhaps you forgot the indexes? ORA-01950 ORA-01950 no privileges on tablespace … usually has a couple obvious solutions. If the tablespace in the error message is wrong like SYSTEM, the default tablespace must be changed for the user. Change it with something like this: alter user luser default tablespace users quota 1g on users; If the tablespace is correct, the user may be lacking a quota on the tablespace. The fix is almost the same: ...

April 8, 2024 · 2 min · Øyvind Isene