Data changing when exporting and importing a table

From: Papa Piquillo <oraclejva_at_yahoo.es>
Date: 2 Jun 2006 01:40:13 -0700
Message-ID: <1149237613.924364.227490@j55g2000cwa.googlegroups.com>

Hello Group:
Im using Oracle 9206 under hp-ux pa-risc 11.11 I have done the following:
exp user/pass_at_sid1 file=punica.dmp tables=tmp_paga_unica imp user/pass_at_sid2 file=punica.dmp fromuser=user touser=user No warnings, no errors. Same NLS character set.

The table tmp_paga_unica is like:

Name                                      Null?    Type
 ----------------------------------------- --------
----------------------------
 COD_PERSONA                                        NUMBER(8)
 DI_VALOR                                           NUMBER

SQL> select count(*)
  2 from tmp_paga_unica;

  COUNT(*)

---

       329
(not very big :)

And after importing the value of di_valor for some values of cod_persona changes.
(sid1)

select *

   from tmp_paga_unica
   where cod_persona = 964
COD_PERSONA DI_VALOR
----------- ----------

        964 373.8

(sid2)

SQL> r
  1 select *
  2 from tmp_paga_unica
  3* where cod_persona = 964

COD_PERSONA DI_VALOR
----------- ----------

        964 123.55

I have reproduced the issue on oracle 8.1.7.4 Has anybody seen anything like this??
Thanks. Received on Fri Jun 02 2006 - 03:40:13 CDT