expdp on multi join table
I'm looking for suggestion to take datapump backup using the following query,
This is a multi join table any lead on how to take backup of this multi joins using datapump and import successfully? view_as_table is the option?
select t1.* from schemaa.document t1, schemaa.document_metadata t2
where
t1.table A = t2.table A and
id is not null and rownum <= 150000 and trunc(upload_date) >= '01-JAN-23';
Thanks!