RE: Datapump import question:

  • From: Mayen.Shah@xxxxxxxxxx
  • To: "Sweetser, Joe" <JSweetser@xxxxxxxx>
  • Date: Thu, 30 Jun 2011 12:32:08 -0400

Thank you Joe,

I will test it out and will update.

Thanks
Mayen




From:   "Sweetser, Joe" <JSweetser@xxxxxxxx>
To:     Mayen Shah/ITS/Lazard@Lazard NYC, "oracle-l@xxxxxxxxxxxxx" 
<oracle-l@xxxxxxxxxxxxx>
Date:   06/30/2011 11:05 AM
Subject:        RE: Datapump import question:



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: