i am sorry ,i think we got carried away,the data is in a Single text file i don have to work with with multiple text files,data from some data base is posted intoa text file,i want that data to be moved to oracle table,
in th ebaopve solution u were talking abouit clobs and nclobs i was bit confused,
plese help me out,
thanks in advance,