How To Use Escape for Underscore In Exclude Clause in DataPump Export (Doc ID 778888.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1]
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
Information in this document applies to any platform.

Goal

How can you format the EXCLUDE statement so that you can Escape the "_" (underscore character) in an object name?

By default the underscore character is interpreted by DataPump to represent any character. For example, if you specify 'TR_", Datapump looks for any match to TR<any character> (i.e., TRB, TRZ, etc.). 

So the question here is how to change this default behavior so that "R_" is intpreted by Datapump to mean underline and not "any character".

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