Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

copying data between databases

439508Mar 3 2005 — edited Mar 4 2005
I 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 ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2005
Added on Mar 3 2005
7 comments
585 views