Database Tutorial

Course Tutorial Site

Site Admin

Oracle External Tables

with 3 comments

Oracle external tables are a neat device because they let you define a table inside the database that is dependent on an external physical file. You can import data through that file. This post explains the processes and potential problems with Oracle External Tables.

You have two options when you create Oracle External Tables. They may be defined as SQL*Loader or Oracle Data Pump files. SQL*Loader files are read-only and independent of any proprietary Oracle code and are best represented by Comma Separated Value (CSV), Tabbed Separated Value (TSV), or position specific files. Oracle Data Pump files are read-write and require an Oracle executable to read and write them.

You may also want to review this article. It shows you how to check if the external file is there before you query the data.

Written by michaelmclaughlin

February 21st, 2010 at 1:22 am

Posted in

3 Responses to 'Oracle External Tables'

Subscribe to comments with RSS or TrackBack to 'Oracle External Tables'.

  1. In task #1, step #1
    We are told to create importer and grant rights.
    For me it fails when doing a copy and paste.
    For me I had to do the following:
    (I added the Identified by, and removed the s from resource)

    CREATE USER importer IDENTIFIED BY importer;
    GRANT connect, resource, CREATE any VIEW TO importer;

    Clay Mullins

    25 Feb 10 at 1:18 am

  2. I do trust all of the concepts you have introduced to your post.
    They’re very convincing and will certainly work. Still, the
    posts are very short for newbies. May just you please extend them a little from subsequent time?
    Thanks for the post.

    curriculum

    19 Nov 16 at 6:48 pm

  3. Thanks for the note. I’ve been remiss in processing comments, it’s been a busy time.

    You may find this article more helpful.

    michaelmclaughlin

    22 Feb 17 at 9:02 pm

Leave a Reply