Message-Id: <10577.113560@fatcity.com> From: =?iso-8859-1?q?paquette=20stephane?= Date: Wed, 2 Aug 2000 01:33:32 -0700 (PDT) Subject: dba_tables.num_rows = 10564.646 dba_tables.num_rows is showing with decimals ! This is on 8.1.5.1/Solaris 2.6 . MOT.WORLD:idba>select table_name,num_rows from dba_tables where num_rows <> trunc(num_rows); TABLE_NAME NUM_ROWS ------------------------------ --------- VGN_HISTORY 10564.646 VGN_PR 78.787879 VGN_TK 546.46465 VGN_UR 944.44444 MOH_NOEUD_EXEMPLES 5180.8081 MOH_OPEMKT_CADEAU 204.0404 MOH_OPEMKT_ELEMENT 17.171717 MOH_PARAMETRE 201.0101 MOH_REDIRECTION 68.686869 AGENDA 14.141414 NEXT_ID 12.121212 TEMPLATE 661.61616 TEMPLATE_PATH 614.14141 VGN_CI 895.9596 MOH_TMP_NOEUD_EXEMPLES 5361.6162 MOH_TRANSAC_PAIEMENT 62388.889 MOH_ARTICLES_ASSOCIES 15.151515 MOH_IMPORT 93847.475 MOH_ORIGINE 56.565657 MOH_STAT_HISTO_STOCK 2046383.8 MOH_STAT_RESULTAT 2629.2929 MOH_STAT_TBORD 390.90909 DR$TEMPLATE_CTX1$I 780169.7 MOH_ARTICLE_AVIS 72.727273 MOH_STAT_RESULTAT_BTQ 654.54545 MOH_STAT_TBORD_BTQ 120.20202 MOH_STAT_GRP_FAM_CORA 22392.929 MOH_BANDEAU 20.20202 28 rows selected. Pretty strange , anybody ? ===== Stephane Paquette DBA Oracle stephane_paquette@yahoo.com spaquette@houra.fr (33) 01 53 93 06 50 __________________________________________________ Do You Yahoo!? Kick off your party with Yahoo! Invites.