Re: End if file communication channel...!!

prab.athilat_at_fmr.com wrote:
>
> As Tim wrote, I had a similar problem a few months back which was still
> not resolved. In my case I was importing the db dump into our dev.
> server (Sun Sparc 20, 64 M , 8 Gig) running Oracle7.1.4. Half way thru .
> the import stopped with the above message & error. I finally tracked
> down the prob. at an index creation script. I tried to create this index
> from Sqlplus & Oracle logged me out with the above error. The same
> script worked fine on a diff. DB on the same server. Maybe there is
> unresloved bug somewhere...
> Prab Athilat
> prab.athilat_at_fmr.com

Prab,

This is a known bug. Oracle has the bug number and it occurs when trying to create a large index or sort/group and large amount of data. On v7.1.6 there is a patch that kind of fixes the problem. I don't have my notes with me now but if you still have the problem and can't get help e-mail me and I will send you the bug number. BTW- it is on Solaris.

Marc

-- 
||----------------------------------------------------------------------||
|| Marc Marchioli
|| The DataBase Group, Inc.                       voice:  214-528-9459
|| 4011 Travis St.                                fax:    214-528-9459
|| Dallas, TX 75204-7512
|| marcm_at_computek.net                         @
|| (Challenging ORACLE and UNIX every day)    |-}ORACLE,UNIX
||                                            /\-------------->