ORA-01410 – Invalid rowid

One of the reason why invalid rowid can occur is if there is a truncate that occurs in between when an existing SQL is running. Sample: 1) Sample table x with one column of datatype NUMBER. SQL> select * FROM ajaffer.test; X ———- 1000 1000 1000 1000 1000 1000 1000 7 rows selected. 2) Long…

ORA-01031: insufficient privileges

Here are some of the scenarios when one gets ORA-01031: 1) Insufficient privileges error is when “oracle” user is not part of the “dba” group when one tries to connect as sysdba, so it’s required user oracle is part of the “dba” group As you see in the following example below: $ sqlplus “/as sysdba”…