TDE(Transparent Data Encryption) - datapump export and import
Database: 10.2.0.4
we have one of the column encrypted on a big partition table. my understanding is that when we export(expdp) data from this table, the data will be decrypted unless we use the parameter but then I will have to use the same password when I import(impdp) this table and the data will be loaded decrypted.
I have a need to copy this table that has the encrypted column to another database, if I have to run encryption in new database, it will take 7 hours because this table has lots of data(100 partitions).
I am hoping that I could export this table and imported in other database with the encryption and then install the wallet with same password as the source database, will that work or what should I do?
we have one of the column encrypted on a big partition table. my understanding is that when we export(expdp) data from this table, the data will be decrypted unless we use the parameter but then I will have to use the same password when I import(impdp) this table and the data will be loaded decrypted.
encryption_password=fl0rida
I have a need to copy this table that has the encrypted column to another database, if I have to run encryption in new database, it will take 7 hours because this table has lots of data(100 partitions).
I am hoping that I could export this table and imported in other database with the encryption and then install the wallet with same password as the source database, will that work or what should I do?
0