Hi all
Just curious, can I use DIRECT=Y and QUERY parameter together.
From the Oracle documentation, it stated that the SQL will be bypassed. However, when I used direct=y and query parameter , it seems that my data exported is met with the condition of the query.
TABLES=TB_TEST
directory=ORA_DIR
DUMPFILE=expdp_tb_test%u.dmp
content=data_only
buffer=50000000
recordlength=65535
FILESIZE=100m
DIRECT=Y
parallel=4
logfile=expdp_tb_test.log
query=TB_TEST:"WHERE ID IN (SELECT ID FROM TB_ID_LOG)"
Please advise.