Ed Chen Logic - Page 2 of 78 - To Make My Logic More Logical

How to Resolve PRVE-10167 : I/O Completion Ports (IOCP) device status did not match the required value on node

by Ed Chen
June 27, 2020June 23, 2020

PRVE-10167 Met an error during Oracle database 19c software installation on AIX 7.2 like this: PRVE-10167 : I/O Completion Ports (IOCP) device status did not… Read More »

How to Resolve ORA-01031 for EXECUTE IMMEDIATE in Store Procedures

by Ed Chen
June 24, 2020June 26, 2020

ORA-01031 Let's see how I reproduce ORA-01031 for statements using EXECUTE IMMEDIATE by the following example. First of all, I create a role for a… Read More »

How to Resolve PRVF-7543 : OS Kernel parameter "maxuproc" does not have proper value on node

by Ed Chen
June 20, 2020June 23, 2020

PRVF-7543 Met an error during Oracle database 19c software installation on AIX 7.2 like this: PRVF-7543 : OS Kernel parameter "maxuproc" does not have proper… Read More »

How to Install UNZIP in AIX 7.2

by Ed Chen
June 17, 2020June 18, 2020

I found there's no unzip utility available in AIX 7.2. $ which unzip which: 0652-141 There is no unzip in /usr/bin /etc /usr/sbin /usr/ucb /home/oracle/bin… Read More »

Can I Create Index for Table Belonging to Different User

by Ed Chen
June 13, 2020June 13, 2020

Yes, you can, but you need a special privilege. Try the following example: SQL> conn oe/oe@orcl Connected. SQL> create index oe.customer_id_gen_idx on sh.customers (cust_id, cust_gender);… Read More »

How to Resolve ORA-08002: sequence CURRVAL is not yet defined in this session

by Ed Chen
June 8, 2020June 8, 2020

ORA-08002 ORA-08002 means that you don't have any sequence value cached in your session, so you can't check the current value (CURRVAL) of the sequence… Read More »

Truncate vs Delete Entire Table

by Ed Chen
May 27, 2020June 1, 2020

Here I compare the differences between TRUNCATE and DELETE an entire table in the following chart. Question Truncate Table Delete From DDL or DML? DDL… Read More »

[INS-08101] Unexpected error while executing the action at state: 'supportedOSCheck'

How to Resolve INS-08101 during 19c Installation

by Ed Chen
May 16, 2020July 2, 2020

Met INS-08101 when I installed Oracle database 19c on Oracle Linux 8 update 2. [INS-08101] Unexpected error while executing the action at state: 'supportedOSCheck' This… Read More »

How to Resolve ORA-02429: cannot drop index used for enforcement of unique/primary key

by Ed Chen
April 29, 2020May 6, 2020

ORA-02429 ORA-02429 means that the index you want to drop is a primary key. SQL> drop index hr.JHIST_EMP_ID_ST_DATE_PK; drop index hr.JHIST_EMP_ID_ST_DATE_PK … Read More »

ORA-12991: column is referenced in a multi-column constraint

by Ed Chen
April 25, 2020May 6, 2020

ORA-12991 ORA-12991 means that the column you want to drop is bound to some multi-column constraint. Usually, it's a primary key constraint, but not always.… Read More »