O'Reilly logo

Oracle Data Integrator 11g Cookbook by Peter C. Boyd-Bowman, Denis Gray, Christophe Dupupet, Julien Testut

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Loading a file containing a LOB

Loading large objects always requires special considerations. Here, we will create a multi-technology IKM (that is, an IKM that connects to a remote source data server) that loads CLOBs and BLOBs using an external table definition.

Getting ready

For this recipe, we will need to create three files on disk:

  • CLOB.TXT: use notepad and write This is a CLOB in this file. Save it on disk in your c:\temp directory.
  • BLOB.DOC: use a word processor program and create this file. Write this is a BLOB in the file and save it in your c:\temp directory.
  • Use notepad and create the file DATA.TXT with the following record:
    "Sample record with CLOB and BLOB", "CLOB.TXT", "BLOB.DOC"
  • Save this file in your c:\temp directory.
  • Create a table to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required