Return
-
Title
Error "Integer overflow" when importing using Data Pump. -
Description
The following exception error occurs when trying to use the Data Pump Import Wizard:
"Toad for Oracle has encountered a problem. We are sorry for the inconvenience.
Integer overflow"
-
Cause
Instead of selecting 'New Import', the option 'Use Existing File' was selected instead in error. The filename expected is a parameter file (.dat). The above error will occur if the actual dump file (.dmp) is specified here. -
Resolution
Use 'New Import' option and the dump file can be specified in the 'Files' tab (in association with the DIRECTORY option to specify the folder location of the dump file on the server where the data is to be imported to)