Re: Datapump import question:

From: Mayen.Shah@xxxxxxxxxx

To: "Bradd Piontek" <piontekdd@xxxxxxxxx>

Date: Thu, 30 Jun 2011 23:25:18 -0400

Yes Bradd, I am sure it is importing table statistics because out put on
terminal as well as tail of datapump log file stays at following statement
for more than 4 hours.
Processing object type
DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
At that point tables were already imported (again confirmed by the output
of a command)
What puzzles me is importing tables took less than an hour while
statistics import took more than four hours.
Thank you
Mayen
From: "Bradd Piontek" <piontekdd@xxxxxxxxx>
To: Mayen Shah/ITS/Lazard@Lazard NYC
Cc: oracle-l@xxxxxxxxxxxxx
Date: 06/30/2011 07:27 PM
Subject: Re: Datapump import question:
Are you sure it is importing table statistics and not importing some
really large table?
I would hit ctrl-c and type in 'status' to see what it is doing.
Bradd Piontek
On Thu, Jun 30, 2011 at 9:56 AM, <Mayen.Shah@xxxxxxxxxx> wrote:
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