Home » RDBMS Server » Server Utilities » sequence in sqlldr (oracle 10.2 solaris)
sequence in sqlldr [message #562393] Wed, 01 August 2012 04:04 Go to next message
guddu_12
Messages: 227
Registered: April 2012
Location: UK
Senior Member
Hi Gurus,

I have written a sqlloader control file which load the data from text file, i want to load additional column as a sequence number.
How can i achive it.

my control file looks like below.

load data
        BADFILE '/backup/temp/rajesh/RIO/BadFiles/FILENAME'
        append into table TEMP_rio_RESP_TIME_LND
        TRAILING NULLCOLS
        (
        INSTALLATION_ID          CHAR
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
        TRANSACTION_ID           CHAR
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
        SERVER_ID                CHAR
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
        CLINICAL_TRANSACTION_ID  CHAR
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
        RESPONSE_TIME DECIMAL EXTERNAL
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
        TRANSACTION_START_TIME   TIMESTAMP
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"' "TO_TIMESTAMP(:TRANSACTION_START_TIME,'DD/MM/YYYY HH24:MI:SSXFF')",
        TRANSACTION_END_TIME     TIMESTAMP
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"' "TO_TIMESTAMP(:TRANSACTION_END_TIME,'DD/MM/YYYY HH24:MI:SSXFF')",
        LOCATION_ID              CHAR
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
        WAIT_TIME          DECIMAL EXTERNAL
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
        INTERNAL_TRANSACTION_ID  CHAR
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
        INTERNAL_TIME  DECIMAL EXTERNAL
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
        EXTERNAL_SERVICE_ID      CHAR
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
        EXTERNAL_SERVICE_TIME    DECIMAL EXTERNAL
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
        LOCAL_SERVICE_ID         CHAR
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
        LOCAL_SERVICE_TIME       DECIMAL EXTERNAL
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
        MESSAGE_GUID             CHAR
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
        RETURN_MESSAGE_GUID      CHAR
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
        TRS_SIZE     DECIMAL EXTERNAL
        TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"'  ,
        FILE_NAME    CONSTANT
        "FILENAME",
        DATE_LOADED              SYSDATE  ,
        ORIGINAL_DATE_LOADED     SYSDATE
        )
Re: sequence in sqlldr [message #562394 is a reply to message #562393] Wed, 01 August 2012 04:11 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Check the SEQUENCE parameter.
Re: sequence in sqlldr [message #562397 is a reply to message #562394] Wed, 01 August 2012 04:38 Go to previous message
guddu_12
Messages: 227
Registered: April 2012
Location: UK
Senior Member
Thanks
Previous Topic: Running exp and imp command on 11.2.0.1.0 Production version
Next Topic: calculated column population using sql loader
Goto Forum:
  


Current Time: Thu Mar 28 09:51:02 CDT 2024