Re: text file load

On Dec 6, 12:02 pm, dx111ge <sven.andr..._at_gmail.com> wrote:
> On 6 Dez., 18:37, gazzag <gar..._at_jamms.org> wrote:
>
>
>
>
>
> > On 6 Dec, 17:31, dx111ge <sven.andr..._at_gmail.com> wrote:
>
> > > be carefull, dumb user question:
> > > I have to load 4.2e data records in different tables , usually for a
> > > single table i would use sqlloader. But in this case i need some
> > > additional logic to manipulate the data records.
> > > Please, can somene point me into the right direction ?
>
> > > Thanks in advance
>
> > Oracle version?
>
> > Depending on the answer to the above, look into using External Tables:
>
> >http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/schema...
>
> > HTH
>
> > -g
>
> oracle 10.2.3 on windows server
>
> Thanks- Hide quoted text -
>
> - Show quoted text -

It also depends upon what 'logic' you need, as SQL*Loader can load multiple tables from a single control file/data file. You should look at:

$ORACLE_HOME/rdbms/demo/ulcase5.ctl

to get an idea of how to do this and what logic is available. Also peruse:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_control_file.htm#i1005798

David Fitzjarrell Received on Thu Dec 06 2007 - 12:57:26 CST