ORA-01031

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 »

Grant Create Index to User?

by Ed Chen
June 13, 2020May 26, 2023

CREATE INDEX Privilege? Tried to grant a CREATE INDEX system privilege to an user, it failed with ORA-00990. SQL> grant create index to oe; grant… Read More »

How to Resolve ORA-00942: table or view does not exist

by Ed Chen
March 23, 2019May 15, 2023
4 Comments

ORA-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 Clone PDB to Another CDB

by Ed Chen
October 21, 2015December 11, 2022

Clone PDB to Another CDB To clone a PDB to a different CDB, we may take the following steps: Close the source PDB. Open the… Read More »

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