Datapump export multiple of partitions?
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)"