Oracle encryption wallet 12c

oracle

I exported a database to a transportable tablespace and send the data to a customer. They received the error: ORA-28365 Wallet is not open.
Do I need to close the wallet before creating the export? Is there something on the customer's end that they can do to allow them to import this data?

Haven't had this problem with any other customer since switching to 12c in the last 6 months so this is strange to me that this is the only customer having this problem?

Thanks for any insight!

Best Answer

For TDE:

Do transportable tablespaces work with TDE tablespace encryption?

Yes, but it requires that the wallet containing the master key is copied to the secondary database. If the tablespace is moved and the master key is not available, the secondary database will return an error when the data in the tablespace is accessed.

How to use TTS With TDE (Doc ID 1674166.1)

... Only difference when transporting tablespace using TDE is the wallet needs to copied to the target database. ...

Related Solutions

Oracle 11g .DMP viewer

First of all you need to create a directory on the database.

Create or Replace Directory IMP_DIR as 'Path\Path\';

Ensure the user that will import the file has the privilige to Read & Write on the directory (In case you are not using SYS)

GRANT Read, Write ON DIRECTORY IMP_DIR TO user;

Then, include the directory parameter within the import statement

impdp 'sys AS SYSDBA' file=dump.dmp full=yes log=implog.txt directory=IMP_DIR

Imports & exports under storage constraints and preallocations

It seems that you use the old export (exp) utility and not the datapump export expdp. For expthere is a parameter compress that manages the size of an initial extent of a table that is imported. The default value is compress=y which means that the initial extent of the table (this is in most cases the space preallocated when creating an empty table) is as large as the space the table currently uses. So you should use the paramter compress=no. Then the initial extent of an imported table is as large as the initial extent of the table in the source database.

Best Answer

Related Solutions

Oracle 11g .DMP viewer

Imports & exports under storage constraints and preallocations

Related Question