Database Utilities (MOSC)

MOSC Banner

How do I insert table data with a lob column into an external table?

edited Jun 25, 2019 10:53AM in Database Utilities (MOSC) 6 commentsAnswered

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),

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center