Ed Chen Logic

How to Resolve ORA-01418: specified index does not exist

by Ed Chen
September 30, 2022September 20, 2022

ORA-01418 Tried to alter an index, but it failed with ORA-01418. SQL> alter index emp_emp_id_pk rebuild; alter index emp_emp_id_pk rebuild * ERROR at line 1:… Read More »

How to Lock Table and Unlock Table

by Ed Chen
September 28, 2022September 28, 2022

Lock Table Oracle provides LOCK TABLE statements to let users lock table as their needs. For example: SQL> conn hr/hr@orclpdb Connected. SQL> lock table employees… Read More »

Alter Table Read Only Examples

by Ed Chen
September 26, 2022September 26, 2022

ALTER TABLE READ ONLY If you just want NO data of the table can be modified permanently or temporarily, you may change the attribute of… Read More »

How to Resolve ORA-12081: update operation not allowed on table

by Ed Chen
September 23, 2022September 19, 2022

ORA-12081 An user tried to update some data in a table (DML), but it failed with ORA-12081. SQL> update employees set first_name = 'Ed' where… Read More »

How to Install Oracle Database Examples

by Ed Chen
September 21, 2022September 19, 2022

What is Oracle Database Examples? Oracle Database Examples is a package which contains various sets of product demostration files that we can additionally apply them… Read More »

How to Install Oracle Database 21c on Windows

by Ed Chen
September 19, 2022September 19, 2022

Extract Oracle DB Home 21.3 Image Since release 18c, all database software installation packages has become image-based to save installation time, so we start the… Read More »

How to Resolve ORA-28348: index defined on the specified column cannot be encrypted

by Ed Chen
September 16, 2022September 2, 2022

ORA-28348 Tried to encrypt a column, but it failed with ORA-28348: SQL> alter table oe.customers modify (cust_first_name encrypt no salt); alter table oe.customers modify (cust_first_name… Read More »

How to Get Auto SQL Tuning Report

by Ed Chen
September 14, 2022September 20, 2022

SYS_AUTO_SQL_TUNING_TASK Sometimes, you don't have to run SQL tuning report for a specific statement, because the automatic SQL tuning job (SYS_AUTO_SQL_TUNING_TASK) could have identified long-running… Read More »

ORA-01187: cannot read from file because it failed verification tests

How to Resolve ORA-01187: cannot read from file

by Ed Chen
September 12, 2022September 16, 2022

ORA-01187 Found ORA-01187 and ORA-01110 after activating a standby database. ORA-01187: cannot read from file because it failed verification tests ORA-01110: data file 2003: '+DATA/ORCLCDB/ORCLPDB/temp01.dbf'… Read More »

How to Resolve ORA-01940: cannot drop a user that is currently connected

by Ed Chen
September 9, 2022July 27, 2022

ORA-01940 Tried to drop an user with all its contents cascadingly, but it failed with ORA-01940. SQL> drop user hr cascade; drop user hr cascade… Read More »