Voltar
-
Título
Copy error “Error/Warning Detected: EXP-00111: Table TABLE_NAME resides in an Encrypted Tablespace TABLESPACE_NAME and will not be exported” -
Descrição
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
-
Causa
Copy does not work for tables residing encrypted tablespaces. -
Resolução
Use other means to sync the table. Some of the convenient ones are:
1. Repair
2. Manual Export/Import using data pump export. It will only work if some conditions are met as described below in Additional Information field.
-
Informações adicionais
For manual Export/Import using data pump Export, please refer to knowledgebase article # 125531. Please be aware that it requires the table to be routed thru a dedicated named Post queue which does not have any other table routing thru it. For details on the copy command and limitations, please refer to SharePlex Reference Guide.