Sample Header Ad - 728x90

Using JOINS in QUERY clause in EXPDP

0 votes
1 answer
2986 views
I have a par file that is using JOINS in QUERY clause. But it is not working. directory=expdp DUMPFILE=Test_SIT_Query_1table_%U.dmp encryption_password=oracle parallel=8 logfile=TEST_SIT_Query_table.log compression=all cluster=N METRICS=Y query=IAO.VERIFIC:"SELECT /*+Parallel(8)*/ distinct A.* FROM IAO.VERIFIC A JOIN IAO.ELIJ B ON A.RACE_ID = B.RACE_ID WHERE B.CREATE_DT > SYSDATE - 30" tables=IAO.VERIFIC Below is the error I am getting. ORA-31693: Table data object "IAO"."VERIFIC" failed to load/unload and is being skipped due to error: ORA-00942: table or view does not exist Could someone help what could be missing in the above par file.
Asked by sabarish jackson (133 rep)
Mar 26, 2019, 02:18 PM
Last activity: Sep 19, 2022, 07:03 AM