Text Importer - reorganized the data

I was trying to import a large text file to a table.  The text file has more that 1 million lines.  The table has only 1 column to hold one line from the text file.  I made sure that the CLEAR TABLE is checked before I start the process.  Commit every 100.

Oracle has no 'CLEAR TABLE' command so you must be using some tool or GUI front-end you haven't told us about.

If you commit every 100 you will just slow things down so just issue a commit at the end of the data load.

When I checked the resulting table, I noticed that it reoganized the sequence of lines from the text file.

No - Oracle doesn't 'organize' or 'reorganize' the rows. It just dumps them into a table; there is NO first row or last row. Just like if you throw a bunch of tennis balls into a basket you won't know afterward which one was the first ball you threw in.

How can I import from the text file onto a table without reorganizing the data.  I really need the data on this table to be in the same line sequence as the text file.  I also tried commit every 1 record.

Just use my 'tennis ball' example from above. If you want the balls to have an order you need to write a number on each one as you throw it into the basket. Then later you can find ball #1, #37 or sort the balls in order if you want.

For your use case that means add a second column to the table (e.g. LINE_NO) and use an Oracle sequence to 'number' them.