Hi,
I'm trying to import part of a table to another table on remote database using impdp:
impdp centrumadmin/centrumadmin directory=DUMP_LOG_DIRECTORY LOGFILE=backup_2014_01.log network_link=REF2ISKNE TABLES='AUD$_BACKUP' content=DATA_ONLY QUERY=\"WHERE 'NTIMESTAMP#' \> to_date\('01-02-2014','DD-MM-YYYY'\)\";
But still getting this error:
Starting "CENTRUMADMIN"."SYS_IMPORT_TABLE_01": centrumadmin/******** directory=DUMP_LOG_DIRECTORY LOGFILE=backup_2014_01.log network_link=REF2ISKNE TABLES=AUD$_BACKUP content=DATA_ONLY QUERY="WHERE NTIMESTAMP# > to_date(02-2014,MM-YYYY)"
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 4.473 GB
ORA-31693: Table data object "CENTRUMADMIN"."AUD$_BACKUP" failed to load/unload and is being skipped due to error:
ORA-00904: "YYYY": invalid identifier
Job "CENTRUMADMIN"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at Wed Feb 11 09:32:15 2015 elapsed 0 00:00:03
Any ideas? If I switch the date format to YYYY-MM-DD or another, always error is in the last part: ORA-00904: "DD": invalid identifier.
Thank you.
Honza