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

> What does ANALYZE TABLE COMPUTE STATISTICS write to USER_TABLES for
> sample_size and num_rows ?

That give me the same number as the export not as the count, now i know that is the count(*) who don't give me the
good info, i'd did a insert into as select and i'd insert the same number as the rows exported and num_rows number ...
and the select count(*) from my new table give me the good count(*) very strange ...

my tablespace are locally managed

my table are not partionned

I don't understand this one

Thanks

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:<iIGea.4072$pK2.4400_at_news.indigo.ie>...
> = VPD (Fine Grained Access Control).
>
>
> "Chris" <christianboivin1_at_hotmail.com> wrote in message
> news:da20daf0.0303210736.47eebbe1_at_posting.google.com...
> > 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 Sat Mar 22 2003 - 06:41:20 CST