Correct Syntax To Exclude A Schema In Expdp. (Doc ID 742585.1)

Last updated on JUNE 02, 2014

Applies to:

Oracle Database - Standard Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 28-Sep-2012***

Goal

You are trying to export all schemas but one. According to the admin guide you should be able to do this.

From the guide

Excluding Grants and Users

To exclude a specific user and all objects of that user, specify a filter such as the following
(where hr is the schema name of the user you want to exclude):

EXCLUDE=SCHEMA:"='HR'"

Trying this as detailed in the documentation throws the error:

$ expdp directory=xaa_exports dumpfile=test.exp EXCLUDE=SCHEMA:"='AABUS'"
LRM-00116: syntax error at 'SCHEMA:' following '='

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms