Database Administration (MOSC)

MOSC Banner

How to make a datapump export of some rows of a table complete succesfully?

edited Apr 5, 2022 2:26PM in Database Administration (MOSC) 2 commentsQuestion

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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center