Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Discussion

 Gireesh Kumar Raju Muddaluru (GireeshKumarRajuM16687997)
CBA

CBA
AU
GireeshKumarRajuM16687997 Member since 2022 24 posts
CBA
Posted: Sep 25, 2015
Last activity: Sep 25, 2015
Posted: 25 Sep 2015 6:30 EDT
Last activity: 25 Sep 2015 9:57 EDT
Closed

Unknown Tables are created in Our pega database.

Hi,

 

Below unknown tables are created in our database. Anybody can explain what are those and can we drop below table?

 

CMP4$95650, CMP4$95655

 

Below is the structure.

 

Name                                                                                                                                                                          Null?    Type  ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------------------------------------------------------  PXCOMMITDATETIME                                                                                                                                                                       DATE  PZRULESETNAME                                                                                                                                                                          VARCHAR2(128)  PZRULESETVERSIONMAJOR                                                                                                                                                                  NUMBER(18)  PZRULESETVERSIONMINOR                                                                                                                                                                  NUMBER(18)  PZRULESETVERSIONPATCH                                                                                                                                                                  NUMBER(18)  PZDEPRULEINSKEY                                                                                                                                                                        VARCHAR2(200)  PZINSKEY                                                                                                                                                                      NOT NULL VARCHAR2(576)  PZIMPLEMENTATIONKEY                                                                                                                                                                    VARCHAR2(255)  PZDEPENDENCYKEY                                                                                                                                                                        VARCHAR2(255)  PZAPPLIESTOCLASSNAME                                                                                                                                                                   VARCHAR2(64)  PZRULETYPE                                                                                                                                                                             VARCHAR2(64)  PZRULENAME                                                                                                                                                                             VARCHAR2(255)  PZEXPLICITINLINECLASS                                                                                                                                                                  VARCHAR2(5)  PXOBJCLASS                                                                                                                                                                             VARCHAR2(96)  PZCACHECONFIGID                                                                                                                                                                        VARCHAR2(18)  PXCREATEDATETIME                                                                                                                                                                       DATE  PXCREATESYSTEMID                                                                                                                                                                       VARCHAR2(32)  PXCREATEOPNAME                                                                                                                                                                         VARCHAR2(128)  PXCREATEOPERATOR                                                                                                                                                                       VARCHAR2(128)  PZDEPRULEINSID                                                                                                                                                                         VARCHAR2(128)  PXINSNAME                                                                                                                                                                              VARCHAR2(512)  PZASSEMBLYTIMECLASS                                                                                                                                                                    VARCHAR2(64)  PZEXCLUDEFROMAA                                                                                                                                                                        VARCHAR2(5)  PZPACKAGE                                                                                                                                                                              VARCHAR2(256)  PZCLASS                                                                                                                                                                                VARCHAR2(256)  PZMODELINDEX                                                                                                                                                                           NUMBER(18)  PZCLASSHASH                                                                                                                                                                            VARCHAR2(32)  PZEXPLICITEXCLUDECOMBINED                                                                                                                                                              NUMBER(18)

To see attachments, please log in.
Data Integration

Posted: 9 years ago
Posted: 25 Sep 2015 6:43 EDT
Phani Sahukaru (sahup1)
Pegasystems Inc.
Phani Sahukaru
Pegasystems Inc.
IN

>>> why unknown tables are created in our database

not sure.

>>> can we drop below table?

please try running Designer Studio --> System --> Database --> Optimize schema to confirm on the table usage/reference

 

or through SMA...

Advanced --> Reports.

To see attachments, please log in.
Posted: 9 years ago
Posted: 25 Sep 2015 9:57 EDT
Phani Sahukaru (sahup1)
Pegasystems Inc.
Phani Sahukaru
Pegasystems Inc.
IN

also please check Data-Admin-DB-Table instances having these table mappings

and also at Data Model --> database class mappings 

not sure, but again - please take a backup and drop the tables as you're not seeing any references.

To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice