Hi, i'm using spool for exporting 6 millions records, is query executes once or till end of last record

Question

A view returns 6 millions records. Earlier i used to export with sql developer(right click and export, it takes more than 2hr), but my senior said that, if do like this query will get executes every 500 rows. so we are getting warnings from DBA(long running queries).

when searching internet i found that spooling works better for exporting. So i have doubt,In spooling is query executes once & start exporting or it executes for till last row exporting.

I mean query executes once and start exporting or it cont to execute till last record — Ajit Pattar, Aug 10 '17 at 04:23
please edit and update the question with correct sentence and bit of more details — Amit Phaltankar, Aug 10 '17 at 04:25
your question is hard to understand. did you already use sql developer successfully to export the 6 millions rows? — miracle173, Aug 11 '17 at 05:04
we need to export every week. and Sql developer is taking more than 3hrs to export, so we need to optimize the time — Ajit Pattar, Aug 12 '17 at 03:41

score 1 · Answer 1 · answered Aug 10 '17 at 04:29

1

it is executed once, create a cursor which is the image of your query at the time of the execution, and then start fetching your data in your spool. If you make any update after the execution, it will not appear in your spool.

answered Aug 10 '17 at 04:29

Steven

14,048
6
38
73

Hi, i'm using spool for exporting 6 millions records, is query executes once or till end of last record

1 Answers1