Re: Strange Datapump behavior.
From: Yong Huang <yong321_at_yahoo.com>
Date: Tue, 21 Jun 2011 09:45:01 -0700 (PDT)
Message-ID: <110254.17476.qm_at_web80603.mail.mud.yahoo.com>
> Importing as sys, using the remap_schema option, note the trans_id table
rows
>
> Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
>. . imported "NEWUSER"."ITEM" 686.4 MB 10427436 rows
>. . imported "NEWUSER"."ATTRIBUTE" 405.2 MB 11769794 rows
> . . imported "NEWUSER"."TRANS" 405.4 MB 3849581 rows
> . . imported "NEWUSER"."TRANS_ID" 339.7 MB 1961059 out of 3921843 rows
Date: Tue, 21 Jun 2011 09:45:01 -0700 (PDT)
Message-ID: <110254.17476.qm_at_web80603.mail.mud.yahoo.com>
> Importing as sys, using the remap_schema option, note the trans_id table
rows
>
> Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
>. . imported "NEWUSER"."ITEM" 686.4 MB 10427436 rows
>. . imported "NEWUSER"."ATTRIBUTE" 405.2 MB 11769794 rows
> . . imported "NEWUSER"."TRANS" 405.4 MB 3849581 rows
> . . imported "NEWUSER"."TRANS_ID" 339.7 MB 1961059 out of 3921843 rows
Andrew,
I found a couple of notes kind of related to this error:
Impdp Imports 0 Rows if Expdp has not completed (Doc ID 788571.1) Bug 7703796: WRONG RESULT IN 'IMPORTED # ROWS' OF IMPDP OUTPUT WHEN DOING IMPDP VIA DB-LINK Bug 9470999: IMPDP REPORTS INCORRECT AMOUNT OF ROWS IMPORTED IN PARALLEL MODE
But you're not getting *0* rows out of some rows, not using network_link and not using parallel import.
The web page below says it could be related to characterset conversion (you can use Google translator to read):
http://manchev.org/index.php/database/104-datapump-characterset-cl8mswin1251-al32utf8
But I don't think that applies to you either.
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 21 2011 - 11:45:01 CDT