DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 22 of 22

Thread: 7.3.4 - best way to 'mass extract' data?

  1. #21
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by slimdave
    Joke!
    ?
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  2. #22
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by tamilselvan
    Neither PL/SQL proc nor COPY command will work correctly when long column has more than 32K bytes data, b/c the copy command works as the same way of pl/sql.
    Not true. COPY command has no limitation in data size of a long column at all and works totaly different as PL/SQL.

    You can set SQL*PLus's parameter LONG to anything up to 2GB. And the setting of LONG parameter is the amount of single LONG value that COPY will deal with - the rest will be truncated. And AFAIK the maximum size of LONG can't be larger than 2GB, so tere is no actual limitation at all with COPY regarding LONGs.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width