This content has been marked as final. Show 3 replies
The solution is sqlloader or external tables. So you can have a look at the documentation about these for solutions: http://docs.oracle.com/cd/E11882_01/server.112/e22490/toc.htm and then chapters 7 and higher.
Herald ten Dam
if it is one time you can do manually...
drop TABLE test
CREATE TABLE test
ORGANIZATION external (TYPE oracle_loader DEFAULT DIRECTORY AD_DATA_EXT
(RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY '--'
MISSING FIELD VALUES ARE NULL)
LOCATION ('test.txt')) REJECT LIMIT UNLIMITED;