DDL

Create Table as Select (CTAS) to Tablespace

by Ed Chen
July 28, 2022March 24, 2023

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

How to Resolve ORA-00905: missing keyword

by Ed Chen
December 24, 2021March 22, 2023

ORA-00905 ORA-00905 is a very broadly used error message, any expected keyword missing from its statement will result in ORA-00905. These are only cases we… 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 keyword

by Ed Chen
November 5, 2021October 24, 2022

ORA-02000 There could be many types of error patterns to throw ORA-02000. Missing DATAFILES Missing LIMIT ORA-02000 means that there's a keyword missing from your… Read More »

How to Resolve ORA-00940: invalid ALTER command

by Ed Chen
September 8, 2021March 25, 2022

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 »

Prepare Tablespace before Data Migration

by Ed Chen
December 9, 2020March 27, 2023

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 »

DROP INDEX Syntax for All Releases of Oracle Database

by Ed Chen
July 4, 2020December 9, 2022

Here is the list of DROP INDEX Syntax for All Releases of Oracle Database. You may press Ctrl + d to bookmark this page. DROP… Read More »

ALTER INDEX Syntax for All Releases of Oracle Database

by Ed Chen
July 4, 2020December 9, 2022

Here is the list of ALTER INDEX Syntax for All Releases of Oracle Database. You may press Ctrl + d to bookmark this page. ALTER… Read More »

CREATE INDEX Syntax for All Releases of Oracle Database

by Ed Chen
July 4, 2020December 9, 2022

Here is the list of CREATE INDEX Syntax for All Releases of Oracle Database. You may press Ctrl + d to bookmark this page. CREATE… Read More »

ALTER TABLE Syntax for All Releases of Oracle Database

by Ed Chen
July 1, 2020December 9, 2022

Here is the list of ALTER TABLE Syntax for All Releases of Oracle Database. You may press Ctrl + d to bookmark this page. ALTER… Read More »