Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

About data masking and licenses in Oracle

Posted on 2011-09-06
6
Medium Priority
?
1,053 Views
Last Modified: 2012-06-27
Hello,

We are trying to implement data masking for testing data.

I know that this feature is available with Oracle Enterprise. However for us it's very expensive.

In order to lower license costs, could be possible to have an Oracle Enterprise only for one named user, or have an Oracle Personal or Express Edition for data masking.

Maybe it's possible to have one Oracle server with data masking feature, mask data, and export that data to other databases.
0
Comment
Question by:miyahira
6 Comments
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36492441
You should ask Oracle this directly to ensure you are legal with what you are proposing.
0
 
LVL 1

Author Comment

by:miyahira
ID: 36492486
Yes, of course I asked Oracle, but their salesmen (at least in my country) are not so fast or don't like to answer this kind of questions.

Just asking if someone had some similar license experience, so I can ask Oracle with more information.
0
 
LVL 20

Expert Comment

by:gatorvip
ID: 36495490
Take a look at the licensing options here:
http://www.oracle.com/us/corporate/pricing/specialty-topics/index.html

In particular, you want to look at the policies document ( http://www.oracle.com/us/corporate/pricing/databaselicensing-070584.pdf )

In short, for a testing environment, you need a license. For a development environment, you do not need an additional license as long as the development is restricted to 1 user per 1 computer per install.

However, this is just my interpretation of their documentation and you shouldn't necessarily rely on it. The Oracle reps are best suited to answer licensing questions.
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 1

Accepted Solution

by:
miyahira earned 0 total points
ID: 36498440
It's not possible.

http://download.oracle.com/docs/cd/E11882_01/license.112/e10594/options.htm#DBLIC2114

"Oracle Data Masking Pack must be licensed for those databases servers where the masked data originates from as well as those database servers containing the masked data."
0
 
LVL 1

Author Closing Comment

by:miyahira
ID: 36521422
Found by myself.
0
 
LVL 11

Expert Comment

by:Akenathon
ID: 36500727
You can do what you say... there's nothing wrong in processing your data on an EE at the minimum license, and then export the data to a SE at your production licenses. Nobody will say anything against your usage of the exported data. Some pitfalls:

- Some licenses have minimums, e.g. you can buy by named user, but they won't license anything below 25 users. That's something only your Oracle representative can confirm... look into Personal Oracle, I think it's the only one that can be licensed for just one user (actually it's MEANT to be licensed for just one user!)
- If your structures have anything only supported by EE, they cannot be directly transported onto a SE. For instance, a create table with partitions will fail if you run it on a DB without the partitioning option. However, the data can still be merged on a SE non-partitioned table. Same for advanced compression options, etc.
- What you CANNOT do is make use of their free license for prototyping and/or personal study to use an EE for this. You would be using the EE as part of your testing environment, so it's clearly NOT allowed

Remember you can always run some custom scripts to scrub sensitive data after cloning the production DB into the testing environment. Actually that's what everybody did before masking was invented :-)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question