DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: High Difference Between Count(*) Before Export And

  1. #1
    Join Date
    May 2004
    Location
    FRANCE
    Posts
    7

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

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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

  3. #3
    Join Date
    May 2004
    Location
    FRANCE
    Posts
    7
    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

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Merde! Could there be a bad index?

    What do you get with:
    select /*+ FULL(mytab) */ count(*) from mytab;

  5. #5
    Join Date
    May 2004
    Location
    FRANCE
    Posts
    7
    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 !

  6. #6
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    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

  7. #7
    Join Date
    May 2004
    Location
    FRANCE
    Posts
    7
    >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 ?

  8. #8
    Join Date
    May 2004
    Location
    FRANCE
    Posts
    7
    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 !

  9. #9
    Join Date
    Jan 2001
    Posts
    3,134
    Your not logged in to the wrong instance are you?

    I've done that.

    MH
    I remember when this place was cool.

  10. #10
    Join Date
    May 2004
    Location
    FRANCE
    Posts
    7
    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
  •  


Click Here to Expand Forum to Full Width