Here's a place to start. Not sure if SQL Loader supports CLOBs for importing. http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14249/toc.htm -- Anthony Baratta Necessity is the plea for every infringement of human freedom. It is the argument of tyrants; it is the creed of slaves. -- William Pitt 18 Nov 1783