autobcpORAdp fails with UDI-00014: invalid value for parameter, 'remap_tablespace'

Products

• Autosys Workload Automation

Issue/Introduction

Attempting to sync the autosys databases via /data/CA/WorkloadAutomationAE/autosys/dbobj/ORA/autobcpORAdp.pl results in the error:

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
UDI-00014: invalid value for parameter, 'remap_tablespace'

sh: line 2: AEDB_DATA:AEDB_DATA: command not found
sh: line 3: /data/oradata/DEV2/datafile/XXXXXXXX.dbf:/data/oradata/DEV1/datafile/AEDB_DATA.DBF: No such file or directory
sh: line 4: /data/oradata/DEV1/datafile/YYYYYYYY.dbf: No such file or directory

autobcpORAdp:  Impdp - Import of table information failed.
autobcpORAdp:  Cannot proceed.

Resolution

All the ujo_ tables must exist in the same tablespace otherwise the autobcpORAdp will fail with errors. 

Have the dba relocate the few outliers to the tablespace where that the majority of the tables exist.

Use the below queries to help identify any inconsistency:

select tablespace_name||','||file_name from dba_data_files union select tablespace_name||','||file_name from dba_temp_files;

select object_name||','||object_type from dba_objects where owner = 'AEDBADMIN' order by object_type,object_name;

select tablespace_name||','||table_name from dba_tables where owner='AEDBADMIN' order by tablespace_name,table_name;

select tablespace_name||','||index_name from dba_indexes where owner='AEDBADMIN' order by tablespace_name,index_name;

select table_name||','||tablespace_name from ALL_TAB_PARTITIONS where table_owner='AEDBADMIN'

select tablespace_name||','||file_id||','||segment_name from dba_extents ORDER BY TABLESPACE_NAME,SEGMENT_NAME,FILE_ID

select tablespace_name||','||segment_name from dba_segments where owner='AEDBADMIN' order by tablespace_name,segment_name;