Database Utilities (MOSC)

MOSC Banner

Table mode export from Multiple Schema

edited Apr 7, 2010 2:34AM in Database Utilities (MOSC) 1 commentAnswered
 Hi,

I need to use datapump API to import tables from different schemas. While trying to use SCHEMA_EXPR filter to specify multiple schemas, I get an error which could be due to following as mentioned in oracle doc:-

<font color="#336699" face="Courier New" size="3"><span style="font-size: 12pt;">SCHEMA_EXPR</span></font>

<font color="#336699" face="Courier New" size="3"><span style="font-size: 12pt;">SCHEMA_LIST</span></font>

Schema objects

Restricts the job to objects whose owning schema name is satisfied by the expression.

For Table mode, only a single <b><font color="#336699" face="Courier New" size="2"><span style="font-weight: bold;font-size: 10pt;">SCHEMA_EXPR</span></font> </b>

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