Oracle SQL Developer import wizard missing?

1.6k Views Asked by At

I am using this tool to import a csv file to a MS sql database. I've just downloaded the free package for version 18.1.0. I am new to the tool. My research shows that if I right-click on 'Tables' I should see an option to start the import wizard; but the only option I see is 'Refresh'. I also see 'apply filter' and 'clear filter' which are greyed out. Is this because I am using a free version? Or because I am connected to a sql dbinstead of an Oracle db? My csv has 50 fields and I don't want to create my table manually e.g. thru defining an external table. Is there a practical work around for my case?

1

There are 1 best solutions below

2
thatjeffsmith On

That feature is ONLY for an Oracle Database.

if you want support for doing things on SQL Server - you should probably be using their tools, like SSMS.

Our SQL Server support is limited to helping you get things FROM SQL Server TO Oracle.

I talk about this more here.

One exception to this is the Data Modeler. We'll let you build a relational/physical model for SQL Server, but again, the features are built for Oracle first, and sometimes only.