Re: Datapump import question:

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Thu, 30 Jun 2011 18:27:09 -0500
Message-ID: <BANLkTikw-g3mXfEXdcq=cVSEhXdigDhjsg_at_mail.gmail.com>

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_at_lazard.com> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 30 2011 - 18:27:09 CDT