Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Expdp taking more time

2790985May 10 2015 — edited May 10 2015

Hi,

Schema export is taking more than 2 hours and found the following in the nohup.out file. I ran it using par file. I used expdp utility. Schema size is 16 GB. I don’t find anything abnormal in the DB alert log file.Could you please comment on this.

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

The export parfile I have used is below.

USERID="/ as sysdba"

DIRECTORY=DUMPDIR

DUMPFILE=DEEM_schema_expdp_%U.dmp

LOGFILE=DEEM_schema_expdp.log

schemas=DEEM

PARALLEL=4

compression=all

I even used following expdp command but the output is same.

expdp SCHEMAS=DEEM directory=DUMPDIR dumpfile=DEEM_schema_expdp.dmp logfile=DEEM_schema_expdp.log job_name=DEEM_schema

Oracle -- 11.2.0.4.0

OS --- Linux 6.6

This is HA cluster

Regards,

Bala

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 7 2015

Added on May 10 2015

#database-key-features, #export-import-sql-loader-external-tables

8 comments

1,515 views