Last beta version of TOAD 5.8.
I want to import records from one DB in another.
I export records with your export wizard in MS-Excel format from source DB without problems, after this I try to import in a valid DB and create a new table to import it.
See me screenshot in attach for details.
First data_import.jpg show you a column/field COSTOULT. As you can see it’s a decimal field.
In statement create table was defined as numeric(18,5).
See second screenshot - import_target.jpg. As you can see COSTOULT is a INT value.
Why this ?
I never see it and I try to import many time the records but when I import a value with decimal part I obain an error message and I can’t import records.
After discover this I change manually the - type - of the field and all is OK.
It’s possible to excluse some column name from import process ?
If yes, how ?
I stay tune for your explanation / consideration…