Creating a table using a local CSV file

Question

I have the following query to create a table, however the file name is on my local computer (since I do not have access to Oracle Box), how can I use a local file to create a table in the Oracle database). All the examples I've seen assume that the file is on an Oracle Database Server.

CREATE OR REPLACE DIRECTORY file_dir AS 'c:/temp'; GRANT WRITE ON DIRECTORY file_dir TO CPS_OWNER; create table CPS_OWNER.TEMP_TOGGLE_LIST ( USER_ID varchar2(30) ) organization external ( type oracle_loader default directory file_dir access parameters (records delimited by newline fields) location ('users.csv') ) reject limit unlimited; 

Answer 1

Right-click in SQL Developer on the node tables in the connection tree.

Select "Import Data"

Specify the CSV file.

Go through the master.

I will talk about this in detail with screenshots here .