xxx30 util/a/17/6/1 120/127 triggers not displaying in a/17/6/4
- Article Type: General
- Product: Aleph
- Product Version: 20
Problem Symptoms:
Section 8.3 "Course Reading" of the "Upgrade Express 18-19 User Guide," step #7 (p.84), indicates "Run util/a/17/6/1 to create the z120/z127 triggers." Following the instructions in database XXX30, the menu leads to a sub-menu for either creating "all" triggers or "specific" triggers. Specific triggers was specified, but, when XXX30 util/A/17/6/4 to "show trigger status" is run, no triggers are listed.
Cause:
Uncertain.
Resolution:
These are the four triggers which need to be created for xxx30:
TRI z127_trigger
TRI z127_trigger_1
TRI z127_trigger_2
TRI z13_trigger_1
util a/17/6/1/1 ("Create/Recreate ALL Library Triggers") *can* be used to create these four triggers.
See Additional information, below, for the sample creation of a specific trigger....
Additional Information
Util a.17.6. Manage Triggers in XXX30
1. Create/Recreate Library Triggers
2. Enable Trigger
3. Disable Trigger
4. Show Trigger Status
Please select [exit]: 1
A.17.6.1 Create/Recreate Triggers in XXX30
1. Create/Recreate ALL Library Triggers
2. Create/Recreate specific Library Trigger
Please select [exit]: 2
Enter trigger name:z127_trigger
XXX30 trigger z127_trigger <-------------- Note entry of "z127_trigger".
SQL*Plus: Release 11.2.0.3.0 Production on Sat Sep 7 21:11:11 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Trigger created.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Enter to continue
A.17.6.1 Create/Recreate Triggers in XXX30
1. Create/Recreate ALL Library Triggers
2. Create/Recreate specific Library Trigger
Please select [exit]:
A.17.6. Manage Triggers in XXX30
1. Create/Recreate Library Triggers
2. Enable Trigger
3. Disable Trigger
4. Show Trigger Status
Please select [exit]: 4
SQL*Plus: Release 11.2.0.3.0 Production on Sat Sep 7 21:11:29 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
aleph_admin@ALEPH21> aleph_admin@ALEPH21> aleph_admin@ALEPH21> 2 3 4
TRIGGER_NAME TABLE_NAME STATUS
------------------------------ ------------------------------ --------
Z127_TRIGGER Z120 ENABLED
aleph_admin@ALEPH21> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Press CR to continue
- Article last edited: 12/5/2013