SQL

How to Resolve PLS-00753: malformed or corrupted wrapped unit

by Ed Chen
August 3, 2022September 7, 2022

PLS-00753 Found a compile error PLS-00753 when we compiled trigger CAT_ROLLBACK_TRIGGER owned by GSMADMIN_INTERNAL. PLS-00753: malformed or corrupted wrapped unit Finally, we found that some… Read More »

How to CTAS to Another Tablespace

by Ed Chen
July 28, 2022July 25, 2022

Backup Table by CTAS Without specifying tablespace, Create Table As Select (CTAS) will go to the default tablespace of the user. How about specifying a… Read More »

How to Resolve PLS-00201: identifier must be declared

by Ed Chen
June 21, 2022June 29, 2022

PLS-00201 PLS-00201 means that the identifier you specified in the statement has never declared, so it cannot be used by the stored procedure. In this… Read More »

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

by Ed Chen
June 21, 2022June 29, 2022

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 »

Oracle Insert Multiple Rows

by Ed Chen
April 28, 2022August 18, 2022

Multiple Rows Insert To insert rows into a table, you can do it one by one. insert into fruits values ('Apple', 2); insert into fruits… Read More »

How to Resolve ORA-00905: missing keyword

by Ed Chen
December 24, 2021June 30, 2022

ORA-00905 Any expected keyword missing from statements may result in ORA-00905. This is only a case when we tried to add a new data file… Read More »

How to Resolve ORA-02142: missing or invalid ALTER TABLESPACE option

by Ed Chen
December 22, 2021April 7, 2022

ORA-02142 Tried to add a new data file to a tablespace, but it failed with ORA-02142. SQL> ALTER TABLESPACE EXAMPLE DATAFILE '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB1/example02.dbf' SIZE 10M AUTOEXTEND… Read More »

How to Resolve ORA-02000: missing DATAFILES keyword

by Ed Chen
November 5, 2021May 14, 2022

ORA-02000 There could be many types of error patterns to throw ORA-02000. Missing DATAFILES Tried to drop a pluggable database PDB completely from the container,… Read More »

How to Resolve ORA-06512: at PL/SQL line

by Ed Chen
October 22, 2021June 8, 2022

ORA-06512 In fact, ORA-06512 does not throw the actual error it encountered. Instead, it points out the problem line in the PL/SQL program unit in… Read More »

How to Resolve ORA-00933: SQL command not properly ended

by Ed Chen
September 22, 2021February 21, 2022

ORA-00933 ORA-00933 means that you use an unexpected word or phrase at the position where SQL parser knows what qualified keyword should be. Use cases… Read More »