Well, I forgot to mark that this is not the unix limitation, since my
configuration allow to exceed this limit (in ksh scripts, C programs etc.)
Frank van Bortel <f.van.bortel_at_vnl.nl> wrote in message
news:380B9650.873E6D9B_at_vnl.nl...
> Malka Friedman wrote:
>
> > Hi All,
> >
> > I am trying to spool a select statement to a file, But when the file
size
> > get to 2.147 GB the select stops - file size is limit...
> > Is there any way to enlarge this limit? the table is very big and I must
> > have it in a Ascii file format.
> >
> > Thanks
> > Malka
>
> Sounds like some unix box; check ulimit settings!
> BTW there are some utilities that cannot break the 2 GB limit
> (AFAIK, import/export and sqlload. Don't know about Plus or svrmgrl)
>
>
> --
> Met vriendelijke groet/kind regards,
>
> Frank van Bortel
> Technical consultant Oracle
>
> Work: Home:
> ---------------------------------- ----------------------------
> Inter Access V&L Hunzestraat 4
> Palatijn 3, 7521 PN Enschede 7555 WB Hengelo
> PoBox 545, 7500 AM Enschede (31)074-2425046
> 053-4341500
>
>
Received on Tue Oct 19 1999 - 00:50:18 CDT
