Oracle and GLOBAL TEMPORARY TABLE - please provide a flag to tell us we can't mask these tables!!!


Article ID: 196464


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


We got an issue when using the portal and Oracle GLOBAL TEMPORARY TABLE.


Since you can't mask those tables, could we have a flag to tell us that we can't mask those type of table.





Release : 4.9

Component : CA Test Data Manager


I created an updated TDM Portal version to provide the functionality to configure whether to fetch Temporary Tables or not in case of Profiling Oracle DB.

1) The updated TDM Portal version is and it can be accessed by requesting this version or later from Broadcom Support.

Please ensure that the new version is installed and required configuration is done as mentioned below.

2) In CATDM_HOME\\config\\ file ensure that is set to true

3) Restart portal

4) Try to create Data Model (or RESCAN incase of existing Data Model), then temporary tables in Oracle should not show up in the model