How To Perform a Full Export And Exclude Certain Schemas Using The Data Pump API?
(Doc ID 1340781.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
You want to perform a full export and exclude certain schema(s) using the Data Pump API (dbms_datapump).
The next example demonstrates how to perform this operation.
In this example, you have the following environment, you have 20 schemas in your database:
20 rows selected.
You want to export the entire database but want to exclude the SYSTEM and SCOTT only while using the DataPump API.
To perform this operation from the command line for the data pump export (expdp) looks like:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!