title: Creating Table using Local CSV File
body: <p>I have the following query to create a table however the file name is located on my local machine (as I don't have access to the Oracle Box) how can I use a local file to create a table on the Oracle Database). All the examples I have seen assume the file is located on the Oracle Database Server.</p>
  
  <pre><code>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;
  </code></pre>