Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Count(*) different then rows exported on import
No errors on my export
everything OK
Chris
"yikaikai" <yikaikai_no_spam_at_sina.com> wrote in message news:<b5cee9$1mgn$1_at_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 Fri Mar 21 2003 - 09:32:20 CST