logs archiveIRC Archive / Freenode / #oracle / 2015 / August / 17 / 1
Apex is on topic?
I wish to export some ~1kk records to a CSV (or anything really, that I can pull out later). I'm trying that "unload to text" but it takes AGES. other smaller tables worked, at a rate like, dunno, 50 records per sec. but this one I can't wait that much. Another thing I found somewhere else would only allow up to 100k records. does anyone have a hint of how to export this data like a normal system which can write a million lines in some minutes?
(I have like 5 bhours of experience with this Apex, I just wanna suck their data into another system)
realtime, use sqlplus to dump the records.
then load it through sqlldr
you can also create a dblink if it is from db to db