CREATE INDEX

How to Resolve ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

by Ed Chen
March 6, 2023March 7, 2023

ORA-00054 There're several cases that throw ORA-00054. Alter Table Move Tablespace We tried to move table to another tablespace. SQL> show user USER is "HR"… Read More »

How to Resolve ORA-00990: missing or invalid privilege

by Ed Chen
June 17, 2022September 30, 2022

ORA-00990 There could be several error patterns of ORA-00990 when we tried to grant some privileges to a user. GRANT CREATE INDEX GRANT CREATE FUNCTION… Read More »

How to Resolve ORA-02216: tablespace name expected

by Ed Chen
May 20, 2022February 12, 2023

ORA-02216 ORA-02216 means that SQL parser finds no identifier at the position where expects a tablespace name. Basically, it's a syntax error. To correct it,… Read More »

LAST_DDL_TIME, How and Why

by Ed Chen
March 11, 2022March 21, 2023

LAST_DDL_TIME Generally speaking, LAST_DDL_TIME in ALL_OBJECTS or DBA_OBJECTS means that the last time of the object definition changed by Data Definition Language (DDL). But sometimes,… 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 »

Grant Create Index to User?

by Ed Chen
June 13, 2020December 10, 2022

CREATE INDEX Privilege? Tried to grant a CREATE INDEX system privilege to an user, it failed with ORA-00990. SQL> grant create index to oe; grant… Read More »