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: Thu, 20 Mar 2003 18:14:49 -0000
Message-ID: <uynea.3847$pK2.4125@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 Thu Mar 20 2003 - 12:14:49 CST

Original text of this message

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