SQL> @streams_hc_10GR2.sql
Connected.
Session altered.
STREAMS Health Check (V3.0.20) for GIDQUEST.GAP.COM on Instance=GIDQUEST generated: 21:47:03 01/30/08 |
Configuration: Queue Capture Propagation Apply Database
Analysis: History Rules Notifications Configuration Performance Wait Analysis
Statistics: Streams Statistics Queue Capture Propagation Apply Apply_Errors
============================================================================================
++ DATABASE INFORMATION ++
DBID | Name | CREATED | MIN_LOG | PK_LOG | UI_LOG | FK_LOG | ALL_LO | FORCE_LOG | RESETLOGS_TIME | LOG_MODE | ARCHIVE_CHANGE# | OPEN_MODE | DATABASE_ROLE | ARCHIVELOG_CHANGE# | CURRENT_SCN | PLATFORM_ID | PLATFORM_NAME |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2602618207 | GIDQUEST | 18:24:31 07/03/07 | YES | NO | NO | NO | NO | YES | 18:24:34 07/03/07 | ARCHIVELOG | 9066401 | READ WRITE | PRIMARY | 9066415 | 9067341 | 10 | Linux IA (32-bit) |
============================================================================================
++ INSTANCE INFORMATION ++
INSTANCE | Name | HOST | VERSION | STARTUP_TIME | STATUS | PAR | ARCHIVE | LOGINS | SHU | INSTANCE_ROLE | ACTIVE_ST |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | GIDQUEST | rcltldbe01 | 10.2.0.3.0 | 15:48:00 01/30/08 | OPEN | NO | STARTED | ALLOWED | NO | PRIMARY_INSTANCE | NORMAL |
============================================================================================
+++ Current Database Incarnation +++
Current
Incarnation |
ResetLogs
Id |
ResetLogs
Change Number |
---|---|---|
2 | 626984674 | 456954 |
============================================================================================
++ REGISTRY INFORMATION ++
COMP_ID | COMP_NAME | VERSION | STATUS | MODIFIED | SCHEMA |
---|---|---|---|---|---|
CATALOG | Oracle Database Catalog Views | 10.2.0.3.0 | VALID | 16-NOV-2006 19:12:12 | SYS |
CATPROC | Oracle Database Packages and Types | 10.2.0.3.0 | VALID | 16-NOV-2006 19:12:12 | SYS |
OWM | Oracle Workspace Manager | 10.2.0.1.0 | VALID | 16-NOV-2006 19:12:12 | WMSYS |
JAVAVM | JServer JAVA Virtual Machine | 10.2.0.3.0 | VALID | 16-NOV-2006 19:12:13 | SYS |
XML | Oracle XDK | 10.2.0.3.0 | VALID | 16-NOV-2006 19:12:13 | SYS |
CATJAVA | Oracle Database Java Packages | 10.2.0.3.0 | VALID | 16-NOV-2006 19:12:13 | SYS |
EXF | Oracle Expression Filter | 10.2.0.3.0 | VALID | 16-NOV-2006 19:12:14 | EXFSYS |
ODM | Oracle Data Mining | 10.2.0.3.0 | VALID | 16-NOV-2006 19:12:14 | DMSYS |
CONTEXT | Oracle Text | 10.2.0.3.0 | VALID | 16-NOV-2006 19:12:14 | CTXSYS |
XDB | Oracle XML Database | 10.2.0.3.0 | VALID | 16-NOV-2006 19:12:17 | XDB |
RUL | Oracle Rules Manager | 10.2.0.3.0 | VALID | 16-NOV-2006 19:12:17 | EXFSYS |
ORDIM | Oracle interMedia | 10.2.0.3.0 | VALID | 16-NOV-2006 19:12:17 | ORDSYS |
APS | OLAP Analytic Workspace | 10.2.0.3.0 | VALID | 16-NOV-2006 19:12:17 | SYS |
XOQ | Oracle OLAP API | 10.2.0.3.0 | VALID | 16-NOV-2006 19:12:17 | SYS |
AMD | OLAP Catalog | 10.2.0.3.0 | VALID | 16-NOV-2006 19:12:18 | OLAPSYS |
SDO | Spatial | 10.2.0.3.0 | VALID | 16-NOV-2006 19:12:18 | MDSYS |
EM | Oracle Enterprise Manager | 10.2.0.3.0 | VALID | 16-NOV-2006 19:11:37 | SYSMAN |
17 rows selected.
============================================================================================
++ NLS DATABASE PARAMETERS ++
PARAMETER | VALUE |
---|---|
NLS_LANGUAGE | AMERICAN |
NLS_TERRITORY | AMERICA |
NLS_CURRENCY | $ |
NLS_ISO_CURRENCY | AMERICA |
NLS_NUMERIC_CHARACTERS | ., |
NLS_CHARACTERSET | WE8ISO8859P1 |
NLS_CALENDAR | GREGORIAN |
NLS_DATE_FORMAT | DD-MON-RR |
NLS_DATE_LANGUAGE | AMERICAN |
NLS_SORT | BINARY |
NLS_TIME_FORMAT | HH.MI.SSXFF AM |
NLS_TIMESTAMP_FORMAT | DD-MON-RR HH.MI.SSXFF AM |
NLS_TIME_TZ_FORMAT | HH.MI.SSXFF AM TZR |
NLS_TIMESTAMP_TZ_FORMAT | DD-MON-RR HH.MI.SSXFF AM TZR |
NLS_DUAL_CURRENCY | $ |
NLS_COMP | BINARY |
NLS_LENGTH_SEMANTICS | BYTE |
NLS_NCHAR_CONV_EXCP | FALSE |
NLS_NCHAR_CHARACTERSET | AL16UTF16 |
NLS_RDBMS_VERSION | 10.2.0.3.0 |
20 rows selected.
============================================================================================
++ GLOBAL NAME ++
GLOBAL_NAME |
---|
GIDQUEST.GAP.COM |
============================================================================================
++ Key Init.ORA parameters ++
Parameter
Name |
Parameter
Value |
Description |
---|---|---|
processes | 5000 | user processes |
sessions | 5505 | user and system sessions |
sga_max_size | 2147483648 | max total SGA size |
shared_pool_size | 536870912 | size in bytes of shared pool |
streams_pool_size | 318767104 | size in bytes of the streams pool |
sga_target | 2147483648 | Target size of SGA |
compatible | 10.2.0.3.0 | Database will be completely compatible with this software ve rsion |
archive_lag_target | 0 | Maximum number of seconds of redos the standby could lose |
logmnr_max_persistent_sessions | 1 | maximum number of threads to mine |
global_names | TRUE | enforce that database links have same name as remote databas e |
job_queue_processes | 4 | number of job queue slave processes |
_job_queue_interval | 1 | Wakeup interval in seconds for job queue co-ordinator |
parallel_max_servers | 160 | maximum parallel query servers per instance |
aq_tm_processes | 0 | number of AQ Time Managers to start |
14 rows selected.
============================================================================================
++ STREAMS QUEUES IN DATABASE ++
==========================================================================================
Owner | Queue Name | Queue Table |
Enqueue
Enabled |
Dequeue
Enabled |
Primary
Instance Owner |
Secondary
Instance Owner |
Owner
Instance |
Network
Name |
Comment |
---|---|---|---|---|---|---|---|---|---|
STRMADMIN | AQ$_PPCAPR_QUEUE_TABLE_E | PPCAPR_QUEUE_TABLE | NO | NO | 0 | 0 | 1 | exception queue | |
STRMADMIN | PPCAPR_QUEUE | PPCAPR_QUEUE_TABLE | YES | YES | 0 | 0 | 1 | ||
SYS | AQ$_SCHEDULER$_JOBQTAB_E | SCHEDULER$_JOBQTAB | NO | NO | 0 | 0 | 1 | exception queue | |
SYS | SCHEDULER$_JOBQ | SCHEDULER$_JOBQTAB | YES | YES | 0 | 0 | 1 | Scheduler job queue |
+++ Queue Subscribers ++
Queue
Name |
Queue Table | Subscriber |
Delivery
Mode |
Queue
Queue |
Protocol |
---|---|---|---|---|---|
STRMADMIN.PPCAPR_QUEUE | PPCAPR_QUEUE_TABLE | ADDRESS : "STRMADMIN"."PPCAPR_QUEUE "@GIDQSTD1.GAP.COM | PERSISTENT_OR_BUFFERED | TRUE | 0 |
SYS.SCHEDULER$_JOBQ | SCHEDULER$_JOBQTAB | CONSUMER: SCHEDULER_COORDINATOR | PERSISTENT | FALSE | 0 |
SYS.SCHEDULER$_JOBQ | SCHEDULER$_JOBQTAB | CONSUMER: SCHEDULER_PICKUP | PERSISTENT | FALSE | 0 |
Statistics: Streams Statistics Queue Capture Propagation Apply Apply_Errors
=========================================================================================
++ Minimum Archive Log Necessary to Restart Capture ++
Note: This query is valid for databases where the capture processes exist for the same source database.
Capture will restart from SCN 9018354 in the following file:
/oradata/GIDQUEST/1_392_626984674.arc (20:03:53 01/30/08)
/oradata/GIDQUEST/1_391_626984674.arc (20:03:53 01/30/08)
PL/SQL procedure successfully completed.
============================================================================================
++ CAPTURE PROCESSES IN DATABASE ++
Capture
Name |
Queue |
Capture
Type |
Status |
Positive
Rule Set |
Negative
Rule Set |
Days to
Retain Checkpoints |
Version |
Logfile
Assignme |
Error
Number |
Status
Timestamp |
Capture
Error Message |
---|---|---|---|---|---|---|---|---|---|---|---|
PPCAPR_CAPTURE | STRMADMIN.PPCAPR_QUEUE | LOCAL | ENABLED | STRMADMIN.RULESET$_14 | . | 60 | 10.2.0.3.0 | IMPLICIT | 21:09:13 01/30/08 |
++ CAPTURE PROCESS SOURCE INFORMATION ++
Capture
Name |
Capture
Type |
Source
Database |
First
SCN |
Start
SCN |
Captured
SCN |
Applied
SCN |
Last
Enqueued SCN |
Required
Checkpoint SCN |
Maximum
Checkpoint SCN |
Source
Database ID |
Source
ResetLogs SCN |
Source
ResetLogs Time |
Logminer
Session ID |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PPCAPR_CAPTURE | LOCAL | GIDQUEST.GAP.COM | 9018354 | 9018354 | 9051357 | 9018354 | 9065201 | 0 | 9050039 | 2602618207 | 456954 | 626984674 | 1 |
++ CAPTURE PROCESS PARAMETERS ++
Capture
Name |
Parameter
Name |
Parameter
Value |
User
Set? |
---|---|---|---|
PPCAPR_CAPTURE | DISABLE_ON_LIMIT | N | NO |
DOWNSTREAM_REAL_TIME_MINE | Y | NO | |
MAXIMUM_SCN | INFINITE | NO | |
MESSAGE_LIMIT | INFINITE | NO | |
PARALLELISM | 1 | NO | |
STARTUP_SECONDS | 0 | NO | |
TIME_LIMIT | INFINITE | NO | |
TRACE_LEVEL | 127 | YES | |
WRITE_ALERT_LOG | Y | NO |
9 rows selected.
============================================================================================
++ STREAMS CAPTURE RULES CONFIGURED WITH DBMS_STREAMS_ADM PACKAGE ++
Capture
Name |
Object |
Rule Set
Type |
Source
Database |
Rule
Type |
Tagged
Rules? |
Rule
Name |
---|---|---|---|---|---|---|
PPCAPR_CAPTURE | PPCAPR. | POSITIVE | SCHEMA DML | NO | STRMADMIN.PPCAPR12 | |
PPCAPR_CAPTURE | PPCAPR. | POSITIVE | SCHEMA DDL | NO | STRMADMIN.PPCAPR13 |
++ STREAMS TABLE SUBSETTING RULES ++
no rows selected
++ CAPTURE RULES BY RULE SET ++
Capture
Name |
Rule Set
Name |
Rule
Name |
Rule
Condition |
---|---|---|---|
PPCAPR_CAPTURE | STRMADMIN.RULESET$_14 | STRMADMIN.PPCAPR12 | ((:dml.get_object_owner() = 'PPCAPR') and :dml.is_ null_tag() = 'Y' ) |
STRMADMIN.RULESET$_14 | STRMADMIN.PPCAPR13 | ((:ddl.get_object_owner() = 'PPCAPR' or :ddl.get_b ase_table_owner() = 'PPCAPR') and :ddl.is_null_tag() = 'Y' ) |
+** CAPTURE RULES IN NEGATIVE RULE SET **+
no rows selected
++ CAPTURE RULE TRANSFORMATIONS BY RULE SET ++
no rows selected
============================================================================================
++ Registered Log Files for Capture ++
Capture
Process Name |
Source
Database |
Sequence
Number |
Archived Redo Log
File Name |
Archived Log
First SCN |
Archived Log Begi
Timestamp |
Archived Log
Last SCN |
Archived Log Last
Timestamp |
Archived Log
Registered Time |
Dictio
Build Begin |
Dictio
Build End |
Purgeable
Archive Log |
---|---|---|---|---|---|---|---|---|---|---|---|
PPCAPR_CAPTURE | GIDQUEST.G AP.COM | 391 | /oradata/GIDQUEST/1_391_626984674.a rc | 9018350 | 20:03:53 01/30/08 | 9018354 | 20:03:53 01/30/08 | 20:06:51 01/30/08 | NO | NO | NO |
PPCAPR_CAPTURE | GIDQUEST.G AP.COM | 392 | /oradata/GIDQUEST/1_392_626984674.a rc | 9018354 | 20:03:53 01/30/08 | 9019382 | 20:03:59 01/30/08 | 20:06:53 01/30/08 | YES | YES | NO |
PPCAPR_CAPTURE | GIDQUEST.G AP.COM | 393 | /oradata/GIDQUEST/1_393_626984674.a rc | 9019382 | 20:03:59 01/30/08 | 9025394 | 20:07:06 01/30/08 | 20:07:53 01/30/08 | NO | NO | NO |
PPCAPR_CAPTURE | GIDQUEST.G AP.COM | 394 | /oradata/GIDQUEST/1_394_626984674.a rc | 9025394 | 20:07:06 01/30/08 | 9034770 | 20:07:47 01/30/08 | 21:09:13 01/30/08 | NO | NO | NO |
PPCAPR_CAPTURE | GIDQUEST.G AP.COM | 395 | /oradata/GIDQUEST/1_395_626984674.a rc | 9034770 | 20:07:47 01/30/08 | 9066401 | 21:29:44 01/30/08 | 21:29:45 01/30/08 | NO | NO | NO |
PPCAPR_CAPTURE | GIDQUEST.G AP.COM | 396 | /oradata/GIDQUEST/1_396_626984674.a rc | 9066401 | 21:29:44 01/30/08 | 9066410 | 21:29:46 01/30/08 | 21:29:46 01/30/08 | NO | NO | NO |
PPCAPR_CAPTURE | GIDQUEST.G AP.COM | 397 | /oradata/GIDQUEST/1_397_626984674.a rc | 9066410 | 21:29:46 01/30/08 | 9066415 | 21:29:50 01/30/08 | 21:29:51 01/30/08 | NO | NO | NO |
7 rows selected.
============================================================================================
++ CAPTURE EXTRA ATTRIBUTES ++
Capture Process | Attribute Name | Include Attribute in LCRs? |
---|---|---|
PPCAPR_CAPTURE | ROW_ID | NO |
SERIAL# | NO | |
SESSION# | NO | |
THREAD# | NO | |
TX_NAME | NO | |
USERNAME | NO |
6 rows selected.
============================================================================================
++ TABLES PREPARED FOR CAPTURE ++
Table
Owner |
Table
Name |
SCN | Timestamp |
PK
Logging |
UI
Logging |
FK
Logging |
All
Logging |
---|---|---|---|---|---|---|---|
PPCAPR | APPL_ST_T | 9051963 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | APSE_LVL_T | 9052206 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | ARCV_EV_T | 9051966 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | AWRD_ARBT_TYP_T | 9051970 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | AWRD_CALC_LVL_T | 9051973 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | AWRD_T | 9051978 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | AWRD_TYP_T | 9051985 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | A_B_TST_BKT_T | 9051988 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | A_B_TST_GRP_T | 9051992 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | BRD_CHNL_ASSN_T | 9051995 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | BRD_CHNL_PMOTN_ASSN_T | 9051998 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | BRD_RUL_ASSN_T | 9052198 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | BRD_T | 9052002 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | CD_REQ_STAT_TYP_T | 9052008 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | CD_REQ_T | 9052012 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | CHNL_PMOTN_ASSN_T | 9052201 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | CHNL_T | 9052016 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | CMPL_PRC_T | 9052238 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | CNCY_T | 9052229 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | CND_BRD_T | 9052019 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | CND_STY_CLR_T | 9052023 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | CND_T | 9052026 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | CND_TYP_T | 9052032 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | CR_CRD_TYP_T | 9052035 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | CTLG_ITM_TYP_T | 9052039 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | DSCT_TYP_T | 9052043 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | EV_T | 9052046 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | EXP_CATG_T | 9052271 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | FLAT_PRC_T | 9052245 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | GIDTLSD1_HEARTBEAT | 9052274 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | LST_PRC_T | 9052235 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | MPP_LIST_PRD_T | 9052052 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | MPP_LIST_T | 9052055 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | MPP_PRD_MSG_T | 9052058 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | MPP_PRD_MSG_TYP_T | 9052062 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | MPP_TYP_T | 9052067 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | MSG_PRTY_TYP_T | 9052071 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | MUP_ID_MAP_T | 9052074 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | MUP_NACTV_RSN_T | 9052225 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | MUP_STY_CLR_T | 9052077 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | MUP_T | 9052084 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | MUP_TYP_T | 9052087 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PLAN_TABLE | 9052091 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PMOTN_CATG_T | 9052094 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PMOTN_CD_ASSN_T | 9052195 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PMOTN_CD_SEQ_T | 9052098 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PMOTN_CD_TYP_T | 9052103 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PMOTN_CHG_HIST_T | 9052106 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PMOTN_HIST_TYP_T | 9052110 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PMOTN_NTE_T | 9052114 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PMOTN_RUL_TIER_T | 9052119 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PMOTN_SPSR_T | 9052123 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PMOTN_STAT_TYP_T | 9052127 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PMOTN_SUB_CATG_T | 9052130 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PMOTN_T | 9052134 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PMOTN_TAB_T | 9052137 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PRAS_APPL_ST | 9052293 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PRAS_AWRD | 9052297 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PRAS_AWRDAAA | 9052306 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PRAS_AWRDST | 9052310 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PRAS_AWRDT | 9052302 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PRAS_ZIPCD | 9052290 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PRC_APPL_TYP_T | 9052141 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PRC_T | 9052211 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | PRC_TYP_T | 9052241 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | RUL_SET_STAT_T | 9052145 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | RUL_SET_T | 9052148 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | RUL_T | 9052277 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | RUL_TIER_T | 9052152 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | RUL_T_TMP | 9052281 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | SCHEMA_AUD_LOG_T | 9052260 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | SCHEMA_VERSION | 9052155 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | SCHEMA_VER_T | 9052264 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | SHP_CHRG_TIER_T | 9052160 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | SHP_OPT_BRD_T | 9052165 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | SHP_OPT_T | 9052168 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | SHP_TYP_T | 9052171 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | SPSR_T | 9052175 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | STATTAB | 9052178 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | STG_73_FEED_DTL_T | 9052221 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | STG_92_FEED_DTL_T | 9052248 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | STG_MUP_FEED_T | 9052183 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | STG_PRC_FEED_STAT_CD_T | 9052214 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | STG_PRC_FEED_T | 9052218 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | STG_PRC_FEED_TYP_T | 9052255 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | STG_SUP_FEED_T | 9052252 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | T3 | 9052285 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | TABLE2 | 9052267 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | USE_LMT_T | 9052188 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | USE_LMT_TYP_T | 9052191 | 21:09:41 01/30/08 | NO | NO | NO | NO |
PPCAPR | ZIPCD_OPT_ROLLUP_T | 9051957 | 21:09:41 01/30/08 | NO | NO | NO | NO |
91 rows selected.
++ SCHEMAS PREPARED FOR CAPTURE ++
Schema
Name |
Timestamp |
PK
Logging |
UI
Logging |
FK
Logging |
All
Logging |
---|---|---|---|---|---|
PPCAPR | 21:09:41 01/30/08 | IMPLICIT | IMPLICIT | IMPLICIT | NO |
++ DATABASE PREPARED FOR CAPTURE ++
no rows selected
============================================================================================
++ TABLES WITH SUPPLEMENTAL LOGGING ++
no rows selected
++ TABLE LEVEL SUPPLEMENTAL LOG GROUPS ENABLED FOR CAPTURE ++
no rows selected
++ SUPPLEMENTALLY LOGGED COLUMNS ++
no rows selected
Statistics: Streams Statistics Queue Capture Propagation Apply Apply_Errors
==========================================================================================
++ MESSAGING CLIENTS IN DATABASE ++
=========================================================================================
Messaging
Client |
Queue Owne | Queue Name |
Positive
Rule Set |
Negative
Rule Set |
---|---|---|---|---|
SCHEDULER_COORDINATOR | SYS | SCHEDULER$_JOBQ | RULESET$_4 | |
SCHEDULER_PICKUP | SYS | SCHEDULER$_JOBQ | RULESET$_8 |
++ MESSAGE CLIENT NOTIFICATIONS ++
Messaging
Client |
Queue
Owner |
Queue Name |
Notification
Type |
Notification
Action |
---|---|---|---|---|
SCHEDULER_PICKUP | SYS | SCHEDULER$_JOBQ | PROCEDURE | sys.dbms_isched.pickup_job |
==========================================================================================
++ PROPAGATIONS IN DATABASE ++
=========================================================================================
Propagation | Source Queue | Destination Queue | Q-2-Q | Status | Error Date | Error Message |
---|---|---|---|---|---|---|
PPCAPR_PROPAGATE | STRMADMIN.PPCAPR_QUEUE@GIDQUEST.GAP.COM | STRMADMIN.PPCAPR_QUEUE@GIDQSTD1.GAP.COM | TRUE | ENABLED |
++ PROPAGATION RULE SETS IN DATABASE ++
Propagation |
Positive
Rule Set |
Negative
Rule Set |
---|---|---|
PPCAPR_PROPAGATE | STRMADMIN.RULESET$_20 | . |
============================================================================================
++ STREAMS PROPAGATION RULES CONFIGURED ++
Name | Object |
Rule Set
Type |
Source
Database |
Rule
Type |
Tagged
Rules? |
Rule
Name |
---|---|---|---|---|---|---|
PPCAPR_PROPAGATE | PPCAPR. | POSITIVE | GIDQUEST.REGRES S.RDBMS.DEV.US. ORACLE.COM | SCHEMA DML | NO | STRMADMIN.PPCAPR18 |
PPCAPR_PROPAGATE | PPCAPR. | POSITIVE | GIDQUEST.REGRES S.RDBMS.DEV.US. ORACLE.COM | SCHEMA DDL | NO | STRMADMIN.PPCAPR19 |
++ STREAMS TABLE SUBSETTING RULES ++
no rows selected
++ PROPAGATION RULES BY RULE SET ++
Rule Set
Name |
Rule
Name |
Rule
Condition |
---|---|---|
STRMADMIN.RULESET$_20 | STRMADMIN.PPCAPR19 | ((:ddl.get_object_owner() = 'PPCAPR' or :ddl.get_base_table_ owner() = 'PPCAPR') and :ddl.is_null_tag() = 'Y' and :ddl.get_source_database_na me() = 'GIDQUEST.REG RESS.RDBMS.DEV.US.ORACLE.COM' ) |
STRMADMIN.RULESET$_20 | STRMADMIN.PPCAPR18 | ((:dml.get_object_owner() = 'PPCAPR') and :dml.is_null_tag() = 'Y' and :dml.get_ source_database_name() = 'GIDQUEST.REGRESS.RDBMS.DEV.US.ORAC LE.COM' ) |
+** PROPAGATION RULES IN NEGATIVE RULE SET **+
no rows selected
++ PROPAGATION RULE TRANSFORMATIONS BY RULE SET ++
no rows selected
Statistics: Streams Statistics Queue Capture Propagation Apply Apply_Errors
============================================================================================
++ APPLY INFORMATION ++
no rows selected
++ APPLY PROCESS INFORMATION ++
no rows selected
++ APPLY PROCESS HANDLERS ++
no rows selected
++ APPLY PROCESS PARAMETERS ++
no rows selected
============================================================================================
++ STREAMS APPLY RULES CONFIGURED ++
no rows selected
++ STREAMS TABLE SUBSETTING RULES ++
no rows selected
++ APPLY Rules ++
++ APPLY RULES BY RULE SET ++
no rows selected
+** APPLY RULES IN NEGATIVE RULE SET **+
no rows selected
++ APPLY RULE TRANSFORMATIONS BY RULE SET ++
no rows selected
============================================================================================
++ APPLY HANDLERS ++
no rows selected
++ APPLY DML HANDLERS ++
no rows selected
++ DML HANDLER STATUS ++
no rows selected
++ RULE TRANSFORMATIONS STATUS ++
no rows selected
++ APPLY ENQUEUE directives ++
no rows selected
++ APPLY EXECUTE directives ++
no rows selected
++ Conflict Detection Control ++
no rows selected
============================================================================================
++ UPDATE CONFLICT RESOLUTION COLUMNS ++
no rows selected
============================================================================================
++ KEY COLUMNS SET FOR APPLY ++
no rows selected
============================================================================================
++ OBJECT DEPENDENCIES SET FOR APPLY ++
no rows selected
============================================================================================
++ VALUE DEPENDENCIES SET FOR APPLY ++
no rows selected
++ APPLY PROGRESS ++
no rows selected
Statistics: Streams Statistics Queue Capture Propagation Apply Apply_Errors
============================================================================================
++ ERROR QUEUE ++
no rows selected
Statistics: Streams Statistics Queue Capture Propagation Apply Apply_Errors
============================================================================================
++ INSTANTIATION SCNs for APPLY TABLES ++
Source
Database |
Database
Object |
IGNORE_SCN | INSTANTIATION_SCN |
Apply
DBLink |
---|---|---|---|---|
GIDTLSD1 | PPCAPR.APPL_ST_T | 0 | 8246210267468 | |
GIDTLSD1 | PPCAPR.APSE_LVL_T | 0 | 8246210267465 | |
GIDTLSD1 | PPCAPR.ARCV_EV_T | 0 | 8246210267908 | |
GIDTLSD1 | PPCAPR.AWRD_ARBT_TYP_T | 0 | 8246210267460 | |
GIDTLSD1 | PPCAPR.AWRD_CALC_LVL_T | 0 | 8246210267456 | |
GIDTLSD1 | PPCAPR.AWRD_T | 0 | 8246210267524 | |
GIDTLSD1 | PPCAPR.AWRD_TYP_T | 0 | 8246210268045 | |
GIDTLSD1 | PPCAPR.A_B_TST_BKT_T | 0 | 8246210267904 | |
GIDTLSD1 | PPCAPR.A_B_TST_GRP_T | 0 | 8246210267899 | |
GIDTLSD1 | PPCAPR.BRD_CHNL_ASSN_T | 0 | 8246210268042 | |
GIDTLSD1 | PPCAPR.BRD_CHNL_PMOTN_ASSN_T | 0 | 8246210267510 | |
GIDTLSD1 | PPCAPR.BRD_RUL_ASSN_T | 0 | 8246210267507 | |
GIDTLSD1 | PPCAPR.BRD_T | 0 | 8246210268039 | |
GIDTLSD1 | PPCAPR.CD_REQ_STAT_TYP_T | 0 | 8246210268036 | |
GIDTLSD1 | PPCAPR.CD_REQ_T | 0 | 8246210267492 | |
GIDTLSD1 | PPCAPR.CHNL_PMOTN_ASSN_T | 0 | 8246210267483 | |
GIDTLSD1 | PPCAPR.CHNL_T | 0 | 8246210268033 | |
GIDTLSD1 | PPCAPR.CMPL_PRC_T | 0 | 8246210267263 | |
GIDTLSD1 | PPCAPR.CNCY_T | 0 | 8246210268030 | |
GIDTLSD1 | PPCAPR.CND_BRD_T | 0 | 8246210267513 | |
GIDTLSD1 | PPCAPR.CND_STY_CLR_T | 0 | 8246210267047 | |
GIDTLSD1 | PPCAPR.CND_T | 0 | 8246210267527 | |
GIDTLSD1 | PPCAPR.CND_TYP_T | 0 | 8246210268027 | |
GIDTLSD1 | PPCAPR.CR_CRD_TYP_T | 0 | 8246210268024 | |
GIDTLSD1 | PPCAPR.CTLG_ITM_TYP_T | 0 | 8246210268020 | |
GIDTLSD1 | PPCAPR.DSCT_TYP_T | 0 | 8246210268015 | |
GIDTLSD1 | PPCAPR.EV_T | 0 | 8246210267896 | |
GIDTLSD1 | PPCAPR.EXP_CATG_T | 0 | 8246210267892 | |
GIDTLSD1 | PPCAPR.FLAT_PRC_T | 0 | 8246210267291 | |
GIDTLSD1 | PPCAPR.GIDTLSD1_HEARTBEAT | 0 | 8246210267888 | |
GIDTLSD1 | PPCAPR.LST_PRC_T | 0 | 8246210267387 | |
GIDTLSD1 | PPCAPR.MPP_LIST_PRD_T | 0 | 8246210267383 | |
GIDTLSD1 | PPCAPR.MPP_LIST_T | 0 | 8246210267479 | |
GIDTLSD1 | PPCAPR.MPP_PRD_MSG_T | 0 | 8246210267379 | |
GIDTLSD1 | PPCAPR.MPP_PRD_MSG_TYP_T | 0 | 8246210268011 | |
GIDTLSD1 | PPCAPR.MPP_TYP_T | 0 | 8246210268007 | |
GIDTLSD1 | PPCAPR.MSG_PRTY_TYP_T | 0 | 8246210268003 | |
GIDTLSD1 | PPCAPR.MUP_ID_MAP_T | 0 | 8246210267503 | |
GIDTLSD1 | PPCAPR.MUP_NACTV_RSN_T | 0 | 8246210267999 | |
GIDTLSD1 | PPCAPR.MUP_STY_CLR_T | 0 | 8246210267534 | |
GIDTLSD1 | PPCAPR.MUP_T | 0 | 8246210267475 | |
GIDTLSD1 | PPCAPR.MUP_TYP_T | 0 | 8246210267995 | |
GIDTLSD1 | PPCAPR.PLAN_TABLE | 0 | 8246210267884 | |
GIDTLSD1 | PPCAPR.PMOTN_CATG_T | 0 | 8246210267989 | |
GIDTLSD1 | PPCAPR.PMOTN_CD_ASSN_T | 0 | 8246210267053 | |
GIDTLSD1 | PPCAPR.PMOTN_CD_SEQ_T | 0 | 8246210267984 | |
GIDTLSD1 | PPCAPR.PMOTN_CD_TYP_T | 0 | 8246210267980 | |
GIDTLSD1 | PPCAPR.PMOTN_CHG_HIST_T | 0 | 8246210267374 | |
GIDTLSD1 | PPCAPR.PMOTN_HIST_TYP_T | 0 | 8246210267976 | |
GIDTLSD1 | PPCAPR.PMOTN_NTE_T | 0 | 8246210267499 | |
GIDTLSD1 | PPCAPR.PMOTN_RUL_TIER_T | 0 | 8246210267530 | |
GIDTLSD1 | PPCAPR.PMOTN_SPSR_T | 0 | 8246210267486 | |
GIDTLSD1 | PPCAPR.PMOTN_STAT_TYP_T | 0 | 8246210267972 | |
GIDTLSD1 | PPCAPR.PMOTN_SUB_CATG_T | 0 | 8246210267968 | |
GIDTLSD1 | PPCAPR.PMOTN_T | 0 | 8246210267547 | |
GIDTLSD1 | PPCAPR.PMOTN_TAB_T | 0 | 8246210267543 | |
GIDTLSD1 | PPCAPR.PRC_APPL_TYP_T | 0 | 8246210267964 | |
GIDTLSD1 | PPCAPR.PRC_T | 0 | 8246210267879 | |
GIDTLSD1 | PPCAPR.PRC_TYP_T | 0 | 8246210267960 | |
GIDTLSD1 | PPCAPR.RUL_SET_STAT_T | 0 | 8246210267956 | |
GIDTLSD1 | PPCAPR.RUL_SET_T | 0 | 8246210267520 | |
GIDTLSD1 | PPCAPR.RUL_T | 0 | 8246210267220 | |
GIDTLSD1 | PPCAPR.RUL_TIER_T | 0 | 8246210267495 | |
GIDTLSD1 | PPCAPR.RUL_T_TMP | 0 | 8246210267344 | |
GIDTLSD1 | PPCAPR.SCHEMA_AUD_LOG_T | 0 | 8246210267952 | |
GIDTLSD1 | PPCAPR.SCHEMA_VERSION | 0 | 8246210267872 | |
GIDTLSD1 | PPCAPR.SCHEMA_VER_T | 0 | 8246210267948 | |
GIDTLSD1 | PPCAPR.SHP_CHRG_TIER_T | 0 | 8246210267944 | |
GIDTLSD1 | PPCAPR.SHP_OPT_BRD_T | 0 | 8246210267940 | |
GIDTLSD1 | PPCAPR.SHP_OPT_T | 0 | 8246210267936 | |
GIDTLSD1 | PPCAPR.SHP_TYP_T | 0 | 8246210267932 | |
GIDTLSD1 | PPCAPR.SPSR_T | 0 | 8246210267928 | |
GIDTLSD1 | PPCAPR.STATTAB | 0 | 8246210267516 | |
GIDTLSD1 | PPCAPR.STG_73_FEED_DTL_T | 0 | 8246210267868 | |
GIDTLSD1 | PPCAPR.STG_92_FEED_DTL_T | 0 | 8246210267865 | |
GIDTLSD1 | PPCAPR.STG_MUP_FEED_T | 0 | 8246210267864 | |
GIDTLSD1 | PPCAPR.STG_PRC_FEED_STAT_CD_T | 0 | 8246210267924 | |
GIDTLSD1 | PPCAPR.STG_PRC_FEED_T | 0 | 8246210267863 | |
GIDTLSD1 | PPCAPR.STG_PRC_FEED_TYP_T | 0 | 8246210267920 | |
GIDTLSD1 | PPCAPR.STG_SUP_FEED_T | 0 | 8246210267861 | |
GIDTLSD1 | PPCAPR.TABLE2 | 0 | 8246210267915 | |
GIDTLSD1 | PPCAPR.USE_LMT_T | 0 | 8246210267471 | |
GIDTLSD1 | PPCAPR.USE_LMT_TYP_T | 0 | 8246210267911 | |
GIDTLSD1 | PPCAPR.ZIPCD_OPT_ROLLUP_T | 0 | 8246210267539 |
84 rows selected.
++ INSTANTIATION SCNs for APPLY SCHEMA and DATABASE (DDL) ++
Source
Database |
Database
Object |
Database
Link |
Instantiation
SCN |
Schema o
Database |
---|---|---|---|---|
GIDTLSD1 | PPCAPR | 8246210267111 | SCHEMA |
============================================================================================
++ DBA OBJECTS - Rules, and Streams Processes ++
Object | OBJECT_ID | OBJECT_TYPE | CREATED | LAST_DDL_TIME | Status |
---|---|---|---|---|---|
SYS.PPCAPR_CAPTURE | 62140 | CAPTURE | 20:03:59 01/30/08 | 21:09:11 01/30/08 | VALID |
STRMADMIN.PPCAPR12 | 62118 | RULE | 20:03:51 01/30/08 | 20:03:51 01/30/08 | VALID |
STRMADMIN.PPCAPR13 | 62119 | RULE | 20:03:51 01/30/08 | 20:03:51 01/30/08 | VALID |
STRMADMIN.PPCAPR18 | 62301 | RULE | 21:00:31 01/30/08 | 21:00:31 01/30/08 | VALID |
STRMADMIN.PPCAPR19 | 62302 | RULE | 21:00:31 01/30/08 | 21:00:31 01/30/08 | VALID |
SYS.ALERT_QUE$1 | 9730 | RULE | 18:53:57 11/16/06 | 18:53:57 11/16/06 | VALID |
SYS.RULE$_11 | 8518 | RULE | 18:51:40 11/16/06 | 18:51:40 11/16/06 | VALID |
SYS.RULE$_3 | 8512 | RULE | 18:51:39 11/16/06 | 18:51:39 11/16/06 | VALID |
SYS.RULE$_7 | 8515 | RULE | 18:51:40 11/16/06 | 18:51:40 11/16/06 | VALID |
STRMADMIN.PPCAPR_QUEUE_N | 62116 | RULE SET | 19:07:15 01/30/08 | 19:07:15 01/30/08 | VALID |
STRMADMIN.PPCAPR_QUEUE_R | 62115 | RULE SET | 19:07:15 01/30/08 | 21:00:31 01/30/08 | VALID |
STRMADMIN.RULESET$_14 | 62120 | RULE SET | 20:03:51 01/30/08 | 20:03:51 01/30/08 | VALID |
STRMADMIN.RULESET$_20 | 62303 | RULE SET | 21:00:31 01/30/08 | 21:00:31 01/30/08 | VALID |
SYS.ALERT_QUE$1 | 9729 | RULE SET | 18:53:57 11/16/06 | 18:53:57 11/16/06 | VALID |
SYS.ALERT_QUE_N | 8841 | RULE SET | 18:51:56 11/16/06 | 18:51:56 11/16/06 | VALID |
SYS.ALERT_QUE_R | 8840 | RULE SET | 18:51:56 11/16/06 | 18:53:57 11/16/06 | VALID |
SYS.AQ$_PROP_NOTIFY_1_N | 62180 | RULE SET | 20:05:04 01/30/08 | 20:05:04 01/30/08 | VALID |
SYS.AQ$_PROP_NOTIFY_1_R | 62179 | RULE SET | 20:05:04 01/30/08 | 20:05:04 01/30/08 | VALID |
SYS.RULESET$_4 | 8513 | RULE SET | 18:51:39 11/16/06 | 18:51:39 11/16/06 | VALID |
SYS.RULESET$_8 | 8516 | RULE SET | 18:51:40 11/16/06 | 18:51:40 11/16/06 | VALID |
SYS.SCHEDULER$_EVENT_QUEUE_N | 5203 | RULE SET | 18:44:52 11/16/06 | 18:44:52 11/16/06 | VALID |
SYS.SCHEDULER$_EVENT_QUEUE_R | 5202 | RULE SET | 18:44:52 11/16/06 | 18:44:52 11/16/06 | VALID |
SYS.SCHEDULER$_JOBQ_N | 5117 | RULE SET | 18:44:51 11/16/06 | 18:44:51 11/16/06 | VALID |
SYS.SCHEDULER$_JOBQ_R | 5116 | RULE SET | 18:44:51 11/16/06 | 18:51:40 11/16/06 | VALID |
SYS.SYS$SERVICE_METRICS_N | 10204 | RULE SET | 18:55:23 11/16/06 | 18:55:23 11/16/06 | VALID |
SYS.SYS$SERVICE_METRICS_R | 10203 | RULE SET | 18:55:23 11/16/06 | 18:55:23 11/16/06 | VALID |
SYSMAN.MGMT_NOTIFY_Q_N | 49877 | RULE SET | 19:10:12 11/16/06 | 19:10:12 11/16/06 | VALID |
SYSMAN.MGMT_NOTIFY_Q_R | 49876 | RULE SET | 19:10:12 11/16/06 | 19:10:12 11/16/06 | VALID |
WMSYS.WM$EVENT_QUEUE_N | 10136 | RULE SET | 18:55:10 11/16/06 | 18:55:10 11/16/06 | VALID |
WMSYS.WM$EVENT_QUEUE_R | 10135 | RULE SET | 18:55:10 11/16/06 | 18:55:10 11/16/06 | VALID |
30 rows selected.
============================================================================================
++ Check RECOVERABLE tables populated by MAINTAIN_{TABLE|SCHEMA|GLOBAL} scripts
no rows selected
++ Check RECOVERABLE error ++
no rows selected
++ Identify Script Blocks ++
no rows selected
++ History ++
++ Streams Buffered Queue History for last day ++
Interval
Begin Time |
Interval
End Time |
Snap ID |
Current
Number of Msgs in Queue |
Current
Spilled Msgs in Queue |
Cumulative
Total Msgs for Queue |
Cumulative
Total Spilled for Queue |
Queue
Name |
QUEUE_ID | STARTUP_TIME |
Instance
Number |
Database
Identifier |
---|---|---|---|---|---|---|---|---|---|---|---|
30-JAN-08 08.00.18.354 PM | 30-JAN-08 09.00.19.953 PM | 2772 | 0 | 0 | 0 | 0 | STRMADMIN.PPCAPR_QUEUE | 62114 | 20:05:04 01/30/08 | 1 | 2602618207 |
++ Streams Buffered Subscriber History for last day ++
Interval
Begin Time |
Interval
End Time |
Snap ID | SUBSCRIBER_ID |
Current
Number of Msgs in Queue |
Cumulative
Total Msgs for Queue |
Cumulative
Total Spilled Messages |
SUBSCRIBER_NAME | SUBSCRIBER_ADDRESS |
Queue
Name |
STARTUP_TIME |
Instance
Number |
Database
Identifier |
---|---|---|---|---|---|---|---|---|---|---|---|---|
30-JAN-08 08.00.18.354 PM | 30-JAN-08 09.00.19.953 PM | 2772 | 2 | 0 | 0 | 0 | GIDQSTD1.GAP.COM | STRMADMIN.PPCAPR_QUEUE | 20:05:04 01/30/08 | 1 | 2602618207 |
++ Streams Capture History for last day ++
Interval
Begin Time |
Interval
End Time |
Capture Process |
Capture
Lag (Seconds) |
TOTAL_MESSAGES_CAPTURED |
Total Messages
Enqueued |
Elapsed Time
Paused (centisecs) |
Elapsed Time
Redo Wait (centisecs) |
Elapsed Time
Rule Evaluation (centisecs) |
Elapsed Time
Enqueuing Messages (centisecs) |
STARTUP_TIME |
Instance
Number |
Database
Identifier |
---|---|---|---|---|---|---|---|---|---|---|---|---|
30-JAN-08 08.00.18.354 PM | 30-JAN-08 09.00.19.953 PM | PPCAPR_CAPTURE | 0 | 30991 | 7991 | 0 | 94 | 1 | 345 | 20:06:51 01/30/08 | 1 | 2602618207 |
++ Streams Apply History for last day ++
no rows selected
++ SUSPICIOUS RULES ++
++ Check for MISSING RULES IN DBA_RULES ++
. Rows are returned if a rule is defined in DBA_STREAMS_TABLE_RULES (or SCHEMA, GLOBAL, too)
. but does not exist in the DBA_RULES view.
no rows selected
++ Check for EXTRA RULES IN DBA_RULES ++
. Rows are returned if a rule is defined in the DBA_RULES view
. but does not exist in the DBA_STREAMS_RULES view.
RULE_OWNER |
Rule
Name |
---|---|
SYS | ALERT_QUE$1 |
++ Check for RULE_CONDITIONS DO NOT MATCH BETWEEN STREAMS AND RULES ++
. Rows are returned if the rule condition is different between the DBA_STREAMS_TABLE_RULES view
. and the DBA_RULES view. This indicates that a manual modification has been performed on the
. underlying rule. DBA_STREAMS_TABLE_RULES always shows the initial configuration rule condition.
no rows selected
++ Check for SOURCE DATABASE NAME DOES NOT MATCH FOR CAPTURE OR PROPAGATION RULES ++
. Rows are returned if the source database column in the DBA_STREAMS_ RULES view
. for capture and/or propagation defined at this site does not match the
. global_name of this site. For capture rules, the source database must match the global_name
. of database. For propagation rules, the source database name will typically be the
. global name of the database. In some cases, it may be correct to have a different source
. database name from the global name. For example, at an intermediate node between a source site
. and the ultimate target site OR when using a downstream capture configuration, the rule source database
. name field will be diferent from the local. global name of the intermediate site.
STREAMS_TYP |
Messaging
Client |
Rule
Name |
---|---|---|
PROPAGATION | PPCAPR_PROPAGATE | STRMADMIN.PPCAPR19 |
PROPAGATION | PPCAPR_PROPAGATE | STRMADMIN.PPCAPR18 |
++ Check for GLOBAL RULE FOR CAPTURE SPECIFIED BUT CONDITION NOT MODIFIED ++
. Rows are returned if a global rule is defined in the DBA_STREAMS_GLOBAL_RULES view
. and the rule condition in the DBA_RULES view has not been modified.
. In 9iR2, the GLOBAL rule must be modified to eliminate any unsupported datatypes. For example,
. the streams administrator schema must be eliminated from the capture rules. Failure to do
. this will result in the abort of the capture process.
no rows selected
++ Check for No RULE SET DEFINED FOR CAPTURE ++
Capture requires a rule set to be defined to assure that only supported datatypes are captured.
no rows selected
++ Check for APPLY RULES WITH NO SOURCE DATABASE SPECIFIED
. Rows are returned if no source database is specified in the DBA_STREAMS_TABLE_RULES
. (SCHEMA,GLOBAL) view. An apply process can perform transactions from a single source database.
. In a typical replication environment, the source database name must be specified. In the single
. site case where captured events from the source database are handled by an apply process on the
. same database, the source database column does not need to be specified.
no rows selected
++ Check for SCHEMA RULES FOR NON_EXISTANT SCHEMA ++
no rows selected
+++ Fast Evaluation Rule Set Rules for queues +++
Rule Set |
Rule
Name |
RULE_CONDITION |
---|---|---|
STRMADMIN.PPCAPR_QUEUE_R | STRMADMIN.PPCAPR18 | ((:dml.get_object_owner() = 'PPCAPR') and :dml.is_null_tag() = 'Y' and :dml.get_ source_database_name() = 'GIDQUEST.REGRESS.RDBMS.DEV.US.ORACLE.COM' ) |
STRMADMIN.PPCAPR_QUEUE_R | STRMADMIN.PPCAPR19 | ((:ddl.get_object_owner() = 'PPCAPR' or :ddl.get_base_table_owner() = 'PPCAPR') and :ddl.is_null_tag() = 'Y' and :ddl.get_source_database_name() = 'GIDQUEST.REG RESS.RDBMS.DEV.US.ORACLE.COM' ) |
SYS.ALERT_QUE_R | SYS.ALERT_QUE$1 | tab.user_data.MESSAGE_LEVEL = 5 AND tab.user_data.MESSAGE_GROUP = 'High Availabi lity' |
SYS.SCHEDULER$_JOBQ_R | SYS.RULE$_11 | :"VAR$_10".JOB_NAME IS NOT NULL |
SYS.SCHEDULER$_JOBQ_R | SYS.RULE$_3 | :"VAR$_2".GET_FLAGS() IS NOT NULL |
SYS.SCHEDULER$_JOBQ_R | SYS.RULE$_7 | :"VAR$_6".JOB_NAME IS NOT NULL |
6 rows selected.
++ Check for CONSTRAINTS ON TABLES CONFIGURED IN STREAMS
Object | CONSTRAINT_NAME | C | Status |
Last
Change |
Search
Condition |
Reference
Constraint |
---|---|---|---|---|---|---|
PPCAPR.APPL_ST_T | PK_AST_ASI | P | ENABLED | 17:43:02 01 /30/08 | . | |
PPCAPR.APPL_ST_T | FK_AST_BC | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_BT_BC | |
PPCAPR.APPL_ST_T | NN_AST_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.APPL_ST_T | NN_AST_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.APPL_ST_T | NN_AST_ASI | C | ENABLED | 17:40:06 01 /30/08 | "APPL_ST_ID" IS NOT NULL | . |
PPCAPR.APPL_ST_T | NN_AST_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.APPL_ST_T | NN_AST_ASC | C | ENABLED | 17:40:06 01 /30/08 | "APPL_ST_CD" IS NOT NULL | . |
PPCAPR.APPL_ST_T | NN_AST_ASN | C | ENABLED | 17:40:06 01 /30/08 | "APPL_ST_NM" IS NOT NULL | . |
PPCAPR.APPL_ST_T | NN_AST_CDD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.APSE_LVL_T | PK_ALT_ALC | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.APSE_LVL_T | NN_ALT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.APSE_LVL_T | NN_ALT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.APSE_LVL_T | NN_ALT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.APSE_LVL_T | NN_ALT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.APSE_LVL_T | NN_ALT_ACCLC | C | ENABLED | 17:40:08 01 /30/08 | "ACS_LVL_CD" IS NOT NULL | . |
PPCAPR.APSE_LVL_T | NN_ALT_ALC | C | ENABLED | 17:40:08 01 /30/08 | "APSE_LVL_CD" IS NOT NULL | . |
PPCAPR.ARCV_EV_T | SYS_C0011934 | C | ENABLED | 17:40:06 01 /30/08 | "EVENT_ID" IS NOT NULL | . |
PPCAPR.ARCV_EV_T | PK_AET_EI | P | ENABLED | 17:43:02 01 /30/08 | . | |
PPCAPR.AWRD_ARBT_TYP_T | SYS_C0011940 | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.AWRD_ARBT_TYP_T | SYS_C0011937 | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.AWRD_ARBT_TYP_T | SYS_C0011938 | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.AWRD_ARBT_TYP_T | SYS_C0011939 | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.AWRD_ARBT_TYP_T | SYS_C0011935 | C | ENABLED | 17:40:06 01 /30/08 | "AWRD_ARBT_TYP_CD" IS NOT NULL | . |
PPCAPR.AWRD_ARBT_TYP_T | PK_ABTT_AATC | P | ENABLED | 17:43:02 01 /30/08 | . | |
PPCAPR.AWRD_ARBT_TYP_T | SYS_C0011936 | C | ENABLED | 17:40:06 01 /30/08 | "AWRD_ARBT_TYP_NM" IS NOT NULL | . |
PPCAPR.AWRD_CALC_LVL_T | PK_ACL_ACLI | P | ENABLED | 17:43:02 01 /30/08 | . | |
PPCAPR.AWRD_CALC_LVL_T | NN_ACL_ACLN | C | ENABLED | 17:40:06 01 /30/08 | "AWRD_CALC_LVL_NM" IS NOT NULL | . |
PPCAPR.AWRD_CALC_LVL_T | NN_ACL_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.AWRD_CALC_LVL_T | NN_ACLT_PUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.AWRD_CALC_LVL_T | NN_ACL_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.AWRD_CALC_LVL_T | NN_ACLT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.AWRD_T | FK_AT_TSTI | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_STT_STI | |
PPCAPR.AWRD_T | FK_AT_ACLI | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_ACL_ACLI | |
PPCAPR.AWRD_T | FK_AT_ATI | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_ATT_ATI | |
PPCAPR.AWRD_T | FK_AT_CITI | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_CITT_CITI | |
PPCAPR.AWRD_T | FK_AT_PRTI | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_PRT_PRTI | |
PPCAPR.AWRD_T | NN_AT_AN | C | ENABLED | 17:40:06 01 /30/08 | "AWRD_NM" IS NOT NULL | . |
PPCAPR.AWRD_T | NN_AT_ATI | C | ENABLED | 17:40:06 01 /30/08 | "AWRD_TYP_ID" IS NOT NULL | . |
PPCAPR.AWRD_T | NN_AT_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.AWRD_T | NN_AT_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.AWRD_T | NN_AT_ACLI | C | ENABLED | 17:40:06 01 /30/08 | "AWRD_CALC_LVL_ID" IS NOT NULL | . |
PPCAPR.AWRD_T | NN_AT_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.AWRD_T | NN_AT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.AWRD_T | NN_AT_PRTI | C | ENABLED | 17:40:06 01 /30/08 | "PMOTN_RUL_TIER_ID" IS NO T NULL | . |
PPCAPR.AWRD_T | NN_AT_AATC | C | ENABLED | 17:40:06 01 /30/08 | "AWRD_ARBT_TYP_CD" IS NOT NULL | . |
PPCAPR.AWRD_T | NN_AT_AC | C | ENABLED | 17:40:06 01 /30/08 | "AWRD_CNT" IS NOT NULL | . |
PPCAPR.AWRD_T | PK_AT_AI | P | ENABLED | 17:43:02 01 /30/08 | . | |
PPCAPR.AWRD_T | FK_AT_ARI | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_RT_RI | |
PPCAPR.AWRD_T | FK_AT_FSTI | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_STT_STI | |
PPCAPR.AWRD_T | SYS_C0012569 | R | DISABLED | 17:43:06 01 /30/08 | PPCAPR.PK_ABTT_AATC | |
PPCAPR.AWRD_TYP_T | NN_ATT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.AWRD_TYP_T | NN_ATT_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.AWRD_TYP_T | NN_ATT_ATN | C | ENABLED | 17:40:06 01 /30/08 | "AWRD_TYP_NM" IS NOT NULL | . |
PPCAPR.AWRD_TYP_T | PK_ATT_ATI | P | ENABLED | 17:43:02 01 /30/08 | . | |
PPCAPR.AWRD_TYP_T | NN_ATT_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.AWRD_TYP_T | NN_ATT_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.A_B_TST_BKT_T | NN_ABTBT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.A_B_TST_BKT_T | NN_ABTBKT_TBI | C | ENABLED | 17:40:06 01 /30/08 | "TST_BKT_ID" IS NOT NULL | . |
PPCAPR.A_B_TST_BKT_T | NN_ABTBT_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.A_B_TST_BKT_T | NN_ABTBT_TBSP | C | ENABLED | 17:40:06 01 /30/08 | "TST_BKT_SZ_PCT" IS NOT N ULL | . |
PPCAPR.A_B_TST_BKT_T | NN_ABTBT_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.A_B_TST_BKT_T | NN_ABTBT_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.A_B_TST_BKT_T | FK_ABTBT_ABTGI | R | DISABLED | 17:43:06 01 /30/08 | PPCAPR.SYS_C0012486 | |
PPCAPR.A_B_TST_BKT_T | NN_ABTBT_ABTGI | C | ENABLED | 17:40:06 01 /30/08 | "A_B_TST_GRP_ID" IS NOT N ULL | . |
PPCAPR.A_B_TST_BKT_T | PK_ABTBT_TBI | P | ENABLED | 17:43:02 01 /30/08 | . | |
PPCAPR.A_B_TST_GRP_T | NN_ABTGT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.A_B_TST_GRP_T | SYS_C0012486 | P | ENABLED | 17:43:02 01 /30/08 | . | |
PPCAPR.A_B_TST_GRP_T | NN_ABTGT_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.A_B_TST_GRP_T | NN_ABTGT_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.A_B_TST_GRP_T | NN_ABTGT_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.A_B_TST_GRP_T | NN_ABTGT_ABTGI | C | ENABLED | 17:40:06 01 /30/08 | "A_B_TST_GRP_ID" IS NOT N ULL | . |
PPCAPR.A_B_TST_GRP_T | NN_ABTGT_DI | C | ENABLED | 17:40:06 01 /30/08 | "DLT_IND" IS NOT NULL | . |
PPCAPR.BRD_CHNL_ASSN_T | NN_BCAT_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.BRD_CHNL_ASSN_T | NN_BCAT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.BRD_CHNL_ASSN_T | NN_BCAT_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.BRD_CHNL_ASSN_T | FK_BCA_BC | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_BT_BC | |
PPCAPR.BRD_CHNL_ASSN_T | FK_BCA_CHC | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_CT_CHC | |
PPCAPR.BRD_CHNL_ASSN_T | PK_BCA_BC_CHC | P | ENABLED | 17:43:02 01 /30/08 | . | |
PPCAPR.BRD_CHNL_ASSN_T | NN_BCAT_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.BRD_CHNL_PMOTN_ASSN_T | FK_BCPA_PI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_PT_PI | |
PPCAPR.BRD_CHNL_PMOTN_ASSN_T | FK_BCPA_BC_CHC | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_BCA_BC_CHC | |
PPCAPR.BRD_CHNL_PMOTN_ASSN_T | NN_BCPA_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.BRD_CHNL_PMOTN_ASSN_T | PK_BCPA_PI_BC_CHC | P | ENABLED | 17:43:02 01 /30/08 | . | |
PPCAPR.BRD_CHNL_PMOTN_ASSN_T | NN_BCPAT_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.BRD_CHNL_PMOTN_ASSN_T | NN_BCPA_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.BRD_CHNL_PMOTN_ASSN_T | NN_BCPAT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.BRD_RUL_ASSN_T | NN_BRAT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.BRD_RUL_ASSN_T | FK_BRAT_RI | R | ENABLED | 17:43:05 01 /30/08 | PPCAPR.PK_RT_RI | |
PPCAPR.BRD_RUL_ASSN_T | SYS_C0012311 | C | ENABLED | 17:40:08 01 /30/08 | "RUL_ID" IS NOT NULL | . |
PPCAPR.BRD_RUL_ASSN_T | SYS_C0012310 | C | ENABLED | 17:40:08 01 /30/08 | "BRD_CD" IS NOT NULL | . |
PPCAPR.BRD_RUL_ASSN_T | PK_BRAT_BC_RI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.BRD_RUL_ASSN_T | NN_BRAT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.BRD_RUL_ASSN_T | NN_BART_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.BRD_RUL_ASSN_T | FK_BRAT_BC | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_BT_BC | |
PPCAPR.BRD_RUL_ASSN_T | NN_BART_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.BRD_T | NN_BT_BN | C | ENABLED | 17:40:06 01 /30/08 | "BRD_NM" IS NOT NULL | . |
PPCAPR.BRD_T | NN_BT_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.BRD_T | NN_BT_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.BRD_T | NN_BT_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.BRD_T | NN_BT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.BRD_T | NN_BT_ABN | C | ENABLED | 17:40:06 01 /30/08 | "ABBR_BRD_NM" IS NOT NULL | . |
PPCAPR.BRD_T | PK_BT_BC | P | ENABLED | 17:43:02 01 /30/08 | . | |
PPCAPR.CD_REQ_STAT_TYP_T | SYS_C0011988 | C | ENABLED | 17:40:06 01 /30/08 | "CD_REQ_STAT_TYP_ID" IS N OT NULL | . |
PPCAPR.CD_REQ_STAT_TYP_T | NN_CRST_CRSTD | C | ENABLED | 17:40:06 01 /30/08 | "CD_REQ_STAT_TYP_DESC" IS NOT NULL | . |
PPCAPR.CD_REQ_STAT_TYP_T | NN_CRST_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.CD_REQ_STAT_TYP_T | NN_CRSTT_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.CD_REQ_STAT_TYP_T | NN_CRST_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.CD_REQ_STAT_TYP_T | NN_CRSTT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.CD_REQ_STAT_TYP_T | PK_CRST_CRSTI | P | ENABLED | 17:43:02 01 /30/08 | . | |
PPCAPR.CD_REQ_T | NN_CR_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.CD_REQ_T | NN_CRT_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.CD_REQ_T | NN_CR_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.CD_REQ_T | NN_CRT_RD | C | ENABLED | 17:40:06 01 /30/08 | "REQOR_DESC" IS NOT NULL | . |
PPCAPR.CD_REQ_T | NN_CRT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.CD_REQ_T | NN_CD_CRSTI | C | ENABLED | 17:40:06 01 /30/08 | "CD_REQ_STAT_TYP_ID" IS N OT NULL | . |
PPCAPR.CD_REQ_T | NN_CRT_PI | C | ENABLED | 17:40:06 01 /30/08 | "PMOTN_ID" IS NOT NULL | . |
PPCAPR.CD_REQ_T | FK_CR_PI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_PT_PI | |
PPCAPR.CD_REQ_T | FK_CR_CRSTI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_CRST_CRSTI | |
PPCAPR.CD_REQ_T | NN_CRT_CRN | C | ENABLED | 17:40:06 01 /30/08 | "CD_REQ_CNT" IS NOT NULL | . |
PPCAPR.CD_REQ_T | PK_CR_CRI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.CHNL_PMOTN_ASSN_T | NN_CPAT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.CHNL_PMOTN_ASSN_T | NN_CPAT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.CHNL_PMOTN_ASSN_T | FK_CPAT_CC | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_CT_CHC | |
PPCAPR.CHNL_PMOTN_ASSN_T | FK_CPAT_PI | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_PT_PI | |
PPCAPR.CHNL_PMOTN_ASSN_T | PK_CPAT_CC_PI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.CHNL_PMOTN_ASSN_T | SYS_C0012316 | C | ENABLED | 17:40:08 01 /30/08 | "CHNL_CD" IS NOT NULL | . |
PPCAPR.CHNL_PMOTN_ASSN_T | SYS_C0012317 | C | ENABLED | 17:40:08 01 /30/08 | "PMOTN_ID" IS NOT NULL | . |
PPCAPR.CHNL_PMOTN_ASSN_T | NN_CPAT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.CHNL_PMOTN_ASSN_T | NN_CPAT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.CHNL_T | PK_CT_CHC | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.CHNL_T | NN_CT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.CHNL_T | NN_CT_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.CHNL_T | NN_CT_LUDD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.CHNL_T | NN_CT_CUII | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.CHNL_T | NN_CT_CN | C | ENABLED | 17:40:06 01 /30/08 | "CHNL_NM" IS NOT NULL | . |
PPCAPR.CMPL_PRC_T | NN_CPT_PTI | C | ENABLED | 17:40:08 01 /30/08 | "PRC_TYP_ID" IS NOT NULL | . |
PPCAPR.CMPL_PRC_T | NN_CPT_CC | C | ENABLED | 17:40:08 01 /30/08 | "CNCY_CD" IS NOT NULL | . |
PPCAPR.CMPL_PRC_T | NN_CPT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.CMPL_PRC_T | NN_CPT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.CMPL_PRC_T | NN_CPT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.CMPL_PRC_T | NN_CPT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.CMPL_PRC_T | FK_CPT_CC | R | ENABLED | 17:43:23 01 /30/08 | PPCAPR.PK_CNCYT_CC | |
PPCAPR.CMPL_PRC_T | NN_CPT_CII | C | ENABLED | 17:40:08 01 /30/08 | "CTLG_ITM_ID" IS NOT NULL | . |
PPCAPR.CMPL_PRC_T | NN_CPT_IPI | C | ENABLED | 17:40:08 01 /30/08 | "CMPL_PRC_ID" IS NOT NULL | . |
PPCAPR.CMPL_PRC_T | PK_CPT_PPI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.CMPL_PRC_T | FK_CPT_LPI | R | ENABLED | 17:43:22 01 /30/08 | PPCAPR.PK_LPT_LPI | |
PPCAPR.CMPL_PRC_T | FK_CPT_PTI | R | ENABLED | 17:43:22 01 /30/08 | PPCAPR.PL_PTT_PTI | |
PPCAPR.CMPL_PRC_T | NN_CPT_PSD | C | ENABLED | 17:40:08 01 /30/08 | "PRC_STRT_DT" IS NOT NULL | . |
PPCAPR.CNCY_T | PK_CNCYT_CC | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.CNCY_T | NN_CNCT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.CNCY_T | NN_CNCT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.CNCY_T | NN_CNCT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.CNCY_T | NN_CNCT_CC | C | ENABLED | 17:40:08 01 /30/08 | "CNCY_CD" IS NOT NULL | . |
PPCAPR.CNCY_T | NN_CNCT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.CND_BRD_T | PK_CBT_CBI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.CND_BRD_T | SYS_C0012011 | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.CND_BRD_T | SYS_C0012007 | C | ENABLED | 17:40:06 01 /30/08 | "CND_BRD_ID" IS NOT NULL | . |
PPCAPR.CND_BRD_T | SYS_C0012008 | C | ENABLED | 17:40:06 01 /30/08 | "BRD_CD" IS NOT NULL | . |
PPCAPR.CND_BRD_T | SYS_C0012009 | C | ENABLED | 17:40:06 01 /30/08 | "PPC_CATG_IND" IS NOT NUL L | . |
PPCAPR.CND_BRD_T | SYS_C0012010 | C | ENABLED | 17:40:06 01 /30/08 | "CND_ID" IS NOT NULL | . |
PPCAPR.CND_BRD_T | SYS_C0012012 | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.CND_BRD_T | SYS_C0012013 | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.CND_BRD_T | SYS_C0012014 | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.CND_BRD_T | FK_CBT_CITI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_CITT_CITI | |
PPCAPR.CND_BRD_T | FK_CBT_CI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_CT_CI | |
PPCAPR.CND_BRD_T | FK_CBT_BC | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_BT_BC | |
PPCAPR.CND_STY_CLR_T | SYS_C0012018 | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.CND_STY_CLR_T | PK_CSCT_SCBI_BC_CBI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.CND_STY_CLR_T | NN_CSCT_SBI | C | ENABLED | 17:40:06 01 /30/08 | "STY_BUS_ID" IS NOT NULL | . |
PPCAPR.CND_STY_CLR_T | SYS_C0012016 | C | ENABLED | 17:40:06 01 /30/08 | "BRD_CD" IS NOT NULL | . |
PPCAPR.CND_STY_CLR_T | SYS_C0012015 | C | ENABLED | 17:40:06 01 /30/08 | "STY_CLR_BUS_ID" IS NOT N ULL | . |
PPCAPR.CND_STY_CLR_T | FK_CSCT_BC | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_BT_BC | |
PPCAPR.CND_STY_CLR_T | FK_CSCT_CBI | R | ENABLED | 17:43:17 01 /30/08 | PPCAPR.PK_CBT_CBI | |
PPCAPR.CND_STY_CLR_T | SYS_C0012019 | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.CND_STY_CLR_T | SYS_C0012020 | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.CND_STY_CLR_T | SYS_C0012021 | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.CND_STY_CLR_T | SYS_C0012022 | C | ENABLED | 17:40:06 01 /30/08 | "CND_BRD_ID" IS NOT NULL | . |
PPCAPR.CND_T | PK_CT_CI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.CND_T | FK_CT_RI | R | ENABLED | 17:43:22 01 /30/08 | PPCAPR.PK_RT_RI | |
PPCAPR.CND_T | FK_CT_CTI | R | ENABLED | 17:43:22 01 /30/08 | PPCAPR.PK_CTT_CTI | |
PPCAPR.CND_T | SYS_C0012030 | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.CND_T | SYS_C0012029 | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.CND_T | SYS_C0012028 | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.CND_T | SYS_C0012025 | C | ENABLED | 17:40:06 01 /30/08 | "CND_TYP_ID" IS NOT NULL | . |
PPCAPR.CND_T | SYS_C0012026 | C | ENABLED | 17:40:06 01 /30/08 | "RUL_ID" IS NOT NULL | . |
PPCAPR.CND_T | SYS_C0012027 | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.CND_T | SYS_C0012023 | C | ENABLED | 17:40:06 01 /30/08 | "CND_ID" IS NOT NULL | . |
PPCAPR.CND_T | SYS_C0012024 | C | ENABLED | 17:40:06 01 /30/08 | "CND_DESC" IS NOT NULL | . |
PPCAPR.CND_TYP_T | SYS_C0012032 | C | ENABLED | 17:40:06 01 /30/08 | "CND_TYP_NM" IS NOT NULL | . |
PPCAPR.CND_TYP_T | SYS_C0012031 | C | ENABLED | 17:40:06 01 /30/08 | "CND_TYP_ID" IS NOT NULL | . |
PPCAPR.CND_TYP_T | PK_CTT_CTI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.CND_TYP_T | SYS_C0012036 | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.CND_TYP_T | SYS_C0012035 | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.CND_TYP_T | SYS_C0012034 | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.CND_TYP_T | SYS_C0012033 | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.CR_CRD_TYP_T | NN_CCTT_PI | C | ENABLED | 17:40:06 01 /30/08 | "PLCC_IND" IS NOT NULL | . |
PPCAPR.CR_CRD_TYP_T | NN_CCTT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.CR_CRD_TYP_T | NN_CCTT_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.CR_CRD_TYP_T | NN_CCTT_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.CR_CRD_TYP_T | NN_CCTT_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.CR_CRD_TYP_T | NN_CCTT_CCTSN | C | ENABLED | 17:40:06 01 /30/08 | "CR_CRD_TYP_SHRT_NM" IS N OT NULL | . |
PPCAPR.CR_CRD_TYP_T | NN_CCTT_CCTI | C | ENABLED | 17:40:06 01 /30/08 | "CR_CRD_TYP_ID" IS NOT NU LL | . |
PPCAPR.CR_CRD_TYP_T | PK_CCTT_CCTI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.CTLG_ITM_TYP_T | NN_CITT_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.CTLG_ITM_TYP_T | NN_CITT_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.CTLG_ITM_TYP_T | NN_CITT_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.CTLG_ITM_TYP_T | NN_CITT_CITI | C | ENABLED | 17:40:06 01 /30/08 | "CTLG_ITM_TYP_ID" IS NOT NULL | . |
PPCAPR.CTLG_ITM_TYP_T | NN_CITT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.CTLG_ITM_TYP_T | PK_CITT_CITI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.DSCT_TYP_T | NN_DTT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.DSCT_TYP_T | NN_DTT_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.DSCT_TYP_T | PK_DT_DTC | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.DSCT_TYP_T | NN_DTT_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.DSCT_TYP_T | NN_DT_DTD | C | ENABLED | 17:40:06 01 /30/08 | "DSCT_TYP_DESC" IS NOT NU LL | . |
PPCAPR.DSCT_TYP_T | NN_DTT_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.EV_T | PK_ET_EI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.EV_T | SYS_C0012054 | C | ENABLED | 17:40:06 01 /30/08 | "EVENT_ID" IS NOT NULL | . |
PPCAPR.EXP_CATG_T | NN_ECT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.EXP_CATG_T | NN_ECT_EED | C | ENABLED | 17:40:08 01 /30/08 | "EFF_END_DTTM" IS NOT NUL L | . |
PPCAPR.EXP_CATG_T | SYS_C0012465 | C | ENABLED | 17:40:08 01 /30/08 | "BUS_ID" IS NOT NULL | . |
PPCAPR.EXP_CATG_T | NN_ECT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.EXP_CATG_T | SYS_C0012463 | C | ENABLED | 17:40:08 01 /30/08 | "BRD_CD" IS NOT NULL | . |
PPCAPR.EXP_CATG_T | SYS_C0012462 | C | ENABLED | 17:40:08 01 /30/08 | "PMOTN_REF_ID" IS NOT NUL L | . |
PPCAPR.EXP_CATG_T | SYS_C0012469 | C | ENABLED | 17:40:08 01 /30/08 | "UOW_ID" IS NOT NULL | . |
PPCAPR.EXP_CATG_T | PK_ECT_PRI_UI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.EXP_CATG_T | SYS_C0012466 | C | ENABLED | 17:40:08 01 /30/08 | "EFF_STRT_DTTM" IS NOT NU LL | . |
PPCAPR.FLAT_PRC_T | PK_FPT_FPI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.FLAT_PRC_T | FK_FPT_LPI | R | ENABLED | 17:43:23 01 /30/08 | PPCAPR.PK_LPT_LPI | |
PPCAPR.FLAT_PRC_T | FK_FPT_PTI | R | ENABLED | 17:43:23 01 /30/08 | PPCAPR.PL_PTT_PTI | |
PPCAPR.FLAT_PRC_T | FK_FPT_CC | R | ENABLED | 17:43:23 01 /30/08 | PPCAPR.PK_CNCYT_CC | |
PPCAPR.FLAT_PRC_T | NN_FPT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.FLAT_PRC_T | NN_FPT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.FLAT_PRC_T | NN_FPT_IPI | C | ENABLED | 17:40:08 01 /30/08 | "FLAT_PRC_ID" IS NOT NULL | . |
PPCAPR.FLAT_PRC_T | NN_FPT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.FLAT_PRC_T | NN_FPT_PED | C | ENABLED | 17:40:08 01 /30/08 | "PRC_END_DT" IS NOT NULL | . |
PPCAPR.FLAT_PRC_T | NN_FPT_PSD | C | ENABLED | 17:40:08 01 /30/08 | "PRC_STRT_DT" IS NOT NULL | . |
PPCAPR.FLAT_PRC_T | NN_FPT_PTI | C | ENABLED | 17:40:08 01 /30/08 | "PRC_TYP_ID" IS NOT NULL | . |
PPCAPR.FLAT_PRC_T | NN_FPT_CC | C | ENABLED | 17:40:08 01 /30/08 | "CNCY_CD" IS NOT NULL | . |
PPCAPR.FLAT_PRC_T | NN_FPT_CII | C | ENABLED | 17:40:08 01 /30/08 | "CTLG_ITM_ID" IS NOT NULL | . |
PPCAPR.FLAT_PRC_T | NN_FPT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.LST_PRC_T | PK_LPT_LPI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.LST_PRC_T | NN_LPT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.LST_PRC_T | NN_LPT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.LST_PRC_T | NN_LPT_LPI | C | ENABLED | 17:40:08 01 /30/08 | "LST_PRC_ID" IS NOT NULL | . |
PPCAPR.LST_PRC_T | NN_LPT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.LST_PRC_T | NN_LPT_LPC | C | ENABLED | 17:40:08 01 /30/08 | "LST_PRC_AMT" IS NOT NULL | . |
PPCAPR.LST_PRC_T | NN_LPT_CII | C | ENABLED | 17:40:08 01 /30/08 | "CTLG_ITM_ID" IS NOT NULL | . |
PPCAPR.LST_PRC_T | NN_LPT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.MPP_LIST_PRD_T | PK_MLPT_BI_MLI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.MPP_LIST_PRD_T | NN_MLPT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.MPP_LIST_PRD_T | NN_MLPT_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.MPP_LIST_PRD_T | FK_MLT_MLI | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_MLT_MLI | |
PPCAPR.MPP_LIST_PRD_T | NN_MLPT_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.MPP_LIST_PRD_T | NN_MLPT_MLI | C | ENABLED | 17:40:06 01 /30/08 | "MPP_LIST_ID" IS NOT NULL | . |
PPCAPR.MPP_LIST_PRD_T | NN_MLPT_CISI | C | ENABLED | 17:40:06 01 /30/08 | "CTLG_ITM_STYP_ID" IS NOT NULL | . |
PPCAPR.MPP_LIST_PRD_T | NN_MLPT_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.MPP_LIST_PRD_T | NN_MLPT_BI | C | ENABLED | 17:40:06 01 /30/08 | "BUS_ID" IS NOT NULL | . |
PPCAPR.MPP_LIST_T | NN_MLT_BC | C | ENABLED | 17:40:06 01 /30/08 | "BRD_CD" IS NOT NULL | . |
PPCAPR.MPP_LIST_T | NN_MLT_PRI | C | ENABLED | 17:40:06 01 /30/08 | "PMOTN_REF_ID" IS NOT NUL L | . |
PPCAPR.MPP_LIST_T | NN_MLT_MLI | C | ENABLED | 17:40:06 01 /30/08 | "MPP_LIST_ID" IS NOT NULL | . |
PPCAPR.MPP_LIST_T | NN_MLT_ESD | C | ENABLED | 17:40:06 01 /30/08 | "EFF_STRT_DTTM" IS NOT NU LL | . |
PPCAPR.MPP_LIST_T | NN_MLT_EED | C | ENABLED | 17:40:06 01 /30/08 | "EFF_END_DTTM" IS NOT NUL L | . |
PPCAPR.MPP_LIST_T | NN_MLT_MLN | C | ENABLED | 17:40:06 01 /30/08 | "MPP_LIST_NM" IS NOT NULL | . |
PPCAPR.MPP_LIST_T | NN_MLT_MTI | C | ENABLED | 17:40:06 01 /30/08 | "MPP_TYP_ID" IS NOT NULL | . |
PPCAPR.MPP_LIST_T | NN_MLT_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.MPP_LIST_T | NN_MLT_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.MPP_LIST_T | NN_MLT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.MPP_LIST_T | NN_MLT_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.MPP_LIST_T | PK_MLT_MLI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.MPP_LIST_T | FK_MTT_MTI | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_MTT_MTI | |
PPCAPR.MPP_PRD_MSG_T | PK_MPMT_MPMI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.MPP_PRD_MSG_T | FK_MPTT_MPTI | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_MPTT_MPTI | |
PPCAPR.MPP_PRD_MSG_T | FK_MPMTT_MPMTI | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_MPMTT_MPMTI | |
PPCAPR.MPP_PRD_MSG_T | NN_MPMT_PRI | C | ENABLED | 17:40:06 01 /30/08 | "PMOTN_REF_ID" IS NOT NUL L | . |
PPCAPR.MPP_PRD_MSG_T | NN_MPMT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.MPP_PRD_MSG_T | NN_MPMT_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.MPP_PRD_MSG_T | NN_MPMT_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.MPP_PRD_MSG_T | NN_MPMT_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.MPP_PRD_MSG_T | NN_MPMT_MTI | C | ENABLED | 17:40:06 01 /30/08 | "MPP_TYP_ID" IS NOT NULL | . |
PPCAPR.MPP_PRD_MSG_T | NN_MPMT_MPMTI | C | ENABLED | 17:40:06 01 /30/08 | "MPP_PRD_MSG_TYP_ID" IS N OT NULL | . |
PPCAPR.MPP_PRD_MSG_T | NN_MPMT_MPMT | C | ENABLED | 17:40:06 01 /30/08 | "MPP_PRD_MSG_TXT" IS NOT NULL | . |
PPCAPR.MPP_PRD_MSG_T | NN_MPMT_EED | C | ENABLED | 17:40:06 01 /30/08 | "EFF_END_DTTM" IS NOT NUL L | . |
PPCAPR.MPP_PRD_MSG_T | NN_MPMT_ESD | C | ENABLED | 17:40:06 01 /30/08 | "EFF_STRT_DTTM" IS NOT NU LL | . |
PPCAPR.MPP_PRD_MSG_T | NN_MPMT_CISI | C | ENABLED | 17:40:06 01 /30/08 | "CTLG_ITM_STYP_ID" IS NOT NULL | . |
PPCAPR.MPP_PRD_MSG_T | NN_MPMT_BI | C | ENABLED | 17:40:06 01 /30/08 | "BUS_ID" IS NOT NULL | . |
PPCAPR.MPP_PRD_MSG_T | NN_MPMT_BC | C | ENABLED | 17:40:06 01 /30/08 | "BRD_CD" IS NOT NULL | . |
PPCAPR.MPP_PRD_MSG_T | NN_MPMT_MPMI | C | ENABLED | 17:40:06 01 /30/08 | "MPP_PRD_MSG_ID" IS NOT N ULL | . |
PPCAPR.MPP_PRD_MSG_TYP_T | PK_MPMTT_MPMTI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.MPP_PRD_MSG_TYP_T | NN_MPMTT_MPMTD | C | ENABLED | 17:40:06 01 /30/08 | "MPP_PRD_MSG_TYE_DESC" IS NOT NULL | . |
PPCAPR.MPP_PRD_MSG_TYP_T | NN_MPMTT_MPMTI | C | ENABLED | 17:40:06 01 /30/08 | "MPP_PRD_MSG_TYP_ID" IS N OT NULL | . |
PPCAPR.MPP_PRD_MSG_TYP_T | NN_MPMTT_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.MPP_PRD_MSG_TYP_T | NN_MPMTT_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.MPP_PRD_MSG_TYP_T | NN_MPMTT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.MPP_PRD_MSG_TYP_T | NN_MPMTT_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.MPP_TYP_T | NN_MTT_MTD | C | ENABLED | 17:40:06 01 /30/08 | "MPP_TYP_DESC" IS NOT NUL L | . |
PPCAPR.MPP_TYP_T | NN_MTT_MTI | C | ENABLED | 17:40:06 01 /30/08 | "MPP_TYP_ID" IS NOT NULL | . |
PPCAPR.MPP_TYP_T | NN_MTT_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.MPP_TYP_T | NN_MTT_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.MPP_TYP_T | NN_MTT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.MPP_TYP_T | NN_MTT_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.MPP_TYP_T | PK_MTT_MTI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.MSG_PRTY_TYP_T | PK_MPTT_MPTI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.MSG_PRTY_TYP_T | NN_MPTT_MUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.MSG_PRTY_TYP_T | NN_MPTT_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.MSG_PRTY_TYP_T | NN_MPTT_MPTI | C | ENABLED | 17:40:06 01 /30/08 | "MSG_PRTY_TYP_ID" IS NOT NULL | . |
PPCAPR.MSG_PRTY_TYP_T | NN_MPTT_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.MSG_PRTY_TYP_T | NN_MPTT_MPTD | C | ENABLED | 17:40:06 01 /30/08 | "MSG_PRTY_TYP_DESC" IS NO T NULL | . |
PPCAPR.MSG_PRTY_TYP_T | NN_MPTT_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.MUP_ID_MAP_T | NN_MIMT_ESD | C | ENABLED | 17:40:06 01 /30/08 | "EFF_STRT_DT" IS NOT NULL | . |
PPCAPR.MUP_ID_MAP_T | NN_MIMT_EED | C | ENABLED | 17:40:06 01 /30/08 | "EFF_END_DTTM" IS NOT NUL L | . |
PPCAPR.MUP_ID_MAP_T | PK_MIMT_MI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.MUP_ID_MAP_T | NN_MIMT_BC | C | ENABLED | 17:40:06 01 /30/08 | "BRD_CD" IS NOT NULL | . |
PPCAPR.MUP_ID_MAP_T | NN_MIMT_GI | C | ENABLED | 17:40:06 01 /30/08 | "GRP_ID" IS NOT NULL | . |
PPCAPR.MUP_ID_MAP_T | NN_MIMT_MI | C | ENABLED | 17:40:06 01 /30/08 | "MUP_ID" IS NOT NULL | . |
PPCAPR.MUP_ID_MAP_T | NN_MIMT_MCI | C | ENABLED | 17:40:06 01 /30/08 | "MDSE_CO_ID" IS NOT NULL | . |
PPCAPR.MUP_NACTV_RSN_T | NN_MNRT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.MUP_NACTV_RSN_T | NN_MNRT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.MUP_NACTV_RSN_T | PK_MNRT_NRI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.MUP_NACTV_RSN_T | NN_MNRT_NRI | C | ENABLED | 17:40:08 01 /30/08 | "NACTV_RSN_ID" IS NOT NUL L | . |
PPCAPR.MUP_NACTV_RSN_T | NN_MNRT_NRD | C | ENABLED | 17:40:08 01 /30/08 | "NACTV_RSN_DESC" IS NOT N ULL | . |
PPCAPR.MUP_NACTV_RSN_T | NN_MNRT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.MUP_NACTV_RSN_T | NN_MNRT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.MUP_STY_CLR_T | FK_MSC_MI | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_MT_MI | |
PPCAPR.MUP_STY_CLR_T | PK_MSCT_MI_MSCI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.MUP_STY_CLR_T | NN_MSC_LUD | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.MUP_STY_CLR_T | NN_MSC_MI | C | ENABLED | 17:40:06 01 /30/08 | "MUP_ID" IS NOT NULL | . |
PPCAPR.MUP_STY_CLR_T | NN_MSC_LSC | C | ENABLED | 17:40:06 01 /30/08 | "LGCY_STY_CD" IS NOT NULL | . |
PPCAPR.MUP_STY_CLR_T | NN_MSC_LMC | C | ENABLED | 17:40:06 01 /30/08 | "LGCY_MKT_CD" IS NOT NULL | . |
PPCAPR.MUP_STY_CLR_T | NN_MSC_LSCC | C | ENABLED | 17:40:06 01 /30/08 | "LGCY_STY_CLR_CD" IS NOT NULL | . |
PPCAPR.MUP_STY_CLR_T | NN_MSC_CD | C | ENABLED | 17:40:06 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.MUP_STY_CLR_T | NN_MSC_SUD | C | ENABLED | 17:40:06 01 /30/08 | "SRC_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.MUP_STY_CLR_T | NN_MSC_CUI | C | ENABLED | 17:40:06 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.MUP_STY_CLR_T | NN_MSC_LUUI | C | ENABLED | 17:40:06 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.MUP_T | NN_MT_CD | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.MUP_T | FK_MT_DTC | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_DT_DTC | |
PPCAPR.MUP_T | NN_MT_ESD | C | ENABLED | 17:40:07 01 /30/08 | "EFF_STRT_DT" IS NOT NULL | . |
PPCAPR.MUP_T | NN_MT_DA | C | ENABLED | 17:40:07 01 /30/08 | "DSCT_AMT" IS NOT NULL | . |
PPCAPR.MUP_T | NN_MT_MTC | C | ENABLED | 17:40:07 01 /30/08 | "MUP_TYP_CD" IS NOT NULL | . |
PPCAPR.MUP_T | NN_MT_MXSI | C | ENABLED | 17:40:07 01 /30/08 | "MUP_XOS_STY_IND" IS NOT NULL | . |
PPCAPR.MUP_T | NN_MT_DTC | C | ENABLED | 17:40:07 01 /30/08 | "DSCT_TYP_CD" IS NOT NULL | . |
PPCAPR.MUP_T | NN_MT_MRI | C | ENABLED | 17:40:07 01 /30/08 | "MULT_RQM_IND" IS NOT NUL L | . |
PPCAPR.MUP_T | NN_MT_CC | C | ENABLED | 17:40:07 01 /30/08 | "CHNL_CD" IS NOT NULL | . |
PPCAPR.MUP_T | NN_MT_SUD | C | ENABLED | 17:40:07 01 /30/08 | "SRC_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.MUP_T | NN_MT_BC | C | ENABLED | 17:40:07 01 /30/08 | "BRD_CD" IS NOT NULL | . |
PPCAPR.MUP_T | NN_MT_LUUI | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.MUP_T | NN_MT_LUD | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.MUP_T | NN_MT_CUI | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.MUP_T | NN_MT_QQ | C | ENABLED | 17:40:07 01 /30/08 | "QUAL_QTY" IS NOT NULL | . |
PPCAPR.MUP_T | NN_MT_GI | C | ENABLED | 17:40:07 01 /30/08 | "GRP_ID" IS NOT NULL | . |
PPCAPR.MUP_T | NN_MT_MCI | C | ENABLED | 17:40:07 01 /30/08 | "MDSE_CO_ID" IS NOT NULL | . |
PPCAPR.MUP_T | PK_MT_MI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.MUP_T | FK_MT_MTI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_MUP_TYP_T | |
PPCAPR.MUP_T | FK_MT_BC_CHC | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_BCA_BC_CHC | |
PPCAPR.MUP_T | NN_MT_EED | C | ENABLED | 17:40:07 01 /30/08 | "EFF_END_DT" IS NOT NULL | . |
PPCAPR.MUP_TYP_T | SYS_C0012140 | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.MUP_TYP_T | SYS_C0012139 | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.MUP_TYP_T | SYS_C0012138 | C | ENABLED | 17:40:07 01 /30/08 | "MUP_TYP_DESC" IS NOT NUL L | . |
PPCAPR.MUP_TYP_T | SYS_C0012137 | C | ENABLED | 17:40:07 01 /30/08 | "MUP_TYP_CD" IS NOT NULL | . |
PPCAPR.MUP_TYP_T | PK_MUP_TYP_T | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.MUP_TYP_T | SYS_C0012142 | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.MUP_TYP_T | SYS_C0012141 | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.PMOTN_CATG_T | NN_PCT_LUUI | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_CATG_T | NN_PC_CUI | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_CATG_T | NN_PC_PCN | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_CATG_NM" IS NOT NU LL | . |
PPCAPR.PMOTN_CATG_T | PK_PC_PCC | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.PMOTN_CATG_T | NN_PC_PCD | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.PMOTN_CATG_T | NN_PCT_LUD | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.PMOTN_CD_ASSN_T | PK_PCA_PI_PC1 | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.PMOTN_CD_ASSN_T | SYS_C0012307 | C | ENABLED | 17:40:08 01 /30/08 | "PMOTN_ID" IS NOT NULL | . |
PPCAPR.PMOTN_CD_ASSN_T | SYS_C0012309 | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.PMOTN_CD_ASSN_T | SYS_C0012308 | C | ENABLED | 17:40:08 01 /30/08 | "PMOTN_CD" IS NOT NULL | . |
PPCAPR.PMOTN_CD_SEQ_T | NN_PCST_PCSN | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_CD_SEQ_NBR" IS NOT NULL | . |
PPCAPR.PMOTN_CD_TYP_T | NN_PCTT_CD | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.PMOTN_CD_TYP_T | NN_PCTT_LUD | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.PMOTN_CD_TYP_T | NN_PCTT_CUI | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_CD_TYP_T | NN_PCTT_LUUI | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_CD_TYP_T | PK_PCTT_PCTI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.PMOTN_CD_TYP_T | NN_PCTT_PCTN | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_CD_TYP_NM" IS NOT NULL | . |
PPCAPR.PMOTN_CHG_HIST_T | NN_PCHT_LUD | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.PMOTN_CHG_HIST_T | NN_PCH_CD | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.PMOTN_CHG_HIST_T | NN_PCH_PHTC | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_HIST_TYP_CD" IS NO T NULL | . |
PPCAPR.PMOTN_CHG_HIST_T | NN_PCH_CUI | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_CHG_HIST_T | NN_PCH_PI | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_ID" IS NOT NULL | . |
PPCAPR.PMOTN_CHG_HIST_T | NN_PCHT_LUUI | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_CHG_HIST_T | NN_PCHT_LUUN | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_NM" IS NOT NULL | . |
PPCAPR.PMOTN_CHG_HIST_T | FK_PCH_PHTC | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_PHT_PHTC | |
PPCAPR.PMOTN_CHG_HIST_T | FK_PCH_PI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_PT_PI | |
PPCAPR.PMOTN_CHG_HIST_T | PK_PCH_PCHI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.PMOTN_HIST_TYP_T | PK_PHT_PHTC | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.PMOTN_HIST_TYP_T | NN_PHTT_LUUI | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_HIST_TYP_T | NN_PHT_CD | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.PMOTN_HIST_TYP_T | NN_PHTT_LUD | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.PMOTN_HIST_TYP_T | NN_PHT_CUI | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_NTE_T | PK_PN_PNI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.PMOTN_NTE_T | FK_PN_PI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_PT_PI | |
PPCAPR.PMOTN_NTE_T | NN_PNT_LUUI | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_NTE_T | NN_PN_UN | C | ENABLED | 17:40:07 01 /30/08 | "USER_NM" IS NOT NULL | . |
PPCAPR.PMOTN_NTE_T | NN_PN_PI | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_ID" IS NOT NULL | . |
PPCAPR.PMOTN_NTE_T | NN_PNT_CUI | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_NTE_T | NN_PNT_CD | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.PMOTN_NTE_T | NN_PNT_LUD | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.PMOTN_RUL_TIER_T | NN_PRTT_CST | C | ENABLED | 17:40:07 01 /30/08 | "CND_SUM_TXT" IS NOT NULL | . |
PPCAPR.PMOTN_RUL_TIER_T | NN_PRT_SD | C | ENABLED | 17:40:07 01 /30/08 | "SHRT_DESC" IS NOT NULL | . |
PPCAPR.PMOTN_RUL_TIER_T | NN_PRTT_PI1 | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_ID" IS NOT NULL | . |
PPCAPR.PMOTN_RUL_TIER_T | PK_PRT_PRTI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.PMOTN_RUL_TIER_T | FK_PRT_PI | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_PT_PI | |
PPCAPR.PMOTN_RUL_TIER_T | SYS_C0012174 | C | ENABLED | 17:40:07 01 /30/08 | "RUL_TIER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_RUL_TIER_T | NN_PRTT_LUUI | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_RUL_TIER_T | NN_PRTT_LUD | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.PMOTN_RUL_TIER_T | NN_PRTT_CUI | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_RUL_TIER_T | NN_PRTT_CD | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.PMOTN_RUL_TIER_T | FK_PRTT_RTI | R | ENABLED | 17:43:06 01 /30/08 | PPCAPR.PK_RTT_RTI | |
PPCAPR.PMOTN_SPSR_T | SYS_C0012184 | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_SPSR_T | SYS_C0012183 | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_SPSR_T | FK_PST_PI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_PT_PI | |
PPCAPR.PMOTN_SPSR_T | FK_PST_SI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_ST_SI | |
PPCAPR.PMOTN_SPSR_T | PK_PST_PI_SI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.PMOTN_SPSR_T | SYS_C0012179 | C | ENABLED | 17:40:07 01 /30/08 | "SPSR_ID" IS NOT NULL | . |
PPCAPR.PMOTN_SPSR_T | SYS_C0012180 | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_ID" IS NOT NULL | . |
PPCAPR.PMOTN_SPSR_T | SYS_C0012181 | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.PMOTN_SPSR_T | SYS_C0012182 | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.PMOTN_STAT_TYP_T | NN_PST_CD | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.PMOTN_STAT_TYP_T | NN_PSTT_LUD | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.PMOTN_STAT_TYP_T | PK_PST_PSI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.PMOTN_STAT_TYP_T | NN_PSTT_LUUI | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_STAT_TYP_T | NN_PST_CUI | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_SUB_CATG_T | NN_PSCT_PCC | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_CATG_CD" IS NOT NU LL | . |
PPCAPR.PMOTN_SUB_CATG_T | SYS_C0012579 | R | DISABLED | 17:43:07 01 /30/08 | PPCAPR.PK_PC_PCC | |
PPCAPR.PMOTN_SUB_CATG_T | PK_PSCT_PCC_PSC | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.PMOTN_SUB_CATG_T | NN_PSCT_PSC | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_SCATG_CD" IS NOT N ULL | . |
PPCAPR.PMOTN_SUB_CATG_T | NN_PSCT_LUUI | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_SUB_CATG_T | NN_PSCT_CD | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.PMOTN_SUB_CATG_T | NN_PSCT_LUD | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.PMOTN_SUB_CATG_T | NN_PSCT_CUI | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_SUB_CATG_T | NN_PSCT_PSN | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_SCATG_NM" IS NOT N ULL | . |
PPCAPR.PMOTN_T | NN_PT_IMN | C | ENABLED | 17:40:07 01 /30/08 | "INTR_MKT_NM" IS NOT NULL | . |
PPCAPR.PMOTN_T | NN_PT_PFI | C | ENABLED | 17:40:07 01 /30/08 | "PRO_FORMA_IND" IS NOT NU LL | . |
PPCAPR.PMOTN_T | NN_PT_PCTI | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_CD_TYP_ID" IS NOT NULL | . |
PPCAPR.PMOTN_T | NN_PT_PSI | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_STAT_ID" IS NOT NU LL | . |
PPCAPR.PMOTN_T | NN_PT_CPI | C | ENABLED | 17:40:07 01 /30/08 | "COR_PMOTN_IND" IS NOT NU LL | . |
PPCAPR.PMOTN_T | NN_PT_RSI | C | DISABLED | 17:40:07 01 /30/08 | "RUL_SET_ID" IS NOT NULL | . |
PPCAPR.PMOTN_T | NN_PT_LUUI | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_T | NN_PT_AI | C | ENABLED | 17:40:07 01 /30/08 | "ACTV_IND" IS NOT NULL | . |
PPCAPR.PMOTN_T | NN_PT_PCC | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_CATG_CD" IS NOT NU LL | . |
PPCAPR.PMOTN_T | NN_PT_PATC | C | ENABLED | 17:40:07 01 /30/08 | "PRC_APPL_TYP_CD" IS NOT NULL | . |
PPCAPR.PMOTN_T | NN_PT_CUI | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_T | NN_PT_LUD | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.PMOTN_T | NN_PT_PMN | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_MKT_NM" IS NOT NUL L | . |
PPCAPR.PMOTN_T | NN_PT_PCRI | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_CD_RQM_IND" IS NOT NULL | . |
PPCAPR.PMOTN_T | NN_PT_CD | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.PMOTN_T | NN_PT_PSC | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_SCATG_CD" IS NOT N ULL | . |
PPCAPR.PMOTN_T | NN_PT_PED | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_END_DTTM" IS NOT N ULL | . |
PPCAPR.PMOTN_T | NN_PT_PSD | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_STRT_DTTM" IS NOT NULL | . |
PPCAPR.PMOTN_T | PK_PT_PI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.PMOTN_T | FK_PMT_PATC | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_PAT_PATC | |
PPCAPR.PMOTN_T | FK_PMT_RSI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_RS_RSI | |
PPCAPR.PMOTN_T | FK_PT_ALC | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_ALT_ALC | |
PPCAPR.PMOTN_T | FK_PMT_AI | R | DISABLED | 17:43:07 01 /30/08 | PPCAPR.PK_AT_AI | |
PPCAPR.PMOTN_T | FK_PMT_PCTI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_PCTT_PCTI | |
PPCAPR.PMOTN_T | FK_PMT_PSI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_PST_PSI | |
PPCAPR.PMOTN_T | SYS_C0012586 | R | DISABLED | 17:43:07 01 /30/08 | PPCAPR.PK_PSCT_PCC_PSC | |
PPCAPR.PMOTN_TAB_T | PK_PTT_PI_TN | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.PMOTN_TAB_T | SYS_C0012220 | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.PMOTN_TAB_T | SYS_C0012218 | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.PMOTN_TAB_T | FK_PTT_PI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_PT_PI | |
PPCAPR.PMOTN_TAB_T | SYS_C0012214 | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_ID" IS NOT NULL | . |
PPCAPR.PMOTN_TAB_T | SYS_C0012217 | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.PMOTN_TAB_T | SYS_C0012216 | C | ENABLED | 17:40:07 01 /30/08 | "TAB_CMPL_IND" IS NOT NUL L | . |
PPCAPR.PMOTN_TAB_T | SYS_C0012215 | C | ENABLED | 17:40:07 01 /30/08 | "TAB_NBR" IS NOT NULL | . |
PPCAPR.PMOTN_TAB_T | SYS_C0012219 | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.PRC_APPL_TYP_T | NN_PAT_CD | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.PRC_APPL_TYP_T | NN_PAT_CUI | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.PRC_APPL_TYP_T | NN_PATT_LUUI | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.PRC_APPL_TYP_T | PK_PAT_PATC | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.PRC_APPL_TYP_T | NN_PATT_LUD | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.PRC_T | NN_PRCT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.PRC_T | NN_PRCT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.PRC_T | NN_PRCT_CC | C | ENABLED | 17:40:08 01 /30/08 | "CNCY_CD" IS NOT NULL | . |
PPCAPR.PRC_T | NN_PRCT_PTI | C | ENABLED | 17:40:08 01 /30/08 | "PRC_TYP_ID" IS NOT NULL | . |
PPCAPR.PRC_T | NN_PRCT_CII | C | ENABLED | 17:40:08 01 /30/08 | "CTLG_ITM_ID" IS NOT NULL | . |
PPCAPR.PRC_T | NN_PRCT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.PRC_T | NN_PRCT_PSD | C | ENABLED | 17:40:08 01 /30/08 | "PRC_STRT_DT" IS NOT NULL | . |
PPCAPR.PRC_T | SYS_C0012328 | C | ENABLED | 17:40:08 01 /30/08 | "ITM_PRC_ID" IS NOT NULL | . |
PPCAPR.PRC_T | PK_PRCT_IPI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.PRC_T | NN_PRCT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.PRC_TYP_T | PL_PTT_PTI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.PRC_TYP_T | NN_PTT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.PRC_TYP_T | NN_PTT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.PRC_TYP_T | NN_PTT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.PRC_TYP_T | NN_PTT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.PRC_TYP_T | NN_PTT_PTI | C | ENABLED | 17:40:08 01 /30/08 | "PRC_TYP_ID" IS NOT NULL | . |
PPCAPR.RUL_SET_STAT_T | SYS_C0012230 | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.RUL_SET_STAT_T | SYS_C0012225 | C | ENABLED | 17:40:07 01 /30/08 | "RUL_SET_STAT_ID" IS NOT NULL | . |
PPCAPR.RUL_SET_STAT_T | SYS_C0012226 | C | ENABLED | 17:40:07 01 /30/08 | "RUL_SET_STAT_NM" IS NOT NULL | . |
PPCAPR.RUL_SET_STAT_T | SYS_C0012227 | C | ENABLED | 17:40:07 01 /30/08 | "RUL_SET_STAT_DESC" IS NO T NULL | . |
PPCAPR.RUL_SET_STAT_T | PK_RSST_RSSI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.RUL_SET_STAT_T | SYS_C0012228 | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.RUL_SET_STAT_T | SYS_C0012229 | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.RUL_SET_STAT_T | SYS_C0012231 | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.RUL_SET_T | FK_RST_RSSI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_RSST_RSSI | |
PPCAPR.RUL_SET_T | PK_RS_RSI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.RUL_SET_T | NN_RS_CD | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.RUL_SET_T | NN_RST_LUD | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.RUL_SET_T | NN_RS_CUI | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.RUL_SET_T | NN_RST_LUUI | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.RUL_T | NN_RT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.RUL_T | NN_RT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.RUL_T | NN_RT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.RUL_T | PK_RT_RI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.RUL_T | NN_RT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.RUL_TIER_T | FK_RT_RI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_RT_RI | |
PPCAPR.RUL_TIER_T | NN_RTT_RSI | C | ENABLED | 17:40:07 01 /30/08 | "RUL_SET_ID" IS NOT NULL | . |
PPCAPR.RUL_TIER_T | NN_RTT_ROSN | C | ENABLED | 17:40:07 01 /30/08 | "RUL_ORD_SEQ_NBR" IS NOT NULL | . |
PPCAPR.RUL_TIER_T | NN_RTT_LUD | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.RUL_TIER_T | NN_RTT_CUI | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.RUL_TIER_T | NN_RTT_LUUI | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.RUL_TIER_T | NN_RTT_RI | C | ENABLED | 17:40:07 01 /30/08 | "RUL_ID" IS NOT NULL | . |
PPCAPR.RUL_TIER_T | SYS_C0012237 | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.RUL_TIER_T | FK_RT_RSI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_RS_RSI | |
PPCAPR.RUL_TIER_T | PK_RTT_RTI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.RUL_T_TMP | SYS_C0012474 | C | ENABLED | 17:40:08 01 /30/08 | "RUL_ID" IS NOT NULL | . |
PPCAPR.RUL_T_TMP | SYS_C0012478 | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.RUL_T_TMP | SYS_C0012477 | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.RUL_T_TMP | SYS_C0012476 | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.RUL_T_TMP | SYS_C0012475 | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.SCHEMA_AUD_LOG_T | NN_SALT_CA | C | ENABLED | 17:40:08 01 /30/08 | "CLEAN_APPL" IS NOT NULL | . |
PPCAPR.SCHEMA_AUD_LOG_T | NN_GID_SALT_OI | C | ENABLED | 17:40:08 01 /30/08 | "OVRWRITE_IND" IS NOT NUL L | . |
PPCAPR.SCHEMA_AUD_LOG_T | NN_GID_SALT_AD | C | ENABLED | 17:40:08 01 /30/08 | "APPL_DTTM" IS NOT NULL | . |
PPCAPR.SCHEMA_AUD_LOG_T | NN_GID_SALT_SP | C | ENABLED | 17:40:08 01 /30/08 | "SVN_PATH" IS NOT NULL | . |
PPCAPR.SCHEMA_AUD_LOG_T | NN_GID_SALT_RV | C | ENABLED | 17:40:08 01 /30/08 | "RLSE_VAL" IS NOT NULL | . |
PPCAPR.SCHEMA_AUD_LOG_T | NN_GID_SALT_SFN | C | ENABLED | 17:40:08 01 /30/08 | "SVN_FIL_NM" IS NOT NULL | . |
PPCAPR.SCHEMA_AUD_LOG_T | NN_GID_SALT_SAI | C | ENABLED | 17:40:08 01 /30/08 | "SCHEMA_AUD_ID" IS NOT NU LL | . |
PPCAPR.SCHEMA_AUD_LOG_T | PK_GID_SALT_SAI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.SCHEMA_VER_T | NN_GID_SVT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.SCHEMA_VER_T | NN_GID_SVT_AD | C | ENABLED | 17:40:08 01 /30/08 | "APPL_DTTM" IS NOT NULL | . |
PPCAPR.SCHEMA_VER_T | NN_GID_SVT_DSN | C | ENABLED | 17:40:08 01 /30/08 | "DEPLOY_SCRIPT_NM" IS NOT NULL | . |
PPCAPR.SCHEMA_VER_T | NN_GID_SVT_RV | C | ENABLED | 17:40:08 01 /30/08 | "RLSE_VAL" IS NOT NULL | . |
PPCAPR.SCHEMA_VER_T | NN_SVT_CA | C | ENABLED | 17:40:08 01 /30/08 | "CLEAN_APPL" IS NOT NULL | . |
PPCAPR.SCHEMA_VER_T | PK_GID_SVT_RV | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.SHP_CHRG_TIER_T | SYS_C0012247 | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.SHP_CHRG_TIER_T | SYS_C0012248 | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.SHP_CHRG_TIER_T | SYS_C0012244 | C | ENABLED | 17:40:07 01 /30/08 | "SHP_OPT_ID" IS NOT NULL | . |
PPCAPR.SHP_CHRG_TIER_T | SYS_C0012245 | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.SHP_CHRG_TIER_T | SYS_C0012246 | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.SHP_CHRG_TIER_T | FK_SCTT_BC_CC | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_BCA_BC_CHC | |
PPCAPR.SHP_CHRG_TIER_T | PK_SCTT_SCTN_SOI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.SHP_CHRG_TIER_T | SYS_C0012243 | C | ENABLED | 17:40:07 01 /30/08 | "SHP_CHRG_TIER_NBR" IS NO T NULL | . |
PPCAPR.SHP_CHRG_TIER_T | FK_SCTT_SOI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_SOT_SOI | |
PPCAPR.SHP_OPT_BRD_T | FK_SOBT_SOT_SOI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_BT_BC | |
PPCAPR.SHP_OPT_BRD_T | FK_SOBT_BT_BC | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_SOT_SOI | |
PPCAPR.SHP_OPT_BRD_T | PK_SOBT_SOBI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.SHP_OPT_BRD_T | NN_SOBT_SOBI | C | ENABLED | 17:40:07 01 /30/08 | "SHP_OPT_BRD_ID" IS NOT N ULL | . |
PPCAPR.SHP_OPT_BRD_T | NN_SOBT_BC | C | ENABLED | 17:40:07 01 /30/08 | "BRD_CD" IS NOT NULL | . |
PPCAPR.SHP_OPT_BRD_T | NN_SOBT_SOI | C | ENABLED | 17:40:07 01 /30/08 | "SHP_OPT_ID" IS NOT NULL | . |
PPCAPR.SHP_OPT_BRD_T | NN_SOBT_MINDDC | C | ENABLED | 17:40:07 01 /30/08 | "MIN_DLVR_DY_CNT" IS NOT NULL | . |
PPCAPR.SHP_OPT_BRD_T | NN_SOBT_MAXDDC | C | ENABLED | 17:40:07 01 /30/08 | "MAX_DLVR_DY_CNT" IS NOT NULL | . |
PPCAPR.SHP_OPT_BRD_T | NN_SOBT_ESD | C | ENABLED | 17:40:07 01 /30/08 | "EFF_STRT_DTTM" IS NOT NU LL | . |
PPCAPR.SHP_OPT_BRD_T | NN_SOBT_END | C | ENABLED | 17:40:07 01 /30/08 | "EFF_END_DTTM" IS NOT NUL L | . |
PPCAPR.SHP_OPT_BRD_T | NN_SOBT_CD | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.SHP_OPT_BRD_T | NN_SOBT_LUD | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.SHP_OPT_T | SYS_C0012259 | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.SHP_OPT_T | PK_SOT_SOI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.SHP_OPT_T | SYS_C0012262 | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.SHP_OPT_T | SYS_C0012261 | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.SHP_OPT_T | SYS_C0012260 | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.SHP_OPT_T | FK_SOT_BC | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_STT_STI | |
PPCAPR.SHP_OPT_T | SYS_C0012263 | C | ENABLED | 17:40:07 01 /30/08 | "SHP_TYP_ID" IS NOT NULL | . |
PPCAPR.SHP_OPT_T | SYS_C0012258 | C | ENABLED | 17:40:07 01 /30/08 | "SHP_OPT_ID" IS NOT NULL | . |
PPCAPR.SHP_TYP_T | PK_STT_STI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.SHP_TYP_T | SYS_C0012268 | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.SHP_TYP_T | SYS_C0012264 | C | ENABLED | 17:40:07 01 /30/08 | "SHP_TYP_ID" IS NOT NULL | . |
PPCAPR.SHP_TYP_T | SYS_C0012265 | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.SHP_TYP_T | SYS_C0012266 | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.SHP_TYP_T | SYS_C0012267 | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.SPSR_T | PK_ST_SI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.SPSR_T | NN_ST_LUUI | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.SPSR_T | NN_ST_CUI | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.SPSR_T | NN_ST_SI | C | ENABLED | 17:40:07 01 /30/08 | "SPSR_ID" IS NOT NULL | . |
PPCAPR.SPSR_T | NN_ST_CD | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.SPSR_T | NN_ST_SN | C | ENABLED | 17:40:07 01 /30/08 | "SPSR_NM" IS NOT NULL | . |
PPCAPR.SPSR_T | NN_ST_LUD | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.STG_73_FEED_DTL_T | NN_S7FDT_KMII | C | ENABLED | 17:40:08 01 /30/08 | "KNOWN_MDSE_ITM_IND" IS N OT NULL | . |
PPCAPR.STG_73_FEED_DTL_T | FK_S7FDT_SPFI | R | ENABLED | 17:43:22 01 /30/08 | PPCAPR.PK_SPFT_SPFI | |
PPCAPR.STG_73_FEED_DTL_T | PK_S7FDT_SPFI_PFEN | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.STG_73_FEED_DTL_T | NN_SPFDT_PFEN | C | ENABLED | 17:40:08 01 /30/08 | "PRC_FEED_ENT_NBR" IS NOT NULL | . |
PPCAPR.STG_73_FEED_DTL_T | NN_SPFDT_MCI | C | ENABLED | 17:40:08 01 /30/08 | "MDSE_CO_ID" IS NOT NULL | . |
PPCAPR.STG_73_FEED_DTL_T | NN_SPFDT_BC | C | ENABLED | 17:40:08 01 /30/08 | "BRD_CD" IS NOT NULL | . |
PPCAPR.STG_73_FEED_DTL_T | NN_SPFDT_RI | C | ENABLED | 17:40:08 01 /30/08 | "REQ_ID" IS NOT NULL | . |
PPCAPR.STG_73_FEED_DTL_T | NN_SPFDT_LSCC | C | ENABLED | 17:40:08 01 /30/08 | "LGCY_STY_CLR_CD" IS NOT NULL | . |
PPCAPR.STG_73_FEED_DTL_T | NN_SPFDT_PA | C | ENABLED | 17:40:08 01 /30/08 | "PRC_AMT" IS NOT NULL | . |
PPCAPR.STG_73_FEED_DTL_T | NN_SPFDT_ESD | C | ENABLED | 17:40:08 01 /30/08 | "EFF_STRT_DTTM" IS NOT NU LL | . |
PPCAPR.STG_73_FEED_DTL_T | NN_SPFDT_SSI | C | ENABLED | 17:40:08 01 /30/08 | "STY_STAT_IND" IS NOT NUL L | . |
PPCAPR.STG_73_FEED_DTL_T | NN_SPFDT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.STG_73_FEED_DTL_T | NN_SPFDT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.STG_73_FEED_DTL_T | NN_SPFDT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.STG_73_FEED_DTL_T | NN_SPFDT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.STG_73_FEED_DTL_T | NN_S7FDT_OSSI | C | ENABLED | 17:40:08 01 /30/08 | "OVRD_STY_STAT_IND" IS NO T NULL | . |
PPCAPR.STG_73_FEED_DTL_T | NN_SPFDT_SPFI | C | ENABLED | 17:40:08 01 /30/08 | "STG_PRC_FEED_ID" IS NOT NULL | . |
PPCAPR.STG_92_FEED_DTL_T | FK_S9FDT_SPFI | R | ENABLED | 17:43:22 01 /30/08 | PPCAPR.PK_SPFT_SPFI | |
PPCAPR.STG_92_FEED_DTL_T | PK_S9FDT_SPFI_PFEN | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.STG_92_FEED_DTL_T | NN_S9FDT_SPFI | C | ENABLED | 17:40:08 01 /30/08 | "STG_PRC_FEED_ID" IS NOT NULL | . |
PPCAPR.STG_92_FEED_DTL_T | NN_S9FDT_PFEN | C | ENABLED | 17:40:08 01 /30/08 | "PRC_FEED_ENT_NBR" IS NOT NULL | . |
PPCAPR.STG_92_FEED_DTL_T | NN_S9FDT_MCI | C | ENABLED | 17:40:08 01 /30/08 | "MDSE_CO_ID" IS NOT NULL | . |
PPCAPR.STG_92_FEED_DTL_T | NN_S9FDT_BC | C | ENABLED | 17:40:08 01 /30/08 | "BRD_CD" IS NOT NULL | . |
PPCAPR.STG_92_FEED_DTL_T | NN_S9FDT_RI | C | ENABLED | 17:40:08 01 /30/08 | "REQ_ID" IS NOT NULL | . |
PPCAPR.STG_92_FEED_DTL_T | NN_S9FDT_LSCC | C | ENABLED | 17:40:08 01 /30/08 | "LGCY_STY_CLR_CD" IS NOT NULL | . |
PPCAPR.STG_92_FEED_DTL_T | NN_S9FDT_PA | C | ENABLED | 17:40:08 01 /30/08 | "PRC_AMT" IS NOT NULL | . |
PPCAPR.STG_92_FEED_DTL_T | NN_S9FDT_ESD | C | ENABLED | 17:40:08 01 /30/08 | "EFF_STRT_DTTM" IS NOT NU LL | . |
PPCAPR.STG_92_FEED_DTL_T | NN_S9FDT_SSI | C | ENABLED | 17:40:08 01 /30/08 | "STY_STAT_IND" IS NOT NUL L | . |
PPCAPR.STG_92_FEED_DTL_T | NN_S9FDT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.STG_92_FEED_DTL_T | NN_S9FDT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.STG_92_FEED_DTL_T | NN_S9FDT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.STG_92_FEED_DTL_T | NN_S9FDT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.STG_92_FEED_DTL_T | NN_S9FDT_KMII | C | ENABLED | 17:40:08 01 /30/08 | "KNOWN_MDSE_ITM_IND" IS N OT NULL | . |
PPCAPR.STG_92_FEED_DTL_T | NN_S9FDT_EED | C | ENABLED | 17:40:08 01 /30/08 | "EFF_END_DTTM" IS NOT NUL L | . |
PPCAPR.STG_MUP_FEED_T | SYS_C0012288 | C | ENABLED | 17:40:07 01 /30/08 | "STY_STAT_IND" IS NOT NUL L | . |
PPCAPR.STG_MUP_FEED_T | SYS_C0012287 | C | ENABLED | 17:40:07 01 /30/08 | "MUP_IND" IS NOT NULL | . |
PPCAPR.STG_MUP_FEED_T | SYS_C0012286 | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_IND" IS NOT NULL | . |
PPCAPR.STG_MUP_FEED_T | SYS_C0012285 | C | ENABLED | 17:40:07 01 /30/08 | "LGCY_STY_CLR_CD" IS NOT NULL | . |
PPCAPR.STG_MUP_FEED_T | SYS_C0012284 | C | ENABLED | 17:40:07 01 /30/08 | "LGCY_MKT_CD" IS NOT NULL | . |
PPCAPR.STG_MUP_FEED_T | NN_SMFT_EED | C | ENABLED | 17:40:07 01 /30/08 | "EFF_END_DTTM" IS NOT NUL L | . |
PPCAPR.STG_MUP_FEED_T | SYS_C0012282 | C | ENABLED | 17:40:07 01 /30/08 | "LGCY_STY_CD" IS NOT NULL | . |
PPCAPR.STG_MUP_FEED_T | SYS_C0012281 | C | ENABLED | 17:40:07 01 /30/08 | "EFF_STRT_DTTM" IS NOT NU LL | . |
PPCAPR.STG_MUP_FEED_T | SYS_C0012280 | C | ENABLED | 17:40:07 01 /30/08 | "GRP_ID" IS NOT NULL | . |
PPCAPR.STG_MUP_FEED_T | SYS_C0012279 | C | ENABLED | 17:40:07 01 /30/08 | "DSCT_AMT" IS NOT NULL | . |
PPCAPR.STG_MUP_FEED_T | SYS_C0012278 | C | ENABLED | 17:40:07 01 /30/08 | "QUAL_QTY" IS NOT NULL | . |
PPCAPR.STG_MUP_FEED_T | NN_SMFT_CUI | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.STG_MUP_FEED_T | SYS_C0012276 | C | ENABLED | 17:40:07 01 /30/08 | "MDSE_CO_ID" IS NOT NULL | . |
PPCAPR.STG_MUP_FEED_T | SYS_C0012275 | C | ENABLED | 17:40:07 01 /30/08 | "BRD_CD" IS NOT NULL | . |
PPCAPR.STG_MUP_FEED_T | FK_SMFT_MTC | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_MUP_TYP_T | |
PPCAPR.STG_MUP_FEED_T | FK_SMFT_NRI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_MNRT_NRI | |
PPCAPR.STG_MUP_FEED_T | NN_SMFT_KMII | C | ENABLED | 17:40:07 01 /30/08 | "KNOWN_MDSE_ITM_IND" IS N OT NULL | . |
PPCAPR.STG_MUP_FEED_T | NN_SMFT_LUUI | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.STG_MUP_FEED_T | NN_SMFT_LUD | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.STG_MUP_FEED_T | NN_SMFT_CD | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.STG_MUP_FEED_T | SYS_C0012290 | C | ENABLED | 17:40:07 01 /30/08 | "MULT_RQM_IND" IS NOT NUL L | . |
PPCAPR.STG_MUP_FEED_T | SYS_C0012289 | C | ENABLED | 17:40:07 01 /30/08 | "SRC_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.STG_PRC_FEED_STAT_CD_T | NN_SPFSCT_SC | C | ENABLED | 17:40:08 01 /30/08 | "STAT_CD" IS NOT NULL | . |
PPCAPR.STG_PRC_FEED_STAT_CD_T | NN_SPFSCT_SN | C | ENABLED | 17:40:08 01 /30/08 | "STAT_NAME" IS NOT NULL | . |
PPCAPR.STG_PRC_FEED_STAT_CD_T | NN_SPFSCT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.STG_PRC_FEED_STAT_CD_T | NN_SPFSCT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.STG_PRC_FEED_STAT_CD_T | NN_SPFSCT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.STG_PRC_FEED_STAT_CD_T | NN_SPFSCT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.STG_PRC_FEED_STAT_CD_T | PK_SPFSCT_SC | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.STG_PRC_FEED_STAT_CD_T | NN_SPFSCT_SD | C | ENABLED | 17:40:08 01 /30/08 | "STAT_DESC" IS NOT NULL | . |
PPCAPR.STG_PRC_FEED_T | PK_SPFT_SPFI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.STG_PRC_FEED_T | FK_SPFT_SC | R | ENABLED | 17:43:05 01 /30/08 | PPCAPR.PK_SPFSCT_SC | |
PPCAPR.STG_PRC_FEED_T | FK_SPFT_FTC | R | ENABLED | 17:43:05 01 /30/08 | PPCAPR.PK_SPFTT_FTC | |
PPCAPR.STG_PRC_FEED_T | NN_SPFT_FTC | C | ENABLED | 17:40:08 01 /30/08 | "FEED_TYP_CD" IS NOT NULL | . |
PPCAPR.STG_PRC_FEED_T | NN_SPFT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.STG_PRC_FEED_T | NN_SPFT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.STG_PRC_FEED_T | NN_SPFT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.STG_PRC_FEED_T | NN_SPFT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.STG_PRC_FEED_T | NN_SPFT_SC | C | ENABLED | 17:40:08 01 /30/08 | "STAT_CD" IS NOT NULL | . |
PPCAPR.STG_PRC_FEED_T | NN_SPFT_SPFI | C | ENABLED | 17:40:08 01 /30/08 | "STG_PRC_FEED_ID" IS NOT NULL | . |
PPCAPR.STG_PRC_FEED_TYP_T | NN_SPFTT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.STG_PRC_FEED_TYP_T | PK_SPFTT_FTC | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.STG_PRC_FEED_TYP_T | NN_SPFTT_FTC | C | ENABLED | 17:40:08 01 /30/08 | "FEED_TYP_CD" IS NOT NULL | . |
PPCAPR.STG_PRC_FEED_TYP_T | NN_SPFTT_FTD | C | ENABLED | 17:40:08 01 /30/08 | "FEED_TYP_DESC" IS NOT NU LL | . |
PPCAPR.STG_PRC_FEED_TYP_T | NN_SPFTT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.STG_PRC_FEED_TYP_T | NN_SPFTT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.STG_PRC_FEED_TYP_T | NN_SPFTT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.STG_SUP_FEED_T | FK_SSFT_NRI | R | ENABLED | 17:43:22 01 /30/08 | PPCAPR.PK_MNRT_NRI | |
PPCAPR.STG_SUP_FEED_T | PK_SSFT_SSFI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_MRI | C | ENABLED | 17:40:08 01 /30/08 | "MULT_RQM_IND" IS NOT NUL L | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_KMII | C | ENABLED | 17:40:08 01 /30/08 | "KNOWN_MDSE_ITM_IND" IS N OT NULL | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_SSFI | C | ENABLED | 17:40:08 01 /30/08 | "STG_SUP_FEED_ID" IS NOT NULL | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_BC | C | ENABLED | 17:40:08 01 /30/08 | "BRD_CD" IS NOT NULL | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_MCI | C | ENABLED | 17:40:08 01 /30/08 | "MDSE_CO_ID" IS NOT NULL | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_QQ | C | ENABLED | 17:40:08 01 /30/08 | "QUAL_QTY" IS NOT NULL | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_DA | C | ENABLED | 17:40:08 01 /30/08 | "DSCT_AMT" IS NOT NULL | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_GI | C | ENABLED | 17:40:08 01 /30/08 | "GRP_ID" IS NOT NULL | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_ESD | C | ENABLED | 17:40:08 01 /30/08 | "EFF_STRT_DTTM" IS NOT NU LL | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_LSC | C | ENABLED | 17:40:08 01 /30/08 | "LGCY_STY_CD" IS NOT NULL | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_EED | C | ENABLED | 17:40:08 01 /30/08 | "EFF_END_DTTM" IS NOT NUL L | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_LMC | C | ENABLED | 17:40:08 01 /30/08 | "LGCY_MKT_CD" IS NOT NULL | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_LSCC | C | ENABLED | 17:40:08 01 /30/08 | "LGCY_STY_CLR_CD" IS NOT NULL | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_PI | C | ENABLED | 17:40:08 01 /30/08 | "PMOTN_IND" IS NOT NULL | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_MI | C | ENABLED | 17:40:08 01 /30/08 | "MUP_IND" IS NOT NULL | . |
PPCAPR.STG_SUP_FEED_T | FK_SSFT_MTC | R | ENABLED | 17:43:22 01 /30/08 | PPCAPR.PK_MUP_TYP_T | |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_SUD | C | ENABLED | 17:40:08 01 /30/08 | "SRC_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.STG_SUP_FEED_T | NN_SSFT_SSI | C | ENABLED | 17:40:08 01 /30/08 | "STY_STAT_IND" IS NOT NUL L | . |
PPCAPR.USE_LMT_T | FK_UL_BC | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_BT_BC | |
PPCAPR.USE_LMT_T | FK_UL_BC_CHC | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_BCA_BC_CHC | |
PPCAPR.USE_LMT_T | FK_UL_ULTI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_ULT_ULTI | |
PPCAPR.USE_LMT_T | PK_UL_ULI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.USE_LMT_T | NN_UL_ULI | C | ENABLED | 17:40:07 01 /30/08 | "USE_LMT_ID" IS NOT NULL | . |
PPCAPR.USE_LMT_T | FK_ULT_CCTI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_CCTT_CCTI | |
PPCAPR.USE_LMT_T | NN_UL_ULTI | C | ENABLED | 17:40:07 01 /30/08 | "USE_LMT_TYP_ID" IS NOT N ULL | . |
PPCAPR.USE_LMT_T | NN_ULT_LUUI | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.USE_LMT_T | NN_UL_CUI | C | ENABLED | 17:40:07 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.USE_LMT_T | NN_ULT_LUD | C | ENABLED | 17:40:07 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.USE_LMT_T | SYS_C0012298 | C | ENABLED | 17:40:07 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.USE_LMT_T | NN_ULT_PI | C | ENABLED | 17:40:07 01 /30/08 | "PMOTN_ID" IS NOT NULL | . |
PPCAPR.USE_LMT_T | FK_UL_PI | R | ENABLED | 17:43:07 01 /30/08 | PPCAPR.PK_PT_PI | |
PPCAPR.USE_LMT_TYP_T | NN_ULT_CD | C | ENABLED | 17:40:08 01 /30/08 | "CRT_DTTM" IS NOT NULL | . |
PPCAPR.USE_LMT_TYP_T | NN_ULTT_LUD | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_DTTM" IS NOT NU LL | . |
PPCAPR.USE_LMT_TYP_T | NN_ULT_CUI | C | ENABLED | 17:40:08 01 /30/08 | "CRT_USER_ID" IS NOT NULL | . |
PPCAPR.USE_LMT_TYP_T | NN_ULTT_LUUI | C | ENABLED | 17:40:08 01 /30/08 | "LST_UPDT_USER_ID" IS NOT NULL | . |
PPCAPR.USE_LMT_TYP_T | NN_ULTT_ULTN | C | ENABLED | 17:40:08 01 /30/08 | "USE_LMT_TYP_NM" IS NOT N ULL | . |
PPCAPR.USE_LMT_TYP_T | PK_ULT_ULTI | P | ENABLED | 17:43:03 01 /30/08 | . | |
PPCAPR.ZIPCD_OPT_ROLLUP_T | PK_ZORT_Z_NDDI | P | ENABLED | 17:40:06 01 /30/08 | . | |
PPCAPR.ZIPCD_OPT_ROLLUP_T | NN_ZORT_Z | C | ENABLED | 17:40:06 01 /30/08 | "ZIPCD" IS NOT NULL | . |
PPCAPR.ZIPCD_OPT_ROLLUP_T | NN_ZORT_NDDI | C | ENABLED | 17:40:06 01 /30/08 | "NXT_DY_DEL_IND" IS NOT N ULL | . |
PPCAPR.ZIPCD_OPT_ROLLUP_T | NN_ZORT_TLD | C | ENABLED | 17:40:06 01 /30/08 | "TBL_LD_DTTM" IS NOT NULL | . |
709 rows selected.
++ List INDEXES on TABLES ++
Table | TABLE_TYPE | INDEX_NAME | INDEX_TYPE | FUNCIDX_ST |
---|---|---|---|---|
PPCAPR.APPL_ST_T | TABLE | PK_AST_ASI | NORMAL | |
PPCAPR.APSE_LVL_T | TABLE | PK_ALT_ALC | NORMAL | |
PPCAPR.ARCV_EV_T | TABLE | PK_AET_EI | NORMAL | |
PPCAPR.AWRD_ARBT_TYP_T | TABLE | PK_ABTT_AATC | NORMAL | |
PPCAPR.AWRD_CALC_LVL_T | TABLE | PK_ACL_ACLI | NORMAL | |
PPCAPR.AWRD_T | TABLE | PK_AT_AI | NORMAL | |
PPCAPR.AWRD_TYP_T | TABLE | PK_ATT_ATI | NORMAL | |
PPCAPR.A_B_TST_BKT_T | TABLE | PK_ABTBT_TBI | NORMAL | |
PPCAPR.A_B_TST_GRP_T | TABLE | SYS_C0012486 | NORMAL | |
PPCAPR.BRD_CHNL_ASSN_T | TABLE | PK_BCA_BC_CHC | NORMAL | |
PPCAPR.BRD_CHNL_PMOTN_ASSN_T | TABLE | PK_BCPA_PI_BC_CHC | NORMAL | |
PPCAPR.BRD_RUL_ASSN_T | TABLE | PK_BRAT_BC_RI | NORMAL | |
PPCAPR.BRD_T | TABLE | PK_BT_BC | NORMAL | |
PPCAPR.CD_REQ_STAT_TYP_T | TABLE | PK_CRST_CRSTI | NORMAL | |
PPCAPR.CD_REQ_T | TABLE | PK_CR_CRI | NORMAL | |
PPCAPR.CHNL_PMOTN_ASSN_T | TABLE | PK_CPAT_CC_PI | NORMAL | |
PPCAPR.CHNL_T | TABLE | PK_CT_CHC | NORMAL | |
PPCAPR.CMPL_PRC_T | TABLE | PK_CPT_PPI | NORMAL | |
PPCAPR.CMPL_PRC_T | TABLE | INDX_CPT_CII | NORMAL | |
PPCAPR.CMPL_PRC_T | TABLE | FK_CPT_LPI | NORMAL | |
PPCAPR.CMPL_PRC_T | TABLE | FK_CPT_PTI | NORMAL | |
PPCAPR.CMPL_PRC_T | TABLE | FK_CPT_CC | NORMAL | |
PPCAPR.CMPL_PRC_T | TABLE | INDX_CPT_CC_CII_PED_PSD_PTI | NORMAL | |
PPCAPR.CNCY_T | TABLE | PK_CNCYT_CC | NORMAL | |
PPCAPR.CND_BRD_T | TABLE | PK_CBT_CBI | NORMAL | |
PPCAPR.CND_STY_CLR_T | TABLE | INDX_CSCT_CBI | NORMAL | |
PPCAPR.CND_STY_CLR_T | TABLE | PK_CSCT_SCBI_BC_CBI | NORMAL | |
PPCAPR.CND_T | TABLE | PK_CT_CI | NORMAL | |
PPCAPR.CND_TYP_T | TABLE | PK_CTT_CTI | NORMAL | |
PPCAPR.CR_CRD_TYP_T | TABLE | PK_CCTT_CCTI | NORMAL | |
PPCAPR.CTLG_ITM_TYP_T | TABLE | PK_CITT_CITI | NORMAL | |
PPCAPR.DSCT_TYP_T | TABLE | PK_DT_DTC | NORMAL | |
PPCAPR.EV_T | TABLE | PK_ET_EI | NORMAL | |
PPCAPR.EXP_CATG_T | TABLE | PK_ECT_PRI | NORMAL | |
PPCAPR.FLAT_PRC_T | TABLE | PK_FPT_FPI | NORMAL | |
PPCAPR.FLAT_PRC_T | TABLE | INDX_FPT_PSD_PED_PTI | NORMAL | |
PPCAPR.FLAT_PRC_T | TABLE | FK_FPT_LPI | NORMAL | |
PPCAPR.FLAT_PRC_T | TABLE | FK_FPT_PTI | NORMAL | |
PPCAPR.FLAT_PRC_T | TABLE | FK_FPT_CC | NORMAL | |
PPCAPR.LST_PRC_T | TABLE | PK_LPT_LPI | NORMAL | |
PPCAPR.MPP_LIST_PRD_T | TABLE | NU_MLPT_MLI | NORMAL | |
PPCAPR.MPP_LIST_PRD_T | TABLE | PK_MLPT_BI_MLI | NORMAL | |
PPCAPR.MPP_LIST_T | TABLE | NU_MLT_ESD_EED_BD | NORMAL | |
PPCAPR.MPP_LIST_T | TABLE | PK_MLT_MLI | NORMAL | |
PPCAPR.MPP_PRD_MSG_T | TABLE | NU_MPMT_BI_MPTI | NORMAL | |
PPCAPR.MPP_PRD_MSG_T | TABLE | NU_MPMT_IDX | NORMAL | |
PPCAPR.MPP_PRD_MSG_T | TABLE | PK_MPMT_MPMI | NORMAL | |
PPCAPR.MPP_PRD_MSG_TYP_T | TABLE | PK_MPMTT_MPMTI | NORMAL | |
PPCAPR.MPP_TYP_T | TABLE | PK_MTT_MTI | NORMAL | |
PPCAPR.MSG_PRTY_TYP_T | TABLE | NU_MPTT_MPTI | NORMAL | |
PPCAPR.MUP_ID_MAP_T | TABLE | PK_MIMT_MI | NORMAL | |
PPCAPR.MUP_ID_MAP_T | TABLE | UK_MIMT_GI_BC_MCI_EST_EET | NORMAL | |
PPCAPR.MUP_NACTV_RSN_T | TABLE | PK_MNRT_NRI | NORMAL | |
PPCAPR.MUP_STY_CLR_T | TABLE | PK_MSCT_MI_MSCI | NORMAL | |
PPCAPR.MUP_STY_CLR_T | TABLE | NU_MSCT_MI | NORMAL | |
PPCAPR.MUP_STY_CLR_T | TABLE | NU_MSCT_LSC_LSCC_LMC | NORMAL | |
PPCAPR.MUP_T | TABLE | PK_MT_MI | NORMAL | |
PPCAPR.MUP_TYP_T | TABLE | PK_MUP_TYP_T | NORMAL | |
PPCAPR.PMOTN_CATG_T | TABLE | PK_PC_PCC | NORMAL | |
PPCAPR.PMOTN_CD_ASSN_T | TABLE | PK_PCA_PI_PC1 | NORMAL | |
PPCAPR.PMOTN_CD_ASSN_T | TABLE | PMOTN_CD_ASSN_T_IDX1 | NORMAL | |
PPCAPR.PMOTN_CD_ASSN_T | TABLE | IDX_PCA_PI1 | NORMAL | |
PPCAPR.PMOTN_CD_TYP_T | TABLE | PK_PCTT_PCTI | NORMAL | |
PPCAPR.PMOTN_CHG_HIST_T | TABLE | PK_PCH_PCHI | NORMAL | |
PPCAPR.PMOTN_HIST_TYP_T | TABLE | PK_PHT_PHTC | NORMAL | |
PPCAPR.PMOTN_NTE_T | TABLE | PK_PN_PNI | NORMAL | |
PPCAPR.PMOTN_RUL_TIER_T | TABLE | PK_PRT_PRTI | NORMAL | |
PPCAPR.PMOTN_SPSR_T | TABLE | PK_PST_PI_SI | NORMAL | |
PPCAPR.PMOTN_STAT_TYP_T | TABLE | PK_PST_PSI | NORMAL | |
PPCAPR.PMOTN_SUB_CATG_T | TABLE | PK_PSCT_PCC_PSC | NORMAL | |
PPCAPR.PMOTN_T | TABLE | PK_PT_PI | NORMAL | |
PPCAPR.PMOTN_TAB_T | TABLE | PK_PTT_PI_TN | NORMAL | |
PPCAPR.PRC_APPL_TYP_T | TABLE | PK_PAT_PATC | NORMAL | |
PPCAPR.PRC_T | TABLE | UK_PRCT_CC_CII_PED_PSD_PTI | NORMAL | |
PPCAPR.PRC_T | TABLE | IDX_PRCT_PTI | NORMAL | |
PPCAPR.PRC_T | TABLE | PK_PRCT_IPI | NORMAL | |
PPCAPR.PRC_T | TABLE | IDX_PRCT_CII | NORMAL | |
PPCAPR.PRC_T | TABLE | IDX_PRCT_CII_PTI | NORMAL | |
PPCAPR.PRC_TYP_T | TABLE | PK_PTT_PTI | NORMAL | |
PPCAPR.RUL_SET_STAT_T | TABLE | PK_RSST_RSSI | NORMAL | |
PPCAPR.RUL_SET_T | TABLE | PK_RS_RSI | NORMAL | |
PPCAPR.RUL_T | TABLE | PK_RT_RI | NORMAL | |
PPCAPR.RUL_T | TABLE | SYS_IL0000061903C00009$$ | LOB | |
PPCAPR.RUL_TIER_T | TABLE | PK_RTT_RTI | NORMAL | |
PPCAPR.RUL_T_TMP | TABLE | SYS_IL0000061906C00009$$ | LOB | |
PPCAPR.SCHEMA_AUD_LOG_T | TABLE | PK_GID_SALT_SAI | NORMAL | |
PPCAPR.SCHEMA_VER_T | TABLE | PK_GID_SVT_RV | NORMAL | |
PPCAPR.SHP_CHRG_TIER_T | TABLE | PK_SCTT_SCTN_SOI | NORMAL | |
PPCAPR.SHP_OPT_BRD_T | TABLE | PK_SOBT_SOBI | NORMAL | |
PPCAPR.SHP_OPT_T | TABLE | PK_SOT_SOI | NORMAL | |
PPCAPR.SHP_OPT_T | TABLE | UK_SOT_SON | NORMAL | |
PPCAPR.SHP_TYP_T | TABLE | PK_STT_STI | NORMAL | |
PPCAPR.SHP_TYP_T | TABLE | UK_SOT_SONN | NORMAL | |
PPCAPR.SPSR_T | TABLE | PK_ST_SI | NORMAL | |
PPCAPR.STATTAB | TABLE | STATTAB | NORMAL | |
PPCAPR.STG_73_FEED_DTL_T | TABLE | PK_S7FDT_SPFI_PFEN | NORMAL | |
PPCAPR.STG_73_FEED_DTL_T | TABLE | IDX_S7FDT_F_KMII | FUNCTION-B ASED NORMA L | ENABLED |
PPCAPR.STG_92_FEED_DTL_T | TABLE | IDX_S9FDT_F_KMII | FUNCTION-B ASED NORMA L | ENABLED |
PPCAPR.STG_92_FEED_DTL_T | TABLE | PK_S9FDT_SPFI_PFEN | NORMAL | |
PPCAPR.STG_MUP_FEED_T | TABLE | IDX_SMFT_F_KMII | FUNCTION-B ASED NORMA L | ENABLED |
PPCAPR.STG_PRC_FEED_STAT_CD_T | TABLE | PK_SPFSCT_SC | NORMAL | |
PPCAPR.STG_PRC_FEED_T | TABLE | PK_SPFT_SPFI | NORMAL | |
PPCAPR.STG_PRC_FEED_TYP_T | TABLE | PK_SPFTT_FTC | NORMAL | |
PPCAPR.STG_SUP_FEED_T | TABLE | PK_SSFT_SSFI | NORMAL | |
PPCAPR.STG_SUP_FEED_T | TABLE | IDX_SFFT_F_KMII | FUNCTION-B ASED NORMA L | ENABLED |
PPCAPR.USE_LMT_T | TABLE | PK_UL_ULI | NORMAL | |
PPCAPR.USE_LMT_TYP_T | TABLE | PK_ULT_ULTI | NORMAL | |
PPCAPR.ZIPCD_OPT_ROLLUP_T | TABLE | PK_ZORT_Z_NDDI | IOT - TOP |
108 rows selected.
++ List UNSUPPORTED TABLES IN STREAMS
Owner |
Table
Name |
REASON | AUT |
---|---|---|---|
EXFSYS | EXF$DEFIDXPARAM | column with user-defined type | NO |
EXFSYS | EXF$ESETIDXPARAM | column with user-defined type | NO |
EXFSYS | EXF$PREDATTRMAP | column with user-defined type | NO |
EXFSYS | RLM$EQUALSPEC | column with user-defined type | NO |
EXFSYS | RLM$INCRRRSCHACT | column with user-defined type | NO |
EXFSYS | RLM$SCHACTLIST | column with user-defined type | NO |
MDSYS | SDO_COORD_OP_PARAM_VALS | column with user-defined type | NO |
MDSYS | SDO_COORD_REF_SYS | column with user-defined type | NO |
MDSYS | SDO_CS_SRS | column with user-defined type | NO |
MDSYS | SDO_GEOM_METADATA_TABLE | column with user-defined type | NO |
MDSYS | SDO_GEOR_SYSDATA_TABLE | column with user-defined type | NO |
MDSYS | SDO_INDEX_METADATA_TABLE | column with user-defined type | NO |
MDSYS | SDO_STYLES_TABLE | column with user-defined type | NO |
MDSYS | SDO_TOPO_METADATA_TABLE | column with user-defined type | NO |
STRMADMIN | AQ$_PPCAPR_QUEUE_TABLE_C | AQ queue table | NO |
STRMADMIN | AQ$_PPCAPR_QUEUE_TABLE_D | column with user-defined type | NO |
STRMADMIN | AQ$_PPCAPR_QUEUE_TABLE_G | column with user-defined type | NO |
STRMADMIN | AQ$_PPCAPR_QUEUE_TABLE_H | unsupported column exists | NO |
STRMADMIN | AQ$_PPCAPR_QUEUE_TABLE_I | unsupported column exists | NO |
STRMADMIN | AQ$_PPCAPR_QUEUE_TABLE_P | column with user-defined type | NO |
STRMADMIN | AQ$_PPCAPR_QUEUE_TABLE_S | AQ queue table | NO |
STRMADMIN | AQ$_PPCAPR_QUEUE_TABLE_T | AQ queue table | NO |
STRMADMIN | PPCAPR_QUEUE_TABLE | column with user-defined type | NO |
SYSMAN | AQ$_MGMT_NOTIFY_QTABLE_G | column with user-defined type | NO |
SYSMAN | AQ$_MGMT_NOTIFY_QTABLE_H | unsupported column exists | NO |
SYSMAN | AQ$_MGMT_NOTIFY_QTABLE_I | unsupported column exists | NO |
SYSMAN | AQ$_MGMT_NOTIFY_QTABLE_S | AQ queue table | NO |
SYSMAN | AQ$_MGMT_NOTIFY_QTABLE_T | AQ queue table | NO |
SYSMAN | MGMT_BLACKOUT_SCHEDULE | column with user-defined type | NO |
SYSMAN | MGMT_DELTA_COMP_SUMMARIES | column with user-defined type | NO |
SYSMAN | MGMT_DELTA_SUMMARY_ERRORS | column with user-defined type | NO |
SYSMAN | MGMT_JOB_CRED_PARAMS | column with user-defined type | NO |
SYSMAN | MGMT_JOB_PARAMETER | column with user-defined type | NO |
SYSMAN | MGMT_JOB_PARAM_SOURCE | column with user-defined type | NO |
SYSMAN | MGMT_JOB_PROP_PARAMS | column with user-defined type | NO |
SYSMAN | MGMT_JOB_SCHEDULE | column with user-defined type | NO |
SYSMAN | MGMT_JOB_SEC_INFO | column with user-defined type | NO |
SYSMAN | MGMT_JOB_SQL_PARAMS | column with user-defined type | NO |
SYSMAN | MGMT_JOB_STEP_PARAMS | column with user-defined type | NO |
SYSMAN | MGMT_JOB_SUBST_PARAMS | column with user-defined type | NO |
SYSMAN | MGMT_JOB_USER_PARAMS | column with user-defined type | NO |
SYSMAN | MGMT_JOB_VALUE_PARAMS | column with user-defined type | NO |
SYSMAN | MGMT_NOTIFY_QTABLE | column with user-defined type | NO |
SYSMAN | PARAM_VALUES_TAB | column with user-defined type | NO |
WMSYS | AQ$_WM$EVENT_QUEUE_TABLE_G | column with user-defined type | NO |
WMSYS | AQ$_WM$EVENT_QUEUE_TABLE_H | unsupported column exists | NO |
WMSYS | AQ$_WM$EVENT_QUEUE_TABLE_I | unsupported column exists | NO |
WMSYS | AQ$_WM$EVENT_QUEUE_TABLE_S | AQ queue table | NO |
WMSYS | AQ$_WM$EVENT_QUEUE_TABLE_T | AQ queue table | NO |
WMSYS | WM$EVENT_AUX_PARAMS_NT | column with user-defined type | NO |
WMSYS | WM$EVENT_QUEUE_TABLE | column with user-defined type | NO |
WMSYS | WM$VERSIONED_TABLES | column with user-defined type | NO |
WMSYS | WM$VERSIONED_TABLES_UNDO_CODE | column with user-defined type | NO |
XDB | XDB$ALL_MODEL | column with user-defined type | NO |
XDB | XDB$ANY | column with user-defined type | NO |
XDB | XDB$ANYATTR | column with user-defined type | NO |
XDB | XDB$ATTRGROUP_DEF | column with user-defined type | NO |
XDB | XDB$ATTRGROUP_REF | column with user-defined type | NO |
XDB | XDB$ATTRIBUTE | column with user-defined type | NO |
XDB | XDB$CHOICE_MODEL | column with user-defined type | NO |
XDB | XDB$COLUMN_INFO | column with user-defined type | NO |
XDB | XDB$COMPLEX_TYPE | column with user-defined type | NO |
XDB | XDB$ELEMENT | column with user-defined type | NO |
XDB | XDB$GROUP_DEF | column with user-defined type | NO |
XDB | XDB$GROUP_REF | column with user-defined type | NO |
XDB | XDB$H_LINK | column with user-defined type | NO |
XDB | XDB$NLOCKS | column with user-defined type | NO |
XDB | XDB$RESOURCE | column with user-defined type | NO |
XDB | XDB$ROOT_INFO | unsupported column exists | NO |
XDB | XDB$SCHEMA | column with user-defined type | NO |
XDB | XDB$SEQUENCE_MODEL | column with user-defined type | NO |
XDB | XDB$SIMPLE_TYPE | column with user-defined type | NO |
72 rows selected.
++ STREAMS DICTIONARY INFORMATION ++
Capture processes defined on system
Queue
Name |
Capture
Name |
Capture
Number |
Positive
Rule Set |
Negative
Rule Set |
---|---|---|---|---|
STRMADMIN.PPCAPR_QUEUE | PPCAPR_CAPTURE | 1 | STRMADMIN.RULESET$_14 | . |
Apply processes defined on system
no rows selected
Propagations defined on system
Queue
Name |
Destination |
Positive
Rule Set |
Negative
Rule Set |
---|---|---|---|
STRMADMIN.PPCAPR_QUEUE | STRMADMIN.PPCAPR_QUEUE@GIDQSTD1.GAP .COM | STRMADMIN.RULESET$_20 | . |
Streams rules defined on system
Streams Name | Streams Type |
Number of
Rules |
---|---|---|
PPCAPR_CAPTURE | 1 | 2 |
PPCAPR_PROPAGATE | 2 | 2 |
++
++ LOGMINER DATABASE MAP ++
Databases with information in logminer tables
Global
Name |
Logminer
Identifier |
FLAGS | SRC |
---|---|---|---|
GIDQUEST.GAP.COM | 100 | UID$ | |
GIDQUEST.GAP.COM | 101 | MAP |
Logminer
Identifier |
SESSION# |
---|---|
100 | 1 |
SESSION# | CLIENT# | SESSION_NAME | DB_ID |
ResetLogs
Change Number |
SESSION_ATTR | SESSION_ATTR_VERBOSE |
Start
SCN |
END_SCN | SPILL_SCN | SPILL_TIME | OLDEST_SCN | RESUME_SCN | GLOBAL_DB_NAME | RESET_TIMESTAMP | BRANCH_SCN | Version | SPARE1 | SPARE2 | SPARE3 | SPARE4 | SPARE5 | SPARE6 | SPARE7 | SPARE8 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0 | PPCAPR_CAPTURE | 2602618207 | 456954 | 1067451088 | 9018354 | 0 | 0 | 0 | 0 | GIDQUEST.GAP.COM | 626984674 | 0 | 10.2.0.3.0 |
++ LOGMINER CACHE OBJECTS ++
Objects of interest to Streams from each source database
Logminer
Identifier |
Number of
Interesting DB Objects |
---|---|
100 | 379 |
101 | 91 |
Intcol Verification
no rows selected
++ Queue Memory and Flow Control Values ++
ADDR | INDX | INST_ID | FRUSED_KWQBPMT | FLC1_KWQBPMT | FLC2_KWQBPMT | FLC3_KWQBPMT |
---|---|---|---|---|---|---|
BF3C30B0 | 0 | 1 | 3 | 5000 | 200 | 1000 |
++ JOBS in Database ++
JOB | LOG_USER | PRIV_USER | SCHEMA_USER | LAST_DATE | LAST_SEC | THIS_DATE | THIS_SEC | NEXT_DATE | NEXT_SEC | TOTAL_TIME | B | INTERVAL | FAILURES | WHAT | NLS_ENV | MISC_ENV | INSTANCE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SYSMAN | SYSMAN | SYSMAN | 21:46:32 01/30/08 | 21:46:32 | 21:47:32 01/30/08 | 21:47:32 | 3758 | N | sysdate + 1 / (24 * 60) | 0 | EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); | NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='AMERICAN' NLS _SORT='BINARY' | 0102000000000000 | 0 | ||
29 | SYS | SYS | SYS | 21:44:09 01/30/08 | 21:44:09 | 21:44:09 01/30/08 | 21:44:09 | 178 | N | null | next_date := sys.dbms_aqadm.aq$_propaq(job); | NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='AMERICAN' NLS _SORT='BINARY' | 0102000000000000 | 1 | |||
24 | SYS | SYS | SYS | 21:18:44 01/30/08 | 21:18:44 | 21:18:44 01/30/08 | 21:18:44 | 1703 | N | null | next_date := sys.dbms_aqadm.aq$_propaq(job); | NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='AMERICAN' NLS _SORT='BINARY' | 0102000000000000 | 1 |
++ DBA_QUEUE_SCHEDULES ++
SCHEMA | QNAME | Destination | START_DATE | START_TI | PROPAGATION_WINDOW |
Archived Log Last
Timestamp |
LATENCY | S | PROCESS_ | SESSION_ID | INSTANCE | LAST_RUN_DATE | LAST_RUN | CURRENT_START_DAT | CURRENT_ | NEXT_RUN_DATE | NEXT_RUN | TOTAL_TIME | TOTAL_NUMBER | TOTAL_BYTES | MAX_NUMBER | MAX_BYTES | AVG_NUMBER | AVG_SIZE | AVG_TIME | FAILURES | LAST_ERROR_DATE | LAST_ERR | LAST_ERROR_MSG | MESSAGE_DE | ELAPSED_DEQUEUE_TIME | ELAPSED_PICKLE_TIME |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
STRMADMIN | PPCAPR_QUEUE | "STRMADMIN"."PPCAPR_QUEUE"@GIDQSTD1 .GAP.COM | 21:00:31 01/30/08 | 21:00:31 | 1 | N | J000 | 5490, 575 | 1 | 21:00:31 01/30/08 | 21:00:31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BUFFERED | 0 | 0 | |||||||||
STRMADMIN | PPCAPR_QUEUE | "STRMADMIN"."PPCAPR_QUEUE"@GIDQSTD1 .GAP.COM | 21:00:31 01/30/08 | 21:00:31 | 1 | N | J000 | 5490, 575 | 1 | 21:00:31 01/30/08 | 21:00:31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PERSISTENT | |||||||||||
STRMADMIN | PPCAPR_QUEUE | GIDQSTD1.GAP.COM | 21:02:51 01/30/08 | 21:02:51 | 60 | N | J001 | 5482, 151 | 1 | 21:02:51 01/30/08 | 21:02:51 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BUFFERED | 0 | 0 | |||||||||
STRMADMIN | PPCAPR_QUEUE | GIDQSTD1.GAP.COM | 21:02:51 01/30/08 | 21:02:51 | 60 | N | J001 | 5482, 151 | 1 | 21:02:51 01/30/08 | 21:02:51 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PERSISTENT |
++ Agents ++
AGENT_NAME | HTTP | SMTP |
---|---|---|
SCHEDULER$_EVENT_AGENT | NO | NO |
SERVER_ALERT | NO | NO |
HAE_SUB | NO | NO |
RCLTLDBE01_1830 | NO | NO |
STRMADMIN | NO | NO |
PPCAPR_CAPTURE | NO | NO |
6 rows selected.
++ Agent Privileges ++
AGENT_NAME | DB_USERNAME | HTTP | SMTP |
---|---|---|---|
PPCAPR_CAPTURE | STRMADMIN | NO | NO |
RCLTLDBE01_1830 | DBSNMP | NO | NO |
SCHEDULER$_EVENT_AGENT | SYS | NO | NO |
SERVER_ALERT | SYS | NO | NO |
STRMADMIN | STRMADMIN | NO | NO |
HAE_SUB | NO | NO |
6 rows selected.
++ Current Long Running Transactions ++
Current transactions open for more than 20 minutes
no rows selected
++ Streams Pool Advice ++
Stream Pool Size
Factor |
Stream Pool Size
Estimate |
Spill Count
Estimated |
Spill Time
Estimated |
UnSpill Count
Estimated |
UnSpill Time
Estimated |
---|---|---|---|---|---|
.16 | 48 | 467 | 4 | 0 | 0 |
.26 | 80 | 0 | 0 | 0 | 0 |
.37 | 112 | 0 | 0 | 0 | 0 |
.47 | 144 | 0 | 0 | 0 | 0 |
.58 | 176 | 0 | 0 | 0 | 0 |
.68 | 208 | 0 | 0 | 0 | 0 |
.79 | 240 | 0 | 0 | 0 | 0 |
.89 | 272 | 0 | 0 | 0 | 0 |
1.00 | 304 | 0 | 0 | 0 | 0 |
1.11 | 336 | 0 | 0 | 0 | 0 |
1.21 | 368 | 0 | 0 | 0 | 0 |
1.32 | 400 | 0 | 0 | 0 | 0 |
1.42 | 432 | 0 | 0 | 0 | 0 |
1.53 | 464 | 0 | 0 | 0 | 0 |
1.63 | 496 | 0 | 0 | 0 | 0 |
1.74 | 528 | 0 | 0 | 0 | 0 |
1.84 | 560 | 0 | 0 | 0 | 0 |
1.95 | 592 | 0 | 0 | 0 | 0 |
2.05 | 624 | 0 | 0 | 0 | 0 |
2.16 | 656 | 0 | 0 | 0 | 0 |
20 rows selected.
++ STREAMS ALERTS History (10.2.0.3+)
+++ Most recent Streams alerts(max=10) occuring within last 10 days +++
no rows selected
++ init.ora parameters ++
Key parameters are aq_tm_processes, job_queue_processes
streams_pool_size, sga_max_size, global_name, compatible
NAME |
Rule
Type |
VALUE |
---|---|---|
O7_DICTIONARY_ACCESSIBILITY | boolean | FALSE |
_job_queue_interval | integer | 1 |
active_instance_count | integer | |
aq_tm_processes | integer | 0 |
archive_lag_target | integer | 0 |
asm_diskgroups | string | |
asm_diskstring | string | |
asm_power_limit | integer | 1 |
audit_file_dest | string | /opt/oracle/admin/gidquest/adu mp |
audit_sys_operations | boolean | FALSE |
audit_syslog_level | string | |
audit_trail | string | NONE |
background_core_dump | string | partial |
background_dump_dest | string | /opt/oracle/admin/gidquest/bdu mp |
backup_tape_io_slaves | boolean | FALSE |
bitmap_merge_area_size | integer | 1048576 |
blank_trimming | boolean | FALSE |
buffer_pool_keep | string | |
buffer_pool_recycle | string | |
circuits | integer | |
cluster_database | boolean | FALSE |
cluster_database_instances | integer | 1 |
cluster_interconnects | string | |
commit_point_strength | integer | 1 |
commit_write | string | |
compatible | string | 10.2.0.3.0 |
control_file_record_keep_time | integer | 7 |
control_files | string | /oradata/GIDQUEST/gidquest/con trol01.ctl, /oradata/GIDQUEST/ gidquest/control02.ctl, /orada ta/GIDQUEST/gidquest/control03 .ctl |
core_dump_dest | string | /opt/oracle/admin/gidquest/cdu mp |
cpu_count | integer | 8 |
create_bitmap_area_size | integer | 8388608 |
create_stored_outlines | string | |
cursor_sharing | string | EXACT |
cursor_space_for_time | boolean | FALSE |
db_16k_cache_size | big integer | 0 |
db_2k_cache_size | big integer | 0 |
db_32k_cache_size | big integer | 0 |
db_4k_cache_size | big integer | 0 |
db_8k_cache_size | big integer | 0 |
db_block_buffers | integer | 0 |
db_block_checking | string | FALSE |
db_block_checksum | string | TRUE |
db_block_size | integer | 8192 |
db_cache_advice | string | ON |
db_cache_size | big integer | 0 |
db_create_file_dest | string | |
db_create_online_log_dest_1 | string | |
db_create_online_log_dest_2 | string | |
db_create_online_log_dest_3 | string | |
db_create_online_log_dest_4 | string | |
db_create_online_log_dest_5 | string | |
db_domain | string | |
db_file_multiblock_read_count | integer | 16 |
db_file_name_convert | string | |
db_files | integer | 200 |
db_flashback_retention_target | integer | 1440 |
db_keep_cache_size | big integer | 0 |
db_name | string | GIDQUEST |
db_recovery_file_dest | string | /opt/oracle/flash_recovery_are a |
db_recovery_file_dest_size | big integer | 2G |
db_recycle_cache_size | big integer | 0 |
db_unique_name | string | GIDQUEST |
db_writer_processes | integer | 1 |
dbwr_io_slaves | integer | 0 |
ddl_wait_for_locks | boolean | FALSE |
dg_broker_config_file1 | string | /opt/oracle/product/10.2/db/db s/dr1GIDQUEST.dat |
dg_broker_config_file2 | string | /opt/oracle/product/10.2/db/db s/dr2GIDQUEST.dat |
dg_broker_start | boolean | FALSE |
disk_asynch_io | boolean | TRUE |
dispatchers | string | (PROTOCOL=TCP) (SERVICE=gidque stXDB) |
distributed_lock_timeout | integer | 60 |
dml_locks | integer | 24220 |
drs_start | boolean | FALSE |
event | string | |
fal_client | string | |
fal_server | string | |
fast_start_io_target | integer | 0 |
fast_start_mttr_target | integer | 0 |
fast_start_parallel_rollback | string | LOW |
file_mapping | boolean | FALSE |
fileio_network_adapters | string | |
filesystemio_options | string | none |
fixed_date | string | |
gc_files_to_locks | string | |
gcs_server_processes | integer | 0 |
global_context_pool_size | string | |
global_names | boolean | TRUE |
hash_area_size | integer | 131072 |
hi_shared_memory_address | integer | 0 |
hs_autoregister | boolean | TRUE |
ifile | file | |
instance_groups | string | |
instance_name | string | GIDQUEST |
instance_number | integer | 0 |
instance_type | string | RDBMS |
java_max_sessionspace_size | integer | 0 |
java_pool_size | big integer | 0 |
java_soft_sessionspace_limit | integer | 0 |
job_queue_processes | integer | 4 |
large_pool_size | big integer | 0 |
ldap_directory_access | string | NONE |
license_max_sessions | integer | 0 |
license_max_users | integer | 0 |
license_sessions_warning | integer | 0 |
local_listener | string | LISTENER_GIDQUEST |
lock_name_space | string | |
lock_sga | boolean | FALSE |
log_archive_config | string | |
log_archive_dest | string | |
log_archive_dest_1 | string | LOCATION=/oradata/GIDQUEST |
log_archive_dest_10 | string | |
log_archive_dest_2 | string | |
log_archive_dest_3 | string | |
log_archive_dest_4 | string | |
log_archive_dest_5 | string | |
log_archive_dest_6 | string | |
log_archive_dest_7 | string | |
log_archive_dest_8 | string | |
log_archive_dest_9 | string | |
log_archive_dest_state_1 | string | enable |
log_archive_dest_state_10 | string | enable |
log_archive_dest_state_2 | string | enable |
log_archive_dest_state_3 | string | enable |
log_archive_dest_state_4 | string | enable |
log_archive_dest_state_5 | string | enable |
log_archive_dest_state_6 | string | enable |
log_archive_dest_state_7 | string | enable |
log_archive_dest_state_8 | string | enable |
log_archive_dest_state_9 | string | enable |
log_archive_duplex_dest | string | |
log_archive_format | string | %t_%s_%r.arc |
log_archive_local_first | boolean | TRUE |
log_archive_max_processes | integer | 2 |
log_archive_min_succeed_dest | integer | 1 |
log_archive_start | boolean | FALSE |
log_archive_trace | integer | 0 |
log_buffer | integer | 15271936 |
log_checkpoint_interval | integer | 0 |
log_checkpoint_timeout | integer | 1800 |
log_checkpoints_to_alert | boolean | FALSE |
log_file_name_convert | string | |
logmnr_max_persistent_sessions | integer | 1 |
max_commit_propagation_delay | integer | 0 |
max_dispatchers | integer | |
max_dump_file_size | string | UNLIMITED |
max_enabled_roles | integer | 150 |
max_shared_servers | integer | |
nls_calendar | string | |
nls_comp | string | |
nls_currency | string | |
nls_date_format | string | |
nls_date_language | string | |
nls_dual_currency | string | |
nls_iso_currency | string | |
nls_language | string | AMERICAN |
nls_length_semantics | string | BYTE |
nls_nchar_conv_excp | string | FALSE |
nls_numeric_characters | string | |
nls_sort | string | |
nls_territory | string | AMERICA |
nls_time_format | string | |
nls_time_tz_format | string | |
nls_timestamp_format | string | |
nls_timestamp_tz_format | string | |
object_cache_max_size_percent | integer | 10 |
object_cache_optimal_size | integer | 102400 |
olap_page_pool_size | big integer | 0 |
open_cursors | integer | 300 |
open_links | integer | 4 |
open_links_per_instance | integer | 4 |
optimizer_dynamic_sampling | integer | 2 |
optimizer_features_enable | string | 10.2.0.3 |
optimizer_index_caching | integer | 0 |
optimizer_index_cost_adj | integer | 100 |
optimizer_mode | string | ALL_ROWS |
optimizer_secure_view_merging | boolean | TRUE |
os_authent_prefix | string | ops$ |
os_roles | boolean | FALSE |
parallel_adaptive_multi_user | boolean | TRUE |
parallel_automatic_tuning | boolean | FALSE |
parallel_execution_message_size | integer | 2148 |
parallel_instance_group | string | |
parallel_max_servers | integer | 160 |
parallel_min_percent | integer | 0 |
parallel_min_servers | integer | 0 |
parallel_server | boolean | FALSE |
parallel_server_instances | integer | 1 |
parallel_threads_per_cpu | integer | 2 |
pga_aggregate_target | big integer | 790M |
plsql_ccflags | string | |
plsql_code_type | string | INTERPRETED |
plsql_compiler_flags | string | INTERPRETED, NON_DEBUG |
plsql_debug | boolean | FALSE |
plsql_native_library_dir | string | |
plsql_native_library_subdir_count | integer | 0 |
plsql_optimize_level | integer | 2 |
plsql_v2_compatibility | boolean | FALSE |
plsql_warnings | string | DISABLE:ALL |
pre_page_sga | boolean | FALSE |
processes | integer | 5000 |
query_rewrite_enabled | string | TRUE |
query_rewrite_integrity | string | enforced |
rdbms_server_dn | string | |
read_only_open_delayed | boolean | FALSE |
recovery_parallelism | integer | 0 |
recyclebin | string | on |
remote_archive_enable | string | true |
remote_dependencies_mode | string | TIMESTAMP |
remote_listener | string | |
remote_login_passwordfile | string | EXCLUSIVE |
remote_os_authent | boolean | FALSE |
remote_os_roles | boolean | FALSE |
replication_dependency_tracking | boolean | TRUE |
resource_limit | boolean | FALSE |
resource_manager_plan | string | |
resumable_timeout | integer | 0 |
rollback_segments | string | |
serial_reuse | string | disable |
service_names | string | GIDQUEST |
session_cached_cursors | integer | 20 |
session_max_open_files | integer | 10 |
sessions | integer | 5505 |
sga_max_size | big integer | 2G |
sga_target | big integer | 2G |
shadow_core_dump | string | partial |
shared_memory_address | integer | 0 |
shared_pool_reserved_size | big integer | 26843545 |
shared_pool_size | big integer | 512M |
shared_server_sessions | integer | |
shared_servers | integer | 1 |
skip_unusable_indexes | boolean | TRUE |
smtp_out_server | string | |
sort_area_retained_size | integer | 0 |
sort_area_size | integer | 65536 |
spfile | string | /opt/oracle/product/10.2/db/db s/spfileGIDQUEST.ora |
sql92_security | boolean | FALSE |
sql_trace | boolean | FALSE |
sql_version | string | NATIVE |
sqltune_category | string | DEFAULT |
standby_archive_dest | string | ?/dbs/arch |
standby_file_management | string | MANUAL |
star_transformation_enabled | string | FALSE |
statistics_level | string | TYPICAL |
streams_pool_size | big integer | 304M |
tape_asynch_io | boolean | TRUE |
thread | integer | 0 |
timed_os_statistics | integer | 0 |
timed_statistics | boolean | TRUE |
trace_enabled | boolean | TRUE |
tracefile_identifier | string | |
transactions | integer | 6055 |
transactions_per_rollback_segment | integer | 5 |
undo_management | string | AUTO |
undo_retention | integer | 900 |
undo_tablespace | string | UNDOTBS1 |
use_indirect_data_buffers | boolean | FALSE |
user_dump_dest | string | /opt/oracle/admin/gidquest/udu mp |
utl_file_dir | string | |
workarea_size_policy | string | AUTO |
+++ STREAMS STATISTICS +++
Session altered.
STREAMS Health Check (V3.0.20) for GIDQUEST.GAP.COM on Instance=GIDQUEST generated: 21:47:07 01/30/08 |
=========================================================================================
++ MESSAGES IN BUFFER QUEUE ++
Queue
Name |
STARTUP_TIME |
Current Number of
Outstanding Messages in Queue |
Current Number of
Spilled Messages in Queue |
Cumulative
Number of Messages in Queue |
Cumulative Number
of Spilled Messages in Queue |
Current Number of
Expired Messages in Queue |
---|---|---|---|---|---|---|
STRMADMIN.PPCAPR_QUEUE | 20:05:04 01/30/08 | 0 | 0 | 0 | 0 | 0 |
Configuration: Queue Capture Propagation Apply Database
Analysis: History Rules Notifications Configuration Performance Wait Analysis
============================================================================================
++ CAPTURE STATISTICS ++
Capture
Process Number |
Capture
Name |
Startup Timestamp |
Session
ID |
Session
Serial Number |
State |
Last
State Change Time |
Redo Entries
Scanned |
Total
LCRs Enqueued |
Total
Messages Created |
---|---|---|---|---|---|---|---|---|---|
C001 | PPCAPR_CAP TURE | 21:09:13 01/30/08 | 5473 | 183 | CAPTURING CHANGES | 21:46:48 01/30/08 | 40127 | 1035 | 51718 |
Capture
Name |
Current Time | Capture Process T |
Last Redo
Message Number |
Last Redo
Message Create Time |
Last
Enqueue Time |
Last Queued
Message Number |
Last Queued
Message Create Time |
Available
Message Number |
Available
Message Create Time |
---|---|---|---|---|---|---|---|---|---|
PPCAPR_CAP TURE | 21:47:08 01/30/08 | 21:46:48 01/30/08 | 9067341 | 21:46:48 01/30/08 | 21:11:43 01/30/08 | 9065201 | 9067342 | 21:47:05 01/30/08 |
Capture
Name |
Logminer Last
Processed Message |
Last Message
Written to Redo |
---|---|---|
PPCAPR_CAP TURE | 9067341 | 9067342 |
Capture
Name |
Prefilter
Events Discarded |
Prefilter
Events Kept |
Prefilter
Evaluations |
Undecided
After Prefilter |
Full
Evaluations |
---|---|---|---|---|---|
PPCAPR_CAPTURE | 28978 | 0 | 29107 | 129 | 10 |
Capture
Name |
Elapsed Time
Capture (centisecs) |
Elapsed Time
Rule Evaluation (centisecs) |
Elapsed Time
Enqueuing Messages (centisecs) |
Elapsed Time
LCR Creation (centisecs) |
Elapsed Time
Redo Wait (centisecs) |
Elapsed Time
Paused (centisecs) |
Total
Messages Created |
Total
LCRs Enqueued |
Full
Evaluations |
---|---|---|---|---|---|---|---|---|---|
PPCAPR_CAPTURE | 219279 | 1 | 176 | 5689 | 317 | 0 | 51718 | 1035 | 10 |
++ LOGMINER STATISTICS ++
++ (pageouts imply logminer spill) ++
Capture
Name |
Statistic | Value |
---|---|---|
PPCAPR_CAPTURE | bytes of redo processed | 18116952 |
PPCAPR_CAPTURE | bytes paged out | 0 |
PPCAPR_CAPTURE | bytes checkpointed | 3328 |
PPCAPR_CAPTURE | seconds spent in checkpoint | 0 |
++ BUFFERED PUBLISHERS ++
INST_ID | QUEUE_ID | QUEUE_SCHEMA | Queue Name | SENDER_NAME | SENDER_ADDRESS | SENDER_PROTOCOL |
Current
Number of Msgs in Queue |
Cumulative
Total Msgs for Queue |
LAST_ENQUEUED_MSG | UNBROWSED_MSGS | OVERSPILLED_MSGS | MEMORY_USAGE | PUBLISHER_STATE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 62114 | STRMADMIN | PPCAPR_QUEUE | PPCAPR_CAPTURE | 1 | 0 | 0 | 0 | 0 | 0 | 3 | PUBLISHING MESSAGES |
============================================================================================
++ OPEN STREAMS CAPTURE TRANSACTIONS ++
+** Count **+
no rows selected
+** Detail **+
no rows selected
Configuration: Queue Capture Propagation Apply Database
Analysis: History Rules Notifications Configuration Performance Wait Analysis
Statistics Quick Link: Queue Capture Propagation Apply Errors
=========================================================================================
++ SCHEDULE FOR EACH PROPAGATION++
=========================================================================================
Propagation
Name |
Start Date |
Duration
in Seconds |
Next
Time |
Latency
in Seconds |
Status | Process |
Total Bytes
Propagated |
Number of
Failures |
Message
Delivery Mode |
Q-2-Q | Error Message |
---|---|---|---|---|---|---|---|---|---|---|---|
PPCAPR_PROPAGATE | 21:02:51 01/30/08 | 60 | Enabled | J001 | 0 | 0 | BUFFERED | TRUE | |||
PPCAPR_PROPAGATE | 21:00:31 01/30/08 | 1 | Enabled | J000 | 0 | 0 | BUFFERED | TRUE | |||
PPCAPR_PROPAGATE | 21:00:31 01/30/08 | 1 | Enabled | J000 | 0 | 0 | PERSISTENT | TRUE | |||
PPCAPR_PROPAGATE | 21:02:51 01/30/08 | 60 | Enabled | J001 | 0 | 0 | PERSISTENT | TRUE |
Propagation
Name |
Message
Delivery Mode |
Last
Run |
Current
Start |
Next
Run |
Last
Error |
---|---|---|---|---|---|
PPCAPR_PROPAGATE | BUFFERED | 21:02:51 01/30/08 | |||
PPCAPR_PROPAGATE | BUFFERED | 21:00:31 01/30/08 | |||
PPCAPR_PROPAGATE | PERSISTENT | 21:00:31 01/30/08 | |||
PPCAPR_PROPAGATE | PERSISTENT | 21:02:51 01/30/08 |
++ EVENTS AND BYTES PROPAGATED FOR EACH PROPAGATION++
Propagation
Name |
Message
Delivery Mode |
Schedule
Status |
Instance Name
(Instance Number) |
Total
Events Propagated |
Total Bytes
Propagated |
Elapsed
Dequeue Time (Seconds) |
Total Time
(Seconds) |
Elapsed
Pickle Time (Seconds) |
---|---|---|---|---|---|---|---|---|
PPCAPR_PROPAGATE | BUFFERED | Enabled | 1 | 0 | 0 | 0 | 0 | 0 |
PPCAPR_PROPAGATE | BUFFERED | Enabled | 1 | 0 | 0 | 0 | 0 | 0 |
PPCAPR_PROPAGATE | PERSISTENT | Enabled | 1 | 0 | 0 | 0 | ||
PPCAPR_PROPAGATE | PERSISTENT | Enabled | 1 | 0 | 0 | 0 |
++ PROPAGATION SENDER STATISTICS ++
Queue ID |
Source
Queue Owner |
Source
Queue Name |
Destination
Queue Owner |
Destination
Queue Name |
Startup Timestamp |
Destination
Database Link |
High
Water Mark |
Target
Ack |
Schedule
Status |
Total
Messages |
Total Bytes
Propagated |
Elapsed
Dequeue Time (CentiSecs) |
Total Time
(CentiSecs) |
Elapsed
Propagation Time (Seconds) |
Max Msgs
per Window |
Max
Size |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
62114 | STRMADMIN | PPCAPR_QUEUE | 21:00:31 01/30/08 | "STRMADMIN"."PP CAPR_QUEUE"@GID QSTD1.GAP.COM | 0 | 0 | SCHEDULE ENABLED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
62114 | STRMADMIN | PPCAPR_QUEUE | 20:05:05 01/30/08 | GIDQSTD1.GAP.CO M | 0 | 0 | SCHEDULE ENABLED | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Statistics Quick Link: Queue Capture Propagation Apply Errors
++ PROPAGATION RECEIVER STATISTICS++
no rows selected
++ BUFFERED SUBSCRIBERS ++
INST_ID | Queue ID |
Source
Queue Owner |
Source
Queue Name |
SUBSCRIBER_ID | SUBSCRIBER_NAME | SUBSCRIBER_ADDRESS | Protocol | SUBSCRIBER_TYPE |
Startup
Time |
LAST_BROWSED_SEQ | LAST_BROWSED_NUM | LAST_DEQUEUED_SEQ | LAST_DEQUEUED_NUM | CURRENT_ENQ_SEQ |
Current
Number of Msgs in Queue |
Cumulative
Total Msgs for Queue |
TOTAL_DEQUEUED_MSG |
Cumulative
Total Spilled Messages |
Current Number of
Expired Messages in Queue |
MESSAGE_LAG |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 62114 | STRMADMIN | PPCAPR_QUEUE | 2 | GIDQSTD1.GAP.COM | 0 | PROXY | 20:05:04 01/30/08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
1 | 62114 | STRMADMIN | PPCAPR_QUEUE | 4 | "STRMADMIN"."PPCAPR_QUEUE"@GIDQSTD1.GAP.COM | 0 | PROXY | 20:05:04 01/30/08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Configuration: Queue Capture Propagation Apply Database
Analysis: History Rules Notifications Configuration Performance Wait Analysis
Statistics Quick Link: Queue Capture Propagation Apply Errors
============================================================================================
++ APPLY STATISTICS ++
============================================================================================
++ APPLY Reader Statistics ++
no rows selected
no rows selected
no rows selected
============================================================================================
++ APPLY SPILLED TRANSACTIONS ++
no rows selected
============================================================================================
++ APPLY Coordinator Statistics ++
no rows selected
no rows selected
no rows selected
============================================================================================
++ APPLY Server Statistics ++
no rows selected
no rows selected
no rows selected
no rows selected
Statistics: Streams Statistics Queue Capture Propagation Apply Apply_Errors
no rows selected
++ APPLY PROGRESS ++
no rows selected
============================================================================================
++ OPEN STREAMS APPLY TRANSACTIONS ++
+** Count **+
no rows selected
+** Detail **+
no rows selected
Configuration: Queue Capture Propagation Apply Database
Analysis: History Rules Notifications Configuration Performance Wait Analysis
Statistics Quick Link: Queue Capture Propagation Apply Errors
++ STATISTICS on RULES and RULE SETS
++
++ RULE SET STATISTICS
INST_ID | Owner | Name | CPU_TIME | ELAPSED_TIME | FIRST_LOAD_TIME | LAST_LOAD_TIME | LAST_LOADING_TIME | SHARABLE_MEM | RELOADS | INVALIDATIONS | EVALUATIONS | FIRST_HIT_EVALUATIONS | SIMPLE_RULES_ONLY_EVALUATIONS | SQL_FREE_EVALUATIONS | SQL_EXECUTIONS | CONDITIONS_PROCESSED | TRUE_RULES | MAYBE_RULES | VARIABLE_VALUE_FUNCTION_CALLS | VARIABLE_METHOD_FUNCTION_CALLS | EVALUATION_FUNCTION_CALLS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SYS | ALERT_QUE_R | 11 | 32 | 18:53:57 11/16/06 | 15:50:33 01/30/08 | 30 | 31004 | 1 | 0 | 129 | 0 | 129 | 0 | 0 | 129 | 2 | 0 | 0 | 0 | 0 |
1 | STRMADMIN | RULESET$_20 | 135 | 140 | 21:00:31 01/30/08 | 0 | 59966 | 1 | 0 | 2006 | 2006 | 3010 | 0 | 0 | 3024 | 0 | 0 | 8 | 7036 | 2006 | |
1 | STRMADMIN | RULESET$_14 | 35 | 24 | 20:03:51 01/30/08 | 0 | 47974 | 1 | 0 | 629 | 629 | 1238 | 0 | 0 | 1859 | 28 | 567 | 20 | 3001 | 629 |
++ RULE STATISTICS
INST_ID | RULE_SET_OBJECT_ID | EVALUATION_CONTEXT_OBJECT_ID | RULE_OWNER | Rule | RULE_CONDITION | TRUE_HITS | MAYBE_HITS | SQL_EVALUATIONS |
---|---|---|---|---|---|---|---|---|
1 | 8840 | 8825 | SYS | ALERT_QUE$1 | tab.user_data.MESSAGE_LEVEL = 5 AND tab.user_data.MESSAGE_GROUP = 'High Availability' | 2 | 0 | 0 |
1 | 62120 | 8411 | STRMADMIN | PPCAPR13 | ((:ddl.get_object_owner() = 'PPCAPR' or :ddl.get_base_table_owner() = 'PPCAPR') and :ddl.is_null_tag() = 'Y' ) | 14 | 547 | 0 |
1 | 62120 | 8411 | STRMADMIN | PPCAPR12 | ((:dml.get_object_owner() = 'PPCAPR') and :dml.is_null_tag() = 'Y' ) | 14 | 20 | 0 |
Function created.
No errors.
Procedure created.
No errors.
============================================================================================
==================================== Summary ===============================================
============================================================================================
++
++ Notifications ++
++
+
+
+
+
+
PL/SQL procedure successfully completed.
++
++ SYS Checks
++
+
+
PL/SQL procedure successfully completed.
++
++ init.ora checks ++
++
PL/SQL procedure successfully completed.
++
++ Configuration checks ++
++
+ WARNING: the Propagation process 'PPCAPR_PROPAGATE' has latency 60, it should be 5 or less!
+ Set the latency by calling dbms_aqadm.alter_schedule(queue_name,destination,latency=>5)
+
+ ERROR: The rule STRMADMIN.PPCAPR19 specifies an unknown source database: GIDQUEST.REGRESS.RDBMS.DEV.US.ORACLE.COM.
+ ERROR: The rule STRMADMIN.PPCAPR18 specifies an unknown source database: GIDQUEST.REGRESS.RDBMS.DEV.US.ORACLE.COM.
+
+
+ SUGGESTION: One or more propagation processes contain rule sets.
+ If a Propagation process will unconditionally forward all incoming
+ messages to its destination queue, and no rule-based transformations are
+ performed by the Propagation process, you should consider removing
+ the rule set for the Propagation process via dbms_propagation_adm.alter_propagation.
+ This will improve Propagation performance.
+
PL/SQL procedure successfully completed.
++
++ Performance Checks ++
++
++ Note: Performance only checked for enabled Streams processes!
++ Aborted and disabled processes will not report performance warnings!
+
PL/SQL procedure successfully completed.
================================================================================
++ STREAMS Process Wait Analysis ++
Analysis of last 30 minutes of Streams processes
Note: When computing the busiest component, be sure to subtract the percentage where BUSY = 'NO'
Note: 'no rows selected' means that the process was performing no busy work, or that no such process exists on the system.
Note: A null Wait Event implies running - either on the cpu or waiting for cpu
++ LOGMINER READER PROCESSES ++
LOGMINER_READER_NAME | EVENT_COUNT | TOTAL_COUNT | PERCENTAGE | BUSY | Wait Event |
---|---|---|---|---|---|
PPCAPR_CAPTURE - reader | 2 | 1800 | .1 | YES | ARCH wait on c/f tx acquire 2 |
16 | 1800 | .9 | YES | log file sequential read | |
18 | 1800 | 1.0 | YES | control file sequential read | |
183 | 1800 | 10.2 | YES | ||
1581 | 1800 | 87.8 | YES | Streams capture: waiting for archive log | |
****************************** | ---------- | ||||
TOTAL | 100.0 |
++ LOGMINER PREPARER PROCESSES ++
no rows selected
++ LOGMINER BUILDER PROCESSES ++
LOGMINER_BUILDER_NAME | EVENT_COUNT | TOTAL_COUNT | PERCENTAGE | BUSY | Wait Event |
---|---|---|---|---|---|
PPCAPR_CAPTURE - builder | 1 | 1801 | .1 | YES | |
****************************** | ---------- | ||||
TOTAL | .1 |
++ CAPTURE PROCESSES ++
Capture
Name |
EVENT_COUNT | TOTAL_COUNT | PERCENTAGE | BUSY | Wait Event |
---|---|---|---|---|---|
PPCAPR_CAPTURE | 847 | 1801 | 47.0 | NO | Streams capture: waiting for archive log |
****************************** | ---------- | ||||
TOTAL | 47.0 |
++ PROPAGATION SENDER PROCESSES ++
no rows selected
++ PROPAGATION RECEIVER PROCESSES ++
no rows selected
++ APPLY READER PROCESSES ++
no rows selected
++ APPLY COORDINATOR PROCESSES ++
no rows selected
++ APPLY SERVER PROCESSES ++
no rows selected
currently spooling to GIDQUEST.html
Turning Spool OFF!!!