System Privilege

How to Resolve ORA-01939: only the ADMIN OPTION can be specified

by Ed Chen
April 5, 2023April 4, 2023

ORA-01939 Tried to grant a system privilege to an user, but it failed with ORA-01939. SQL> grant select any table to sh with grant option;… Read More »

How to Resolve ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

by Ed Chen
March 10, 2023February 15, 2023

ORA-28009 Tried to connect to a database, but it failed with ORA-28009. SQL> conn sys/password@orclpdb ERROR: ORA-28009: connection as SYS should be as SYSDBA or… Read More »

How to Resolve ORA-01418: specified index does not exist

by Ed Chen
September 30, 2022December 23, 2022

ORA-01418 Tried to alter an index, but it failed with ORA-01418. SQL> alter index emp_emp_id_pk rebuild; alter index emp_emp_id_pk rebuild * ERROR at line 1:… Read More »

How to Resolve PLS-00201: identifier 'DBMS_SQL' must be declared

by Ed Chen
June 21, 2022May 27, 2023
2 Comments

PLS-00201 We have talked about some common patterns of PLS-00201. Here is another case. Found some packages of CTXSYS are invalid, most compile errors are… Read More »

How to Resolve ORA-01952: system privileges not granted to

by Ed Chen
June 19, 2022June 6, 2023

ORA-01952 Let's see some error patterns of ORA-01952. CREATE TABLE ALL PRIVILEGES UNLIMITED TABLESAPCE 1. CREATE TABLE Tried to take a privilege away from a… Read More »

How to Resolve ORA-17628: Oracle error 1031 returned by remote Oracle server

by Ed Chen
November 16, 2020April 14, 2023
2 Comments

ORA-17628 In some situations, you might see errors like the following when cloning a remote pluggable database (PDB): SQL> create pluggable database finance_pdb from finanpdb@link_to_test1… Read More »

How to Resolve ORA-01031: Insufficient Privileges

by Ed Chen
June 24, 2020June 6, 2023
1 Comment

ORA-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 »

JavaScript is not enabled. Please enable it and reload the page.