-
High Difference Between Count(*) Before Export And
There is a high difference between number of rows in the table before export
it, and after import. however when we see the import log we constat that all
rows had been imported but the difference was made when we perform a count(*)
from this table.
Thenfore, even when we create this table from a export with rows=n and apply an
import with ignore=y, or try to import without index then create them before
and so on, the problem remain the same.
.
-
Can you localise the problem by comparing:
1) count(*) before
2) number of rows exported (from the exp log)
3) number of rows imported (from the imp log)
4) count(*) after
-
1) count(*) before : 382481
2) number of rows exported (from the exp log) : 382481
3) number of rows imported (from the imp log) : 382481
4) count(*) after : 382237
-
Merde! Could there be a bad index?
What do you get with:
select /*+ FULL(mytab) */ count(*) from mytab;
-
Oracle8i Enterprise Edition Release 8.1.7.4.1
>select /*+ FULL(mytab) */ count(*) from mytab;
COUNT(*)
----------
382237
1 row selected.
>select count(*) from mytab;
COUNT(*)
----------
382237
1 row selected.
Same result !
-
Did you export with consistent =y? How do you know the data in the table was not being manipulated at the time of the export?
I'm stmontgo and I approve of this message
-
>desc myta
Name Null? Type
---------------- -------- ---------------------
O__NUM NOT NULL CHAR(13)
O__ST NOT NULL NUMBER(4)
O__EDN NOT NULL NUMBER(6)
O__KDN NOT NULL NUMBER(6)
O__EDX NOT NULL NUMBER(6)
O__KDX NOT NULL NUMBER(6)
O__KDXA NOT NULL NUMBER(6)
STRT NUMBER(6)
L_DESCRIBES CHAR(13)
L_CONTRACT CHAR(13)
L_BASE CHAR(13)
TERM_WRK_3_LS CLOB
this is the desc of mytab, so may be a problem with the CLOB type ?
but if it is, so, what's special between CLOB and exp/imp ?
-
stmontgo :
I did with consistent=y but no way. however, i'm the lone one who's working on, so, i think , problem come from some where else !
-
Your not logged in to the wrong instance are you?
I've done that.
MH
I remember when this place was cool.
-
sure, i'm logged to the right instance !
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|