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

I'm exporting as the user (have dba role granted) and what is FGAC ?

Thanks

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:<uynea.3847$pK2.4125_at_news.indigo.ie>...
> Exporting as SYS but doing select as user with FGAC enabled ?
> "Chris" <christianboivin1_at_hotmail.com> wrote in message
> news: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:36:04 CST