SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

create an external table

ANNECFeb 16 2017 — edited Oct 20 2017

We are using Oracle 12 c. SQL developer 4.1. I would like to setup some routine import from a csv file to oracle database table.

I am going to use external table.

So I created a directory that points the directory of the data file.

Then I tried to use SQL developer tool to create an external table. I clicked create table in UI, created the columns, and also I chose the advanced , I tired to fill up the external table properties, the Access driver type I use is oracle_loader, but for the Access Parameters field, I don't know what to enter. And it doesnot automatically generated it either.

Do I have to manually enter it, how can I find the syntax?

Thanks,

Anne

This post has been answered by Gaz in Oz on Feb 16 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 16 2017

Added on Feb 16 2017

#sql-developer

1 comment

775 views