Forum Post: Re: Copying A Large File > 3 Gb From Appserver To Client

  • Thread starter Thread starter Frank Meulblok
  • Start date Start date
Status
Not open for further replies.
F

Frank Meulblok

Guest
[quote user="dana"]The copy-lob sounds really simply, but it would seem that if the file was 10 GB then I would need to make sure there was enough RAM on the system to efficiently handle that .[/quote] Worth looking into some of the less commonly used options of the COPY-LOB in that case: 1. COPY-LOB FROM ... STARTING AT FOR can be used to chunk the data on the server side. (Where chunk size can be much larger than the 30k the RAW type allows) 2. COPY-LOB TO FILE ... APPEND can be used on the client side to glue things back together.

Continue reading...
 
Status
Not open for further replies.
Back
Top