copying data between databases
439508Mar 3 2005 — edited Mar 4 2005I am able to copy data between databases, but I loose precision in number-fields : the copy contains wrong values !
I create a simple test table in a database, fill it with three records and copy that table into another database.
When I query the table in the second database, I got other results as when I query the first database : floating-point values are rounded to integers.
Below the commands I gave in SQL-plus
SQL> create table test (key number(10), quantity number);
SQL> insert into test values (1,1.5);
SQL> insert into test values (2,0.123456789);
SQL> insert into test values (3,4);
SQL> select * from joris_test;
KEY QUANTITY
---------- ----------
1 1,5
2 ,123456789
3 4
then I log in to the other database
SQL> copy from srg/black87@boff -
to srg/srg@jad -
create joris_test â
using select * from joris_test
Grootte van ophalen/bind van array is 15. (arraygrootte is 15).
Vastleggen bij voltooiing. (COPYCOMMIT is 0).
Maximum LONG grootte is 80. (long is 80).
Tabel JORIS_TEST is aangemaakt.
3 rijen geselecteerd van srg@boff.
3 rijen ingevoegd in JORIS_TEST.
3 rijen vastgelegd in JORIS_TEST bij srg@jad.
SQL> select * from joris_test;
KEY QUANTITY
---------- ----------
1 2
2 0
3 4
I am missing something ?