RE: Datapump import question:
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: "Mayen.Shah@xxxxxxxxxx" <Mayen.Shah@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 30 Jun 2011 15:04:55 +0000
Yes,
exclude=statistics
Hth,
-joe
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Mayen.Shah@xxxxxxxxxx
Sent: Thursday, June 30, 2011 8:56 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Datapump import question:
Hi List,
I have a Datapump import question:
Oracle 10.2.03 on Solaris 9
I have need to copy schema from one prod to dev database on weekly basis.
Datapump export took about 15 minutes.
Problem is with datapump import. Tables and indexes gets imported within
reasonable time (about hour) but table statistics takes very long time.
Import process stays at following for about more than three hours
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Is there any way to exclude table statistics? (similar to STATISTICS=N in old
export)
Any help is appreciated.
Thank you
Mayen
Confidentiality Note: This message contains information that may be
confidential and/or privileged. If you are not the intended recipient, you
should not use, copy, disclose, distribute or take any action based on this
message. If you have received this message in error, please advise the sender
immediately by reply email and delete this message. Although ICAT Managers,
LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for
viruses, it does not guarantee that either are virus-free and accepts no
liability for any damage sustained as a result of viruses. Thank you.
Other related posts:
