How to Resolve ORA-06512: at PL/SQL line
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-06512: at PL/SQL line
SQL
How to Resolve ORA-00933: SQL command not properly ended
ORA-00933 ORA-00933 means that you use an unexpected word or phrase at the position where SQL parser knows what qualified keyword would be. Use cases… Read More »How to Resolve ORA-00933: SQL command not properly ended
How to Resolve ORA-00940: invalid ALTER command
ORA-00940 ORA-00940 means that you use an invalid object type for ALTER operation, usually it's because you misspelled the object type name. First of all,… Read More »How to Resolve ORA-00940: invalid ALTER command
How to Resolve PLS-00123: program too large
PLS-00123 When we compile a big program unit, we may get PLS-00123 if it exceeds any one of compiler limitations that Oracle allows. ... declare… Read More »How to Resolve PLS-00123: program too large
How to Resolve ORA-01440: column to be modified must be empty to decrease precision or scale
ORA-01440 ORA-01440 means that you can't decrease the number precision of the column values directly by modifying the definition of the column. Let's see a… Read More »How to Resolve ORA-01440: column to be modified must be empty to decrease precision or scale
How to Generate Tablespace DDL with Uniform Rules
In the beginning of data migration, we usually recreate some tablespaces to accommodate data from the source. The best way to do this is to… Read More »How to Generate Tablespace DDL with Uniform Rules
Oracle DROP INDEX Syntax for All Releases
Here is the list of DROP INDEX Syntax for All Releases of Oracle Database. DROP INDEX Syntax for Oracle Database 21c DROP INDEX Syntax for… Read More »Oracle DROP INDEX Syntax for All Releases
Oracle ALTER INDEX Syntax for All Releases
Here is the list of ALTER INDEX Syntax for All Releases of Oracle Database. ALTER INDEX syntax for Oracle Database 21c ALTER INDEX syntax for… Read More »Oracle ALTER INDEX Syntax for All Releases
Oracle CREATE INDEX Syntax for All Releases
Here is the list of CREATE INDEX Syntax for All Releases of Oracle Database. CREATE INDEX Syntax for Oracle Database 21c CREATE INDEX Syntax for… Read More »Oracle CREATE INDEX Syntax for All Releases
Oracle ALTER TABLE Syntax for All Releases
Here is the list of ALTER TABLE Syntax for All Releases of Oracle Database. ALTER TABLE syntax for Oracle Database 21c ALTER TABLE syntax for… Read More »Oracle ALTER TABLE Syntax for All Releases