How to Resolve ORA-00905: missing keyword
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-00905: missing keyword
DDL
How to Resolve ORA-02142: missing or invalid ALTER TABLESPACE option
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-02142: missing or invalid ALTER TABLESPACE option
How to Resolve ORA-02000: missing DATAFILES keyword
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-02000: missing DATAFILES keyword
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 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
Oracle CREATE TABLE Syntax for All Releases
Here is the list of CREATE TABLE Syntax for All Releases of Oracle Database. CREATE TABLE Syntax for Oracle Database 21c CREATE TABLE Syntax for… Read More »Oracle CREATE TABLE Syntax for All Releases