Ed Chen Logic - To Make My Logic More Logical

DROP INDEX Syntax for All Releases of Oracle Database

by Ed Chen
July 4, 2020July 3, 2020

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

ALTER INDEX Syntax for All Releases of Oracle Database

by Ed Chen
July 4, 2020July 3, 2020

Here is the list of ALTER INDEX Syntax for All Releases of Oracle Database. ALTER INDEX syntax for Oracle Database 20c ALTER INDEX syntax for… Read More »

CREATE INDEX Syntax for All Releases of Oracle Database

by Ed Chen
July 4, 2020July 3, 2020

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

ALTER TABLE Syntax for All Releases of Oracle Database

by Ed Chen
July 1, 2020July 3, 2020

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

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 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 »