Home » RDBMS Server » Server Utilities » Help Column masking/encrypting (10g linux)
Help Column masking/encrypting [message #615257] Sun, 01 June 2014 08:55 Go to next message
blakshmi
Messages: 6
Registered: October 2006
Location: nj
Junior Member

Dear All,

I want to mask or encrypt visibility of sensitive data during import or export.
Is there an option to take care while doing datapump import or should i handle this while exporting.

Any ideas or suggestions ...

thanks
LB

Re: Help Column masking/encrypting [message #615261 is a reply to message #615257] Sun, 01 June 2014 09:15 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2447
Registered: May 2013
Location: World Wide on the Web
Senior Member
Read ENCRYPTION parameter http://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_export.htm
Re: Help Column masking/encrypting [message #615262 is a reply to message #615261] Sun, 01 June 2014 09:18 Go to previous messageGo to next message
blakshmi
Messages: 6
Registered: October 2006
Location: nj
Junior Member

Is this a limitation with the version i am using ?
Re: Help Column masking/encrypting [message #615268 is a reply to message #615257] Sun, 01 June 2014 10:05 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can buy and use Data Masking option, it is made for that.

Re: Help Column masking/encrypting [message #615269 is a reply to message #615257] Sun, 01 June 2014 10:07 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Do you want to encrypt the data inside the dump? (Lalit's answer).
Or do you want to encrypt (cypher/obfuscate) the data inside your target database? (My answer).

Re: Help Column masking/encrypting [message #615286 is a reply to message #615269] Sun, 01 June 2014 11:59 Go to previous messageGo to next message
blakshmi
Messages: 6
Registered: October 2006
Location: nj
Junior Member

i want to encrypt or mask in the destination database. i might look at the mask option that Bruno suggested.
Re: Help Column masking/encrypting [message #615287 is a reply to message #615286] Sun, 01 June 2014 12:07 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2447
Registered: May 2013
Location: World Wide on the Web
Senior Member
Who is Bruno in this thread?

Anyway, to encrypt the data in the target database, you need to go with Michel's answer.
Re: Help Column masking/encrypting [message #615289 is a reply to message #615287] Sun, 01 June 2014 12:28 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Bruno answered in the same topic in DBA-Village:
http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=71981&SkipA=0

where OP mentioned he do not want to write any code and Bruno suggested to write some.
And I bet OP did not understand the complexity of such solution... which makes Data Masking a paying option. Smile


Re: Help Column masking/encrypting [message #615290 is a reply to message #615289] Sun, 01 June 2014 12:35 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2447
Registered: May 2013
Location: World Wide on the Web
Senior Member
Smile

I parallely saw Bruno's reply in DBA-Village, just asked humorously.
Re: Help Column masking/encrypting [message #615291 is a reply to message #615290] Sun, 01 June 2014 12:55 Go to previous messageGo to next message
blakshmi
Messages: 6
Registered: October 2006
Location: nj
Junior Member

true, it seems more complex than i though Smile
Re: Help Column masking/encrypting [message #615292 is a reply to message #615291] Sun, 01 June 2014 13:13 Go to previous message
Lalit Kumar B
Messages: 2447
Registered: May 2013
Location: World Wide on the Web
Senior Member
Request you to follow the steps and come back with your feedback. Do mention the steps you followed. Use code tags to post your steps and of course, hopefully you get your issue resolved. This is to help other folks searching this forum for similar issue.
Previous Topic: question on datapump
Next Topic: Schema export with less space on windows
Goto Forum:
  


Current Time: Sat Oct 25 03:49:51 CDT 2014

Total time taken to generate the page: 0.05372 seconds