Saturday, March 19, 2022

Disabled Trigger

 Disabled Trigger

 

SQL> select instance_name from v$instance;

 

INSTANCE_NAME

----------------

Raneshprod

 

SQL> sho user

USER is "APPS"

 

SQL> select object_name,object_type,status from dba_objects where object_name=‘ranesh_GL’;

 

OBJECT_NAME

--------------------------------------------------------------------------------

OBJECT_TYPE             STATUS

----------------------- -------

RA_CUST_TRX_LINE_GL_DIST_BRI

TRIGGER                 VALID

 

 

SQL> SELECT STATUS FROM USER_TRIGGERS WHERE TRIGGER_NAME =‘ranesh_GL’;

 

STATUS

--------

ENABLED

 

SQL> alter trigger RA_CUST_TRX_LINE_GL_DIST_BRI disable;

 

Trigger altered.

 

SQL> SELECT STATUS FROM USER_TRIGGERS WHERE TRIGGER_NAME =‘ranesh_GL’;

 

 

STATUS

--------

DISABLED

 

No comments:

Table import and export.

Create Data Pump Directory. The first step in Oracle Data Pump is to create an OS level directory which will be used by Oracle for perform...