5 Replies Latest reply on Oct 5, 2019 3:15 PM by 3698339

Tried everything to get SQL Loader Utility to be an import option in SQL Developer

3698339 Oct 2, 2019 5:57 PM

I'm stumped on how to get SQL Loader Utility to show as a import option in SQL Developer. No matter what I do, the utility never shows up as an option. I installed the 11g client with SQL Loader and set that as the oracle home. No matter what I do the tool never shows up as an option for Import.

1. Re: Tried everything to get SQL Loader Utility to be an import option in SQL Developer

Glen Conway Oct 2, 2019 6:23 PM (in response to 3698339)

You will find that in Step 2 of the Data Import Wizard, after picking the file containing the data to import in Step 1.
You can read about it in https://www.thatjeffsmith.com/archive/2012/08/using-oracle-sql-developer-to-setup-sqlloader-runs/
Like Show 0 Likes(0)

Actions
2. Re: Tried everything to get SQL Loader Utility to be an import option in SQL Developer

thatJeffSmith-Oracle Oct 2, 2019 7:23 PM (in response to 3698339)

it's not available for Excel file imports, save your excel file as a CSV, and you'll be good to go
Like Show 0 Likes(0)

Actions
3. Re: Tried everything to get SQL Loader Utility to be an import option in SQL Developer

Glen Conway Oct 2, 2019 9:13 PM (in response to thatJeffSmith-Oracle)

And I think the Import Data Wizard has a minor bug. If you have both an xlsx and a csv export and
1) Pick the xlsx first. Then, as you stated, the Import Method drop-down contains no SQL*Loader Utility
2) Go back and pick the csv. Then Import Method still lists no SQL*Loader option.

You need to cancel the wizard and start over by picking the csv export. Then Import Method drop-down contains SQL*Loader Utility in the list.
Like Show 0 Likes(0)

Actions
4. Re: Tried everything to get SQL Loader Utility to be an import option in SQL Developer

3698339 Oct 3, 2019 3:36 PM (in response to 3698339)

Thank you! Thanks for pointing out the bug.
Like Show 0 Likes(0)

Actions
5. Re: Tried everything to get SQL Loader Utility to be an import option in SQL Developer

3698339 Oct 5, 2019 3:15 PM (in response to Glen Conway)

Thank you. I use the import often for excel documents and was expecting to show up. I thought it did in other past release but could be wrong since it has been a few years using that utility.
Like Show 0 Likes(0)

Actions

Go to original post