October 30th, 2003, 07:30 AM
importing into oracle table from '|' delimited file
We have our database running in INTEGRA4 (RDBMS) , and we want to migrate to Oracle, and as such we have to import data to oracle.
INTEGRA4 supports SELECT FROM Table INTO file .. delimited by ‘|’ command to get an Ascii dump of the table, and this is the only way I can export data in INTEGRA4.
My problem is to import this ‘|’ delimited ASCII file in ORALCE table . Can someone help ? .. which is the best way to import such a file in an oracle table ? (I have 200 tables in my schema)
October 30th, 2003, 08:03 AM
Use SQLLoader, see this for reference, there is also a nice O'Reilly book
Last edited by pabloj; October 30th, 2003 at 08:06 AM.
November 21st, 2003, 02:21 AM
Thank you pabloj .. i solved my problem .. your reference link was very informative .. thanks .