Re: Sqlldr Query

Gents,

I just want to report back to you that I am using external tables and MERGE INTO successfully for the initial population and daily update on some 42 tables within the database. My experience is limited to attending a couple of 9i database courses and also an PL/SQL course within the last 12 months and there is no-one on staff to ask questions of. Even so, with the help of this group and referring to the documentation everything is now working well and the amount of code to do the task was minimal. Many thanks to those who replied.

Regards,
Ian

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1094795629.597943_at_yasure...
> Hans Forbrich wrote:
>
> > Daniel Morgan wrote:
> >
> >
> >>Hans Forbrich wrote:
> >>
> >>
> >>>Ian wrote:
> >>>
> >>>
> >>>
> >>>>From Daniel Morgan's reply I decided to look at
> >>>>external tables.
> >>>
> >>>
> >>>For the sake of amusement - External Tables are [currently] defined
using
> >>>SQL Loader syntax, and are accessed by the system using SQL Loader
> >>>mechanisms.
> >>>
> >>>You won't get away from the SQL Loader section of the Utilities manual
> >>>that easily <g>
> >>>
> >>>/Hans
> >>
> >>Except that in 10g external tables and not read only ... you can write
> >>them to. I don't think SQL*Loader can do that.
> >
> >
> > Referring to Chapter 13 of the Oracle10g Utilities Reference manual.
There
> > are 2 'drivers' for ORGANIZATION EXTERNAL tables: ORACLE_LOADER and
> > ORACLE_DATAPUMP
> >
> > ORACLE_LOADER uses much of the 'traditional' SQL Loader syntax, and
provides
> > a read-only mechanism to map to files containing data that can be
created
> > from an external source.
> >
> > The way I understand it, the new-for-10g ORACLE_DATAPUMP driver reads
and
> > writes in a proprietary binary format (see
> >

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10825/et_concepts.htm#i1009127)
> >
> > /Hans
>
> My understanding is the same as yours. I am working on a demo for the
> new external table functionality I hope to demo next week at the
> September PSOUG meeting along with some DBMS_ADVISOR and DBMS_SQLTUNE.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)
>
Received on Thu Sep 16 2004 - 18:47:10 CDT