Re: Datapump import question:
- From: rjamya <rjamya@xxxxxxxxx>
- To: piontekdd@xxxxxxxxx
- Date: Thu, 30 Jun 2011 20:27:15 -0400
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@xxxxxxxxx> 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@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
>
>
>
--
-----
Best regards
Raj
Other related posts:
