How to make a datapump export of some rows of a table complete succesfully?
Hi Oracle Community. I can not complete successfully the execution of this Oracle datapump expdp command:
expdp monitor/password directory=DATAPUMP dumpfile=tabla_bt_balancin_deta_2016.dmp logfile=tabla_bt_balancin_deta_2016.log tables=btms.bt_balancin_deta QUERY=BTMS.BT_BALANCIN_DETA: WHERE to_char\(FEC_CREA,'YYYY'\)\ = '2016'
When I execute this expdp command in the operative system, we see the following error:
oracle@HTBDES:/DPUMP_HTBP_VNX/EXPORTS$
oracle@HTBDES:/DPUMP_HTBP_VNX/EXPORTS$ expdp monitor/M0n170r_8516 directory=DATAPUMP dumpfile=tabla_bt_balancin_deta_2016.dmp logfile=tabla_bt_balancin_deta_2016.log tables=btms.bt_balancin_deta QUERY=BTMS.BT_BALANCIN_DETA: WHERE to_char\(FEC_CREA,'YYYY'\)\ = '2016'