Problem:-
[oracle@prod101:~ orcl101] expdp tables=scott.tde_test directory=TEST_DIR dumpfile=emp121.dmp logfile=emp121.log
Export: Release 18.0.0.0.0 – Production on Fri Aug 24 00:48:16 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Username: scott
Password:
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 – Production
Starting “SCOTT”.”SYS_EXPORT_TABLE_01″: scott/******** tables=scott.tde_test directory=TEST_DIR dumpfile=emp121.dmp logfile=emp121.log
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-31693: Table data object “SCOTT”.”TDE_TEST” failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-28365: wallet is not open
Solution:-
SQL> alter system set encryption key authenticated by “ORACLE@123”;
System altered.
SQL> exit Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.3.0.0.0 [oracle@prod101:~ orcl101] expdp tables=scott.tde_test directory=TEST_DIR dumpfile=emp122.dmp logfile=emp122.log Export: Release 18.0.0.0.0 - Production on Fri Aug 24 01:01:55 2018 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. Username: scott Password: Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Starting "SCOTT"."SYS_EXPORT_TABLE_01": scott/******** tables=scott.tde_test directory=TEST_DIR dumpfile=emp122.dmp logfile=emp122.log Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER Processing object type TABLE_EXPORT/TABLE/TABLE . . exported "SCOTT"."TDE_TEST" 5.546 KB 1 rows ORA-39173: Encrypted data has been stored unencrypted in dump file set. Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is: /u01/app/oracle/datapump/emp122.dmp Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at Fri Aug 24 01:02:11 2018 elapsed 0 00:00:07