-
Title
Copy error “Error/Warning Detected: EXP-00111: Table TABLE_NAME resides in an Encrypted Tablespace TABLESPACE_NAME and will not be exported” -
Description
The following errors are observed when running copy for a source table that resides in an encrypted tablespace:
sp_ctrl> copy status
ID Tablename Status Time Total Rows %Comp Total Time
------ ------------------------------------ ---------- ---------- ---------- ----- ----------
1 "OWNER"."SOURCE_TABLE" Failed - An error occurred in export: EXP-00111: Table SOURCE_TABLE resides in an Encrypted Tablespace TABLESPACE_NAME and will not be exported -
Cause
Copy does NOT work for tables residing in encrypted tablespaces.
-
Resolution
Use other means to sync the table. Some of the convenient ones are:
1. Repair
or
2. Manually Export/Import using Oracle data pump export.
It will only work if some conditions are met as described below in Additional Information field. -
Additional Information
For manual Export/Import using data pump Export, please refer to KB article # 125531. Please be aware that it requires the table to be routed via a dedicated named Post queue which does not have any other table routing through it. For details on the copy command and limitations, please refer to SharePlex Reference Guide.