dba_tables.num_rows = 10564.646

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Wed, 2 Aug 2000 01:33:32 -0700 (PDT)
Message-Id: <10577.113560@fatcity.com>

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_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50

Do You Yahoo!?
Kick off your party with Yahoo! Invites. Received on Wed Aug 02 2000 - 03:33:32 CDT