Hi DBA's
While importing data (query based importing) I used following command
nohup impdp sysadm/****@hrprd01 tables=PSAPMSGARCHPD TABLE_EXISTS_ACTION=TRUNCATE directory=BACKUP QUERY=\"where IBTRANSACTIONID in \(select IBTRANSACTIONID from PSAPMSGARCHPC\)\" dumpfile=PSAPMSGARCHPD.dmp
logfile=ps_conditional_import.log &
but Import job failed by specifying following error.... ie Couldnt able to find table or view
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39153: Table "SYSADM"."PSAPMSGARCHPD" exists and has been truncated. Data will be loaded but all dependent metadata will be skipped due to table_exists_action of truncate
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "SYSADM"."PSAPMSGARCHPD" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-00942: table or view does not exist
Any help will be appreciated.....