Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Count(*) different then rows exported on import

Re: Count(*) different then rows exported on import

From: yikaikai <yikaikai_no_spam_at_sina.com>
Date: Thu, 20 Mar 2003 21:08:05 +0800
Message-ID: <b5cee9$1mgn$1@mail.cn99.com>


when you do exp and imp, there no any error? "Chris" <christianboivin1_at_hotmail.com>
??????:da20daf0.0303200339.3f8a2826_at_posting.google.com...
> Hi,
>
> I don't understand why, when i count(*) from my table
> i get 1282730 rows and when i export my table
> with this parfile :
>
> FILE="g:\test\TEST.DMP"
> LOG="g:\test\TEST.log"
> tables=(my_table)
> direct=y
>
> i get 1282868 rows exported ... i found the problem
> while re-importing data into another database
> i can't validate my primary key because
> i have duplicate value ...
>
> Where this rows come from ?
>
> I use oracle 8.1.7 on windows 2000 sp3
>
> Thanks
> Chris
Received on Thu Mar 20 2003 - 07:08:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US