Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Data Subset
  8. Data Masking
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Data Type Reference
  21. Data Type Reference for Test Data Warehouse
  22. Data Type Reference for Hadoop
  23. Glossary

Oracle

Oracle

The following table describes the data masking, data subset, data discovery, and data generation operations that you can perform on the Oracle data types when the target is test data warehouse:
Data Types
Test Data Warehouse
Comments
Binary_Double
Yes
You can enter a precision value up to 28.
Binary_Float
Yes
Blob
Yes
Char
Yes
Clob
Yes
Date
Yes
Decimal(P,S)
Yes
You can enter a precision value up to 28. You cannot enter the data type with value Decimal(38,38).
Float
Yes
Integer
Yes
Long
Yes
Longraw
Yes
Longvarchar
Yes
Nchar
Yes
Nclob
Yes
Number
Yes
You can enter a precision value up to 28. You cannot enter the data type with value Number(38,38).
Nvarchar2(N)
Yes
Raw
Yes
Real
Yes
Smallint
Yes
Timestamp
Yes
Timestamp with local time zone
Yes
You must set the precision to 40.
You cannot perform the test generation operation.
Timestamp with time zone
Yes
You must set the precision to 40.
You cannot perform the test generation operation.
Urowid
Yes
You cannot assign a data generation rule. TDM generates null values in the target.
Varchar2(N)
Yes
XML
Yes
If you assign a dictionary generation rule that contains specified invalid values for the XML data type in an Oracle database, the data generation task fails.
When the target is test data warehouse, you cannot perform data masking, data subset, data discovery, and data generation operations on the following Oracle data types:
  • Anydata
  • Anydataset
  • Anytype
  • Bfile
  • Dburitype
  • Httpuritype
  • Interval day to second
  • Interval year to month
  • Ordaudio
  • Orddicom
  • Orddoc
  • Ordimage
  • Ordimagesignature
  • Ordvideo
  • Rowid
  • Sdo_Geometry
  • Sdo_Georaster
  • Sdo_Topo_Geometry
  • SI_Averagecolor
  • SI_Color
  • SI_Colorhistogram
  • SI_Featurelist
  • SI_Positionalcolor
  • SI_Stillimage
  • SI_Texture
  • Uritype
  • Xdburitype