How to load data into Multiple tables through SQL*Loader ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to load data into Multiple tables through SQL*Loader ?

  1. #1
    Join Date
    Mar 2002
    Posts
    38

    How to load data into Multiple tables through SQL*Loader ?

    Hi Friends,

    How can I load data into multiple tables (Oracle database) through SQL*Loader with a comma delimited file.

    Example
    -------

    Table A
    -------
    Code Number,
    Name Varchar2(15)


    Table B
    -------
    Code Number,
    Name Varchar2(15)


    Table C
    -------
    Code Number,
    Name Varchar2(15)


    Flat File Data:
    ---------------
    10,JOHNSON
    20,ANTHONY
    30,JAMES

    The value starting with 10 should be loaded into Table A
    The value starting with 20 should be loaded into Table B
    The value starting with 30 should be loaded into Table C


    If you can give the script it will be very helpful.


    Thanks in Advance,
    Kishan
    SUROOP B

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    The manual has a "case study" for loading into multiple tables. What don't you understand?

  3. #3
    Join Date
    Mar 2002
    Posts
    38
    I got it Dapi,Thanks
    Kishan
    SUROOP B

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width