Re: Datapump import question:
- From: Bradd Piontek <piontekdd@xxxxxxxxx>
- To: Mayen.Shah@xxxxxxxxxx
- Date: Thu, 30 Jun 2011 18:27:09 -0500
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
Other related posts:
