Sqlldr correlation

-- DROP SEQUENCE SEQ_P_ENTERHALLLEADFLOW_CODES

CREATE SEQUENCE SEQ_P_ENTERHALLLEADFLOW_CODES START WITH 1 CACHE 100

CREATE OR REPLACE TRIGGER tri_1 BEFORE INSERT ON P_ENTERHALLLEADFLOW_CODES FOR EACH ROW WHEN (NEW.ID IS NULL)

BEGIN

SELECT SEQ_P_ENTERHALLLEADFLOW_CODES.NEXTVAL INTO: NEW.ID FROM DUAL

END

/

Sqlldr sh20000_wx/sh20000_wx log=1.log bad=1.bad discard=dis.log control=1.ctl

LOAD DATA

INFILE '1.text'

INFILE "2.txt"

APPEND

INTO TABLE P_ENTERHALLLEADFLOW_CODES

Fields terminated by ","

TRAILING NULLCOLS

(

ID "SEQ_P_ENTERHALLLEADFLOW_CODES.NEXTVAL"

LEAD_CODE

Isvalid FILLER

)

CREATE INDEX IDX_lead_code ON P_ENTERHALLLEADFLOW_CODES (lead_code) tablespace TSH10000_WX

Sqlldr tt/tt log=1.log bad=1.bad discard=dis.log control=11.ctl

Dos2unix

= =

# crm start #

#

# interface

Rm-f de_bst_interface.txt

Cat / oradata2/share_interface/hmbst/in/97SI*.txt > de_bst_interface.txt

Mv / oradata2/share_interface/hmbst/in/97SI*.txt / oradata2/share_interface/hmbst/arch

Sqlldr userid=add114/add114 control=de_bst_interface.ctl log=log/de_bst_interface_$TIME.log errors=1000 bad=de_bst_interface_$TIME.bad

#

# details

Rm-f de_bst_details.txt

Cat / oradata2/share_interface/hmbst/in/97SD*.txt > de_bst_details.txt

Mv / oradata2/share_interface/hmbst/in/97SD*.txt / oradata2/share_interface/hmbst/arch

Sqlldr userid=add114/add114 control=de_bst_details.ctl log=log/de_bst_details_$TIME.log errors=1000 bad=de_bst_details_$TIME.bad

#

# bad

Cp de_bst_interface*.bad / oradata2/share_interface/hmbst/bad

Cp de_bst_interface*.bad / oradata2/share_interface/hmbst/arch

Rm-f de_bst_interface*.bad

Cp de_bst_details*.bad / oradata2/share_interface/hmbst/bad

Cp de_bst_details*.bad / oradata2/share_interface/hmbst/arch

Rm-f de_bst_details*.bad

#

# crm end #