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

Report message to a moderator

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: 3174
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

Report message to a moderator

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 ?

Report message to a moderator

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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

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

Report message to a moderator

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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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).

Report message to a moderator

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.

Report message to a moderator

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: 3174
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.

Report message to a moderator

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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Smile

I parallely saw Bruno's reply in DBA-Village, just asked humorously.

Report message to a moderator

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

Report message to a moderator

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: 3174
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.

Report message to a moderator

Previous Topic: question on datapump
Next Topic: Schema export with less space on windows
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 02:16:19 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.