Re: 'Desc' causes segmentation fault + core dump every time!

In article <3A643664.2C3F_at_yahoo.com>,
  connor_mcdonald_at_yahoo.com wrote:
> David Fitzjarrell wrote:
> >
> > In our last grippin episode "jazz" <J_Le_bru_at_excite.co.uk> wrote:
> > > I don't know if anyone can point me in the right direction but
 every
 time I
> > > issue a 'desc' statement on data dictionary tables it causes
 oracle
 to dump
> > > core saying theres been a segmentation fault
> > >
> > > I'm running Oracle 8.1.5.0.2 on Red Hat Linux 6.2 on standard
 Athlon
 PC.
> > > Commands issued through SQL-plus
> > >
> > > Everything else seems to be working OK - but I haven't got a clue
 whats
> > > going on here (cant find anything relevant at oracle technet)
> > >
> > > Any ideas about what might be happening would be greatly
 appreciated~! (or a
> > > rough area to look at - not even sure what a segmentation fault is
 really)
> > >
> > > thanks
> > >
> > >
> >
> > There is a bug in 8.1.5, I believe, that will dump core on a
 describe
> > if the linesize is longer than 80.
> >
> > --
> > David Fitzjarrell
> > Oracle Certified DBA
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
> I think its 120 ... not sure
>
> I've seen a lot of Oracle scripts lately that are putting
>
> "set lines 119" in the header
>
> HTH
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at
> http://www.oradba.freeserve.co.uk)
>
> "Some days you're the pigeon, some days you're the statue"
>

Depending upon the platform, I would surmise. I have experienced this problem when the linesize was set to 90 or longer on Linux, yet I've read of this not happening until the linesize was 120 or greater on other platforms. Once I set the linesize to 80 all was right with the world.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/