--Reference Table structure SQL> desc BI_Reports_Framework Name Null? Type ----------------------------- -------- ----------------- REPORT_ID NOT NULL NUMBER REPORT_TYPE NOT NULL VARCHAR2(100) TEMPLATE_NAME NOT NULL VARCHAR2(50) REPORT_DESCRIPTION VARCHAR2(100) USER_GROUP VARCHAR2(50) REPORT_FRAMEWORK NOT NULL CLOB REPORT_STATUS NOT NULL VARCHAR2(1) CREATED_DATE NOT NULL DATE SQL> Note: The report_id column is populated by a trigger (similar to one shown in auto numbering trigger).
-- bireportsfw.ctl OPTIONS (BINDSIZE=2097152, READSIZE=2097152) LOAD INFILE 'bireportfw.txt' "str '***'" BADFILE 'bireportfw.bad' DISCARDFILE 'bireportfw.dis' APPEND INTO TABLE BI_Reports_Framework FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY "'" TRAILING NULLCOLS ( report_type CHAR, template_name CHAR, report_description CHAR, user_group CHAR, report_framework CHAR(60000), report_status CONSTANT "Y" )
55714