How to Resolve ORA-00905: missing keywordby Ed ChenDecember 24, 2021June 30, 2022ORA-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
How to Resolve ORA-02142: missing or invalid ALTER TABLESPACE optionby Ed ChenDecember 22, 2021April 7, 2022ORA-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 keywordby Ed ChenNovember 5, 2021May 14, 2022ORA-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 commandby Ed ChenSeptember 8, 2021March 25, 2022ORA-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 Rulesby Ed ChenDecember 9, 2020March 28, 2021In 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 Releasesby Ed ChenJuly 4, 2020January 23, 2021Here 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 Releasesby Ed ChenJuly 4, 2020January 23, 2021Here 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 Releasesby Ed ChenJuly 4, 2020January 23, 2021Here 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 Releasesby Ed ChenJuly 1, 2020January 23, 2021Here 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 Releasesby Ed ChenJuly 1, 2020January 23, 2021Here 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