| Toad:export and import, value difference for big numbers [message #478912] |
Wed, 13 October 2010 09:22  |
McLan
Messages: 36
Registered: April 2008
|
Member |
|
|
I wanted to load some data(selected rows) from one system to other.
from source(production) system Toad: selected * from employee table where registration date is not today.
from data grid I exported the rows using save as (in insert statement format) to employee.sql.
the sql file(employee.sql) has the below values for emaplyee code:
2,60716197237375E17
in the source(production) system this value is 260716197237375278,
Later I loaded the sql file to dev system at linux prompt with sql file
@emplaoyee.sql
I retrieved the data after loading using to_char
select toc_char(emp_code) from employee_t;
the value I got is :260716197237375000
where as my expectation is : 260716197237375000
Is there any configuration required on linux system to convert the data correctly while loading to database using @employee.sql?
To conclude:
Exported value : 260716197237375278 (but exported as 2,60716197237375E17)
After import the value is : 260716197237375000 instead 260716197237375000
Regards,
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
