Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Plans and Workflows
  11. Monitor
  12. Reports
  13. ilmcmd
  14. Data Type Reference
  15. Data Type Reference for Hadoop

Oracle

Oracle

The following table describes the operations that you can perform on data types in Oracle database:
Data Types
Data Movement
Data Masking
Profiling
Comments
Binary_Double
Yes
Yes
Yes
Binary_Float
Yes
Yes
Yes
Blob
Yes
Yes
No
You can perform nullification masking.
Char
Yes
Yes
Yes
Clob
Yes
Yes
No
Date
Yes
Yes
Yes
You cannot run data domain profiles.
Dburitype
No
No
No
Decimal(P,S)
Yes
Yes
Yes
Float
Yes
Yes
Yes
Httpuritype
No
No
No
Integer
Yes
Yes
Yes
Interval day to second
Yes
No
No
For the Interval day(9) to second(9) data type, you must set the precision greater than 18.
Interval year to month
Yes
No
No
For the Interval year(9) to month data type, you must set the precision greater than 11.
Long
Yes
Yes
No
Longraw
Yes
Yes
No
You can perform nullification masking.
Longvarchar
Yes
Yes
No
Nchar
Yes
Yes
Yes
Nclob
Yes
Yes
No
Number
Yes
Yes
Yes
Nvarchar
Yes
Yes
Yes
Nvarchar2(N)
Yes
Yes
Yes
Raw
Yes
Yes
No
You can perform nullification masking.
Real
Yes
Yes
Yes
Rowid
Yes
No
No
Smallint
Yes
Yes
Yes
Timestamp
Yes
Yes
Yes
You cannot run data domain profiles.
Timestamp with time zone
Yes
No
No
Urowid
Yes
No
No
Varchar
Yes
Yes
Yes
Varchar2(N)
Yes
Yes
Yes
XML
Yes
No
No
Xdburitype
No
No
No
You cannot perform data masking, data subset, and profiling operations on the following Oracle data types:
  • Anydata
  • Anydataset
  • Anytype
  • Bfile
  • Ordaudio
  • Orddicom
  • Orddoc
  • Ordimage
  • Ordimagesignature
  • Ordvideo
  • Sdo_Geometry
  • Sdo_Georaster
  • Sdo_Topo_Geometry
  • SI_Averagecolor
  • SI_Color
  • SI_Colorhistogram
  • SI_Featurelist
  • SI_Positionalcolor
  • SI_Stillimage
  • SI_Texture
  • Timestamp with local time zone
  • Uritype