OraFAQ Forum: Server Utilities » Use SQL Loader to load CLOB/BLOB data

Home » RDBMS Server » Server Utilities » Use SQL Loader to load CLOB/BLOB data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Use SQL Loader to load CLOB/BLOB data [message #72012]

Fri, 21 February 2003 18:51

Angela
Messages: 13
Registered: October 2000

Junior Member

Hi ALL,
Do you know if I can use SQL Loader to load the CLOB or BLOB type of data into a database and how to do that?

(I am using the Oracle9i.)

Thanks,

Angela

Report message to a moderator

Re: Use SQL Loader to load CLOB/BLOB data [message #72014 is a reply to message #72012]

Sun, 23 February 2003 14:31

someone
Messages: 7
Registered: November 2002

Junior Member

have a look at the Oracle Documentation and you will find it out

http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96652/ch06.htm#1006715

Report message to a moderator

Re: Use SQL Loader to load CLOB/BLOB data [message #120818 is a reply to message #72014]

Mon, 23 May 2005 23:14

kokichi34
Messages: 6
Registered: May 2005

Junior Member

Sorry, but I can follow that link above.
Pls check it and send again.
Thanks.

Report message to a moderator

Re: Use SQL Loader to load CLOB/BLOB data [message #120893 is a reply to message #120818]

Tue, 24 May 2005 09:18

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Sorry, but I can follow that link above.
believe, you meant I CAN'T.
The link works, it needs free registration. Pick your version, look for utilities manual.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/toc.htm

Report message to a moderator

Re: Use SQL Loader to load CLOB/BLOB data [message #121099 is a reply to message #72012]

Thu, 26 May 2005 01:28

nabeelkhan
Messages: 73
Registered: May 2005
Location: Kuwait

Member

You can use SQL*Loader to bulk load objects, collections, and LOBs. It is assumed that you are familiar with the concept of objects and with Oracle's implementation of object support as described in Oracle9i Database Concepts and in the Oracle9i Database Administrator's Guide.

9r2 release of SQL*Loader supports loading of four LOB types:

BLOB: a LOB containing unstructured binary data
CLOB: a LOB containing character data
NCLOB: a LOB containing characters in a database national character set
BFILE: a BLOB stored outside of the database tablespaces in a server-side operating system file
LOBs can be column datatypes, and with the exception of the NCLOB, they can be an object's attribute datatypes. LOBs can have an actual value, they can be null, or they can be "empty."

Cheers,
NK

Report message to a moderator

Previous Topic:	Transfer data between Oracle and Access 2000 using VB 6
Next Topic:	Problem with Import in Oracle 8i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 05:56:54 CDT 2024