How Oracle Rename Trigger
ALTER TRIGGER RENAME TO To rename a trigger, we can use ALTER TRIGGER RENAME TO statement to rename it. For example: SQL> show user USER… Read More »How Oracle Rename Trigger
Trigger
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
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