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 -> Count(*) different then rows exported on import

Count(*) different then rows exported on import

From: Chris <christianboivin1_at_hotmail.com>
Date: 20 Mar 2003 03:39:27 -0800
Message-ID: <da20daf0.0303200339.3f8a2826@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 - 05:39:27 CST

Original text of this message

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