DBA-009 wrote:
thx but how i can mask data with above give environment?

What does "mask data" mean to you and what is the environment you are referring to?

Telling us that you are using 11.1 helps. But it is far from a complete description of the environment. What edition of the database are you using? What options are installed? What Enterprise Manager packs are licensed? Is any of this changable? Could you license another option for the database or another pack for Enterprise Manager if that was necessary?

What does it mean to you to "mask data"? Do you want to store the data on disk and then mask the data in the presentation layer when certain people query it (i.e. store the patient's social security number in the database but only present ***-**- and the last 4 digits to certain sets of employees)? Do you want to hide entire fields from certain people? Do you want to change the data stored in the database when you are refreshing a lower environment with production data? If so, do you need and/or want this process to be either determinisitic or reversable or both?

You mean to say that you have licensed the Data Masking Pack for Enterprise Manager?

If so, then I'm not sure exactly what your question is. Presumably, if you've licensed the Data Masking Pack, you would use that to mask the data. Do you have a specific question about how to use the Data Masking Pack?