How to CTAS Tablespace
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 CTAS Tablespace
DDL
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
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 keyword
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-02000: missing 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
Prepare Tablespace before Data Migration
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 »Prepare Tablespace before Data Migration
DROP INDEX Syntax for All Releases of Oracle Database
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 »DROP INDEX Syntax for All Releases of Oracle Database
ALTER INDEX Syntax for All Releases of Oracle Database
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 »ALTER INDEX Syntax for All Releases of Oracle Database
CREATE INDEX Syntax for All Releases of Oracle Database
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 »CREATE INDEX Syntax for All Releases of Oracle Database
ALTER TABLE Syntax for All Releases of Oracle Database
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 »ALTER TABLE Syntax for All Releases of Oracle Database