How to Resolve ORA-00999: invalid view nameby Ed ChenMay 22, 2023May 26, 2023ORA-00999 Tried to create a view for later use, but it failed with ORA-00999. Begin with Digit SQL> create view 123 as select * from… Read More »How to Resolve ORA-00999: invalid view name
How to Resolve ORA-01730: invalid number of column names specifiedby Ed ChenJanuary 2, 2021December 9, 2022ORA-01730 ORA-01730 means that the number of listed columns between the target (the view) and the source (the base table) in the CREATE VIEW statement… Read More »How to Resolve ORA-01730: invalid number of column names specified
How to Resolve ORA-01031: Insufficient Privilegesby Ed ChenJune 24, 2020June 6, 20231 CommentORA-01031 ORA-01031: Insufficient Privileges means that the current user did not use the right privilege to process the SQL statement. Since this error can be… Read More »How to Resolve ORA-01031: Insufficient Privileges
How to Resolve ORA-00942: table or view does not existby Ed ChenMarch 23, 2019May 15, 20234 CommentsORA-00942 ORA-00942 means that SQL engine found no table or view in your usable scope. In other words, table or view does not exist. The… Read More »How to Resolve ORA-00942: table or view does not exist