Home » SQL & PL/SQL » Client Tools » Toad:export and import, value difference for big numbers (10g)
Toad:export and import, value difference for big numbers [message #478912] Wed, 13 October 2010 09:22 Go to next message
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,
Re: Toad:export and import, value difference for big numbers [message #478921 is a reply to message #478912] Wed, 13 October 2010 11:20 Go to previous messageGo to next message
BlackSwan
Messages: 26733
Registered: January 2009
Location: SoCal
Senior Member
>Is there any configuration required on linux system to convert the data correctly while loading to database using @employee.sql?
From my perspective, the problem is NOT while loading the second DB.
The problem is "2,60716197237375E17" is missing 3 digits of precision during the save operation.
Why bother going to text file & not just move the data via DB_LINK?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Toad:export and import, value difference for big numbers [message #479004 is a reply to message #478921] Thu, 14 October 2010 03:13 Go to previous messageGo to next message
knw15pwr
Messages: 134
Registered: March 2010
Senior Member
You can Try this.
On the Data grid. Right Click -> Grid Options -> In the subsequent menu for Data...Un-select - "Display large numbers in Scientific notations"

P.S.: After changing the above settings, re-execute your query and then save the data.

[Updated on: Thu, 14 October 2010 03:15]

Report message to a moderator

Re: Toad:export and import, value difference for big numbers [message #479569 is a reply to message #478921] Mon, 18 October 2010 06:17 Go to previous message
McLan
Messages: 36
Registered: April 2008
Member
Thank you very much db_links is working for me
Also Un-selecting - "Display large numbers in Scientific notations" works.

Thank you very much for the helpful suggestion

[Updated on: Mon, 18 October 2010 06:19]

Report message to a moderator

Previous Topic: Break and Compute command usage to modify the output
Next Topic: Running CodeXpert through command Line using Toad 9.0
Goto Forum:
  


Current Time: Sun Sep 27 01:21:04 CDT 2020