Ed Chen Logic - Page 5 of 81 - To Make My Logic More Logical

CREATE TABLE Syntax for All Releases of Oracle Database

by Ed Chen
July 1, 2020June 28, 2020

Here is the list of CREATE TABLE Syntax for All Releases of Oracle Database. CREATE TABLE Syntax for Oracle Database 20c CREATE TABLE Syntax for… Read More »

DROP TABLE Syntax for All Releases of Oracle Database

by Ed Chen
July 1, 2020June 30, 2020

Here is the list of DROP TABLE Syntax for All Releases of Oracle Database. DROP TABLE Syntax for Oracle Database 20c DROP TABLE Syntax for… Read More »

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: Insufficient Privileges

by Ed Chen
June 24, 2020November 21, 2020

What is ORA-01031? ORA-01031: Insufficient Privileges means that the current user did not use the right privilege to process the SQL statement. Since this error… 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, 2020September 24, 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, 2020November 5, 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, 2020October 6, 2020
2 Comments

INS-08101 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'… Read More »

« Previous
1
…
3
4
5
6
7
…
81
Next »