How to add a SYSDATE parameter to DBMS_DATAPUMP job?
Oracle 19c database on an AWS RDS instance...
I'm trying to add a parameter to my dbms_datapump export that functions like this query:
QUERY=XXX.XXX_STATUS_TIMING:"WHERE 1 = 1 and ASSIGN_TIME between trunc(SYSDATE-7) and trunc(SYSDATE)"
The job looks like this:
I can't seem to add a parameter for the SYSDATE function that will execute in this export. It always errors out. The export is retrieving tables from multiple schemas (I think this is what may be causing the issue)
Any ideas where to put the SYSDATE parameter and how is should look given the context?