Re: Datapump import question:

From: rjamya <rjamya_at_gmail.com>
Date: Thu, 30 Jun 2011 20:27:15 -0400
Message-ID: <BANLkTimpFKR2vhP12QtdZ9BwPFN30WKkBQ_at_mail.gmail.com>

Bradd, this is due to a bug in dbms_metadata package and can be see if you use remap_schema or remap_tablespace for impdp.

Raj

On Thu, Jun 30, 2011 at 7:27 PM, Bradd Piontek <piontekdd_at_gmail.com> wrote:

> 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
>
>
>

-- 
-----
Best regards
Raj

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

Received on Thu Jun 30 2011 - 19:27:15 CDT