Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Count(*) different then rows exported on import
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
![]() |
![]() |