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

How to Resolve ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged

by Ed Chen
May 22, 2021March 28, 2021

ORA-65179 Let's see a unsuccessful case of dropping a pluggable database (PDB). SQL> drop pluggable database orclpdb2; drop pluggable database orclpdb2 * ERROR at line… Read More »

How to Change NLS_LENGTH_SEMANTICS Temporarily

by Ed Chen
May 19, 2021March 23, 2021

NLS_LENGTH_SEMANTICS Let's see what NLS_LENGTH_SEMANTICS of the database currently set. SQL> conn hr/hr@orclpdb Connected. SQL> show parameter semantics; NAME … Read More »

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, 2021June 24, 2021

Temporary Tables Temporary tables are useful to developers who wants to stage some temporary data, but there're restrictions on them. Let's see an example. SQL>… 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 »