Hi all, I got like over 2GB text file which I needed to load into an Oracle Environment. I am currently using Toad for Data Analyst to do this… However, it takes more than 10 hours. I also encountered some issues along the way…
- Original file has row count of 2.4 million… but then I only get counts like few hundred thousands after importing it to the oracle envrionment. Even though I was shown the results of the import has the same number of records from the original text file.
- sometimes there’s a popup window with options to Roll Back, or Keep Open.
- One of the text files has got more records so when I was doing the import wizard it was throwing me back an error:
Parsing Error! Please try other delimeter quote or file encoding
Arithmetic operation resulted in an overflow
Can someone please guide me how to import huge data into an oracle environment using TOAD for Data Analyst or suggest which TOAD product I should be using to do this better.
Thanks in advance