OraFAQ Forum: Server Utilities » Help Column masking/encrypting

Home » RDBMS Server » Server Utilities » Help Column masking/encrypting (10g linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help Column masking/encrypting [message #615257]

Sun, 01 June 2014 08:55

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

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

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

Michel Cadot
Messages: 68758
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

Michel Cadot
Messages: 68758
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

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

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

Michel Cadot
Messages: 68758
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

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 30 09:55:12 CDT 2025