How to Speed Up CLEAN_AUDIT_TRAIL
CLEAN_AUDIT_TRAIL Runs Slowly ? If you have never purged the unified audit trails in your database, the first time deletion by CLEAN_AUDIT_TRAIL may take a… Read More »How to Speed Up CLEAN_AUDIT_TRAIL
CREATE INDEX
How to Resolve ORA-01702: a view is not appropriate here
ORA-01702 Tried to create an index, but it failed with ORA-01702. SQL> create index emp_salary on happy_employees (salary); create index emp_salary on happy_employees (salary) … Read More »How to Resolve ORA-01702: a view is not appropriate here
SQL Developer Create Index Partition
Partitioned Index To align with the partitioned table we created by SQL developer previously, we can add a partitioned index for it to improve data… Read More »SQL Developer Create Index Partition
How to Resolve ORA-00953: missing or invalid index name
ORA-00953 Tried to create an index for a table, but it failed with ORA-00953. Reserved Word SQL> create index update on products (patch_date); create index… Read More »How to Resolve ORA-00953: missing or invalid index name
PL/SQL Developer Create Table Example
How to create a new table in Oracle? To create a new table, we can choose to compose a hand-writing PL/SQL statement which may be… Read More »PL/SQL Developer Create Table Example
SQL Developer Create Table Example
How do I create a new table in Oracle? To create a new table, we can choose to compose a hand-writing SQL statement which may… Read More »SQL Developer Create Table Example
How to Resolve ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
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-00054: resource busy and acquire with NOWAIT specified or timeout expired
How to Resolve ORA-00990: missing or invalid privilege
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-00990: missing or invalid privilege
How to Resolve ORA-02216: tablespace name expected
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 »How to Resolve ORA-02216: tablespace name expected
LAST_DDL_TIME, How and Why
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 »LAST_DDL_TIME, How and Why