Whats the best way to....

From: Ken Douglas <ken_douglas_at_not1.demon.co.uk>
Date: Fri, 21 Aug 1998 13:32:15 +0100
Message-ID: <903702744.9245.0.nnrp-06.d4e4a6b7@news.demon.co.uk>

Whats the best way to import/populate from an ASCII file into an ORACLE DB. (We are using ORACLE SQL*Loader. 7.3 and AIX 4.3)

Wait there's more....

The problem is that the import ascii file contains many different types of records each wrapped in a header/trailer record format:-

    Transmission Header Record
    Header Record type 9
    Detail Record type 1
    Detail Record type 2
    Trailer record type 99
    Header Record type 91
    Detail Record type 12
    Detail Record type 22
    Trailer record type 992
    Header Record type 93
    Detail Record type 13
    Detail Record type 23
    Trailer record type 993
    Transmission Trailer record

The problem is that each record type is go into it;s own defined table (even the headers/trailer)
It is intended to import the whole record into one IMPORT table and then extract/insert into the required tables.

We want to validate each record type by branch and only import from the IMPORT table if the validation passes
for each branch(for that record type).

Is there a way within PL/SQL to do this:-

        SELECT server_A.Database_A.Table_A.Field_A,
                        server_B.Database_B.Table_B.Field_B etc...
        FROM server_A.Database_A.Table_A,
                    server_B.Database_B.Table_B
        WHERE server_A.Database_A.Table_A.field_X =

server_B.Database_B.Table_B.field_X

server_A is the host
server_B is the remote

I am sure you can. If that is the case then we can use it in our validation routines to check data is valid on another server/db.

Anyone done this kind of exercise before? Any help or advice is very much welcomed!

Lots of questions but hopefully lots of answers/advice!

Many thanks in advance,
Ken Received on Fri Aug 21 1998 - 07:32:15 CDT