Database Utilities (MOSC)

MOSC Banner

datapump include line

edited Jun 23, 2014 10:42AM in Database Utilities (MOSC) 3 commentsAnswered

I am trying to get this INCLUDE line to run in a datapump session but I get the error about a malformed parameter file, i.e. INCLUDE entry.

INCLUDE=TABLE:\"IN \(SELECT object_name FROM USER.expdp_tab WHERE owner=\'USER\' AND object_type=\'TABLE\'\)\"  >> %PARAMETERFILE%

This is on Windows Server and 10.2.0.3.0 EE.

I am using a table that contains the names of the USER schema tables because of the problem with Tables too long list errors in DataPump.

Is the syntax right for Windows?

thanks.

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