Ed Chen Logic - To Make My Logic More Logical

How to Resolve ORA-25188: cannot drop/disable/defer the primary key constraint for index-organized tables or sorted hash cluster

by Ed Chen
May 15, 2021March 23, 2021

ORA-25188 There're some restrictions on using index-organized tables (IOT). This is one case of them. SQL> alter table ERPAPP.PAY_EXT_P drop constraint XM500P0; alter table ERPAPP.PAY_EXT_P… Read More »

How to Re-Order Column Position of a Table

by Ed Chen
May 12, 2021April 11, 2021

One developer reported that some statements like the following failed to complete. SQL> insert into finapp.invoices_history select * from finapp.invoices_month where invoice_date < sysdate -30;… Read More »

How to Resolve ORA-14451: unsupported feature with temporary table

by Ed Chen
May 8, 2021May 8, 2021

Temporary Tables Temporary tables are useful to developers who wants to stage some data, but there're restrictions on them. Let's see an example. SQL> alter… Read More »

How to Resolve ORA-25176: storage specification not permitted for primary key

by Ed Chen
May 5, 2021May 6, 2021

ORA-25176 When I tried to modify an attribute of an index like the following, I got ORA-25176: storage specification not permitted for primary key. SQL>… Read More »

How to Resolve IMP-00029: cannot qualify table name by owner, use FROMUSER parameter

by Ed Chen
May 1, 2021May 2, 2021

Importing a dump file with table mode by imp, an original import, needs to be carefully handled, especially the table list. For example, we used… Read More »

How to Resolve Bash error: command not found

by Ed Chen
April 28, 2021April 28, 2021

I do have an executable file in the present working directory ($PWD). [edchen@test ~]$ ll total 4 -rwxr--r-- 1 edchen edchen 21 Mar 12 12:45… Read More »

How to Resolve PRVG-1036 NTP daemon boot time configuration file "/etc/rc.tcpip" does not have slewing option "-x" set on nodes

by Ed Chen
April 24, 2021March 23, 2021

PRVG-1036 slewing option PRVG-1036 alerts you that you should enable NTP slew mode in order to pass the check before installing Oracle software on both… Read More »

How to Enable Slewing Option of NTP Service in AIX

by Ed Chen
April 24, 2021March 23, 2021

To enable slew mode on NTP service of AIX, you should enable both boot-time slewing mode and run-time slewing mode. A. Enable at Boot-Time We… Read More »

How to Resolve PRVG-1032 slewing option "-x" not found on the NTP daemon command line on nodes

by Ed Chen
April 24, 2021March 23, 2021

PRVG-1032 slewing option PRVG-1032 alerts you that you should enable NTP slew mode in order to pass the check before installing Oracle software on both… Read More »

How to Resolve OGG-01233 Send TCP params error: TCP/IP error 104 (Connection reset by peer), endpoint

by Ed Chen
April 21, 2021April 21, 2021

OGG-01233 Most abended pump process are caused by network related problems, OGG-01233 is not exceptional. GGSCI (dbs2) 2> info all Program Status … Read More »