How to Backup PL/SQL Codes in Oracle
Backup Packages and Procedures Usually, source codes of programming unit should be version-controlled by the developer team. Mostly, they use Git, CVS or SVN to… Read More »How to Backup PL/SQL Codes in Oracle
Trigger
How to Kill Session in Logon Trigger
Here I introduce a trigger which can log logon information on specific schemas. It will kill their sessions if they are not from specific subnet.… Read More »How to Kill Session in Logon Trigger
How to Resolve impdp Error ORA-31693 with ORA-39116
ORA-31693 Got ORA-31693 when import data with schema mode. [oracle@test ~]$ impdp system/password schemas=hr,oe,sh content=data_only table_exists_action=truncate network_link=system_link_orcl ... ORA-31693: Table data object "OE"."ORDER_ITEMS" failed to… Read More »How to Resolve impdp Error ORA-31693 with ORA-39116
Is REGEXP (or RLIKE) Always Case Insensitive?
According to MySQL documentation:MySQL :: MySQL 5.7 Reference Manual :: 12.5.2 Regular ExpressionsREGEXP is not case sensitive, except when used with binary strings.It seems to… Read More »Is REGEXP (or RLIKE) Always Case Insensitive?
How to Resolve ERROR 1359 (HY000): Trigger already exists
Let's reproduce the error.mysql> use db1Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup… Read More »How to Resolve ERROR 1359 (HY000): Trigger already exists
How to Resolve ERROR 1362 (HY000): Updating of NEW row is not allowed in after trigger
Updating of NEW row is not allowed in after trigger You might think you can set new values of columns on the new row after… Read More »How to Resolve ERROR 1362 (HY000): Updating of NEW row is not allowed in after trigger