Database Utilities (MOSC)

MOSC Banner

Datapump export multiple of partitions?

edited Oct 5, 2015 12:18PM in Database Utilities (MOSC) 2 commentsAnswered

Hi,

Im trying to export a large number of partitions in our dw. Over 3500.

Is there away to do this in one go in expdp? I think the parfile is limited to 4000 chars.

I tried something like this:

Created a table and populated it with the partitions I want to export:

CREATE TABLE dbmaint.expdp_par (script VARCHAR2(200));


INSERT INTO dbmaint.expdp_par (script)

  select table_name || ':' || partition_name from dbmaint.ldx_part_drop_script  where status = 20;


This is the par file:


DIRECTORY=DATA_PUMP_DIR

DUMPFILE=rensningTEST%U.dmp

LOGFILE=rensning.log

PARALLEL=6

INCLUDE=TABLE:"IN (SELECT SCRIPT FROM DBMAINT.EXPDP_PAR)"

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