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

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

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Fri, 21 Mar 2003 16:02:22 -0000
Message-ID: <iIGea.4072$pK2.4400@news.indigo.ie>

What does ANALYZE TABLE COMPUTE STATISTICS write to USER_TABLES for sample_size and num_rows ?
"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 Fri Mar 21 2003 - 10:02:22 CST

Original text of this message

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