CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloperoracle19c
Francesco Mantovani
Francesco Mantovani

Reputation: 12357

Oracle Database 19c Sample Schemas :: import sample from Oracle SQL Developer GUI instead of command line

I have a Microsoft background and I'm learning Oracle products.

I was able to import Oracle Database 19c Sample Schemas on a Docker Oracle image from command line following this guide.

I now would like to know if there is a way to import the same sample through a GUI using Oracle SQL Developer.

With SSMS is quite simple to import/export databases, row data, CSV, etc... but I don't see the same tool for Oracle SQL Developer.

EDIT:

@thatjeffsmith suggested to right click on tables > Data Import Wizard, but when I select "db-sample-schemas-master" I only find the samples with .sql files in it and .sql files cannot be imported with this tool

enter image description here

Upvotes: 1

Views: 1018

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22457

It depends.

The .SQL files can be ran through the SQL worksheet via F5 no problem.

The sqlldr scenarios, you could rename the .dat files to .dsv files.

Right click on your table, like Sales History SH entries, choose Import Data, and walk the wizard.

But, it would be much easier to just follow the instructions as is, especially if you are new to Oracle.

Upvotes: 2

Related Questions