Database Administration (MOSC)

MOSC Banner

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!

Tagged:

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