If that's a comma separated text file, rename to it to *.csv.1 person found this helpful
As for the best way of importing big flat files, that would be SQL*Loader, but involves some more work and knowledge (see the manual and forum with the same name)...
The Data Import Wizard almost froze on step one reading the file, it has only 120,000 records and not very wide, after it came back I had all the column data types specified, click on verify then finish and it ran for few minutes; when I refreshed no new table was created.
I loaded the file to MS Access and tried to push the table through using ODBC with the Access Export Wizard; it ran for few minutes and when I refreshed in Oracle, the table was there and looked perfect.
Off first glance Oracle's SQL Developer does not appear to be a mature product. At least it lacks the data pump that MS SQL Enterprise Manager does which is ultra fast and easy to use.
Thanks for the help, I will use Access as a bridge then.
I just ran an experiment using Access as my "bridge" to copy a large table (300,000 records) from one database to another.
I started an append query and an export at the same time. The export query ran more quickly, but created VARCHAR2(320 BYTE) (Memo in Access) fields in 3 of the 4 cases where there should have been a number field.
Can you provide the table structure for the table that you are trying to import? You can email it to email@example.com. If can provide the actual file that you are trying to import that would be ideal.
What if it is tab delimited? I have a file that has fields with descriptions in them. The descriptions have commas in them. How do I import these if I can only import csv files?
If you use a recent SQL Developer (say, either of the 3.0 or 3.1 production versions), the Data Import Wizard (Step 1 of 5) will let you specify a file Format of delimited and a Delimiter of tab.
SQL Developer Team
I use the current version of Oracle SQL Developer, I started getting this error after the last update. I can not upload fixed length text fields anymore. I have to load it into Excel or LibreOffice and save it out as a .csv. Why can I not upload text files through developer anymore?
Please don't hijack another user's 4 year old thread for your own issues.
If you have a question or issue create a new thread and provide your specific information about the problem including the full version number for sql developer and the platform you are using.