Home » RDBMS Server » Server Administration » How to copy encrypted data between 2 databases?
How to copy encrypted data between 2 databases? [message #180857] Wed, 05 July 2006 09:12 Go to next message
arweiler
Messages: 1
Registered: July 2006
Junior Member
I'm trying to copy tables via import/export or tools like TOAD but the data cannot be decrypted anymore in the target system (same Oracle Parameters). I'm using the DBMS_OBFUSCAION toolkit for crypting.
Thanks,
olaf

Report message to a moderator

Re: How to copy encrypted data between 2 databases? [message #180892 is a reply to message #180857] Wed, 05 July 2006 14:16 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I ***beleive*** it is not possible with exp/imp tools. I am not sure. I will set up a test case and keep you posted.
Expdp/impdb in oracle 10g will support this operation.

[Updated on: Wed, 05 July 2006 14:17]

Report message to a moderator

Previous Topic: how to find last Import date?
Next Topic: difference between normal and 'as sysdba'
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:43:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.