expdp creates more dmp files than specified in parallel parameter
Hi,
I run nightly exports of various 10g (10.2.0.4.0) databases using parfiles on the lines of
dumpfile=dmpfile_%U.dmp
logfile=logfile.log
directory=whereever
parallel=<number of CPUS>
this produces logs like this one
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_11": system/******** schemas=s1,s2,s3 dumpfile=expdp_schemas_%U.dmp logfile=expdp_schemas_exp.log exclude=grant flashback_time="to_timestamp(to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss')" metrics=y directory=WHEREEVER parallel=24
.
.
.
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_11 is:
/opt/exports/expdp_schemas_01.dmp
/opt/exports/expdp_schemas_02.dmp
...
/opt/exports/expdp_schemas_25.dmp
I run nightly exports of various 10g (10.2.0.4.0) databases using parfiles on the lines of
dumpfile=dmpfile_%U.dmp
logfile=logfile.log
directory=whereever
parallel=<number of CPUS>
this produces logs like this one
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_11": system/******** schemas=s1,s2,s3 dumpfile=expdp_schemas_%U.dmp logfile=expdp_schemas_exp.log exclude=grant flashback_time="to_timestamp(to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss')" metrics=y directory=WHEREEVER parallel=24
.
.
.
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_11 is:
/opt/exports/expdp_schemas_01.dmp
/opt/exports/expdp_schemas_02.dmp
...
/opt/exports/expdp_schemas_25.dmp
0