How do I insert table data with a lob column into an external table?
I am creating an external table and looking to load data into the external table from an existing table in the database. One of the table columns is defined as a clob value. Does anyone have examples of doing a similar load? Below is my external code create statement and I am trying to determine how to insert data from a table in my database into this external table.
DROP TABLE ext_epl_comment_cp_template;
CREATE TABLE ext_epl_comment_cp_template
("SUBMISSION_ID" VARCHAR2(64),
"COMMENT_ID" NUMBER(*,0),
"COMMENT_TITLE" VARCHAR2(255),
"COMMENT_TEXT" CLOB,
"SECTION_ID" VARCHAR2(255),
"SECTION_CONTENT" VARCHAR2(2000),