CODEWITHSUNDEEP
oracle-databaseexport
nayakam
nayakam

Reputation: 4261

Multiple table export in oracle

Is it possible to export multiple tables in oracle using QUERY parameter the WHERE clauses are different for each table?

Upvotes: 3

Views: 21205

Answers (1)

Alex Poole
Alex Poole

Reputation: 191570

If you're using the old export (exp) then no, you'd need to do a separate export for each table. The restrictions are shown in the documentation.

If you're using data pump (expdp) then yes, you can specify multiple QUERY clauses and specify which table each applies too, again as described in the documentation.

Upvotes: 3

Related Questions