sql - Load data from excel file into a temporary table -

i needed load 100,000 rows of data excel file temporary table created using "on commit preserve rows". somehow efficient methods did not seem populate temporary table due session issues?

i used toad import table data , showed x amount of records imported. when select temp table, empty. generated bunch of insert scripts , saved them in notepad.sql , called toad editor using @/script/location/notepad.sql , hit f5. ran , showed how many records inserted. again temp table somehow still empty. so, decided run random insert script manually in editor , showed in temp table. believe methods didn't work not considered same session?

i haven't try sqlldr assuming not work judging methods tried. can confirm? can't access sqlldr won't know.

is there anyway work? can't run insert scripts manually. time consuming , toad can't take many scripts @ same time.

oracle temp tables created on commit preserve rows session-specific, data put them visible within single session, , duration of session. toad may creating separate session each window , data populated 1 window/session isn't visible window/session. fact can run insert script , select data suggests may case if both operations done same window. expect you'd see same behavior if used sql*loader load tables because load run in 1 session , data discarded when session terminated. best of luck.