PL/SQL (MOSC)

MOSC Banner

How to add a SYSDATE parameter to DBMS_DATAPUMP export

in PL/SQL (MOSC) 1 commentAnswered

Oracle 19c database on an AWS RDS instance... basically just want the data from the last week based on the date in a specific column.

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)

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