What kind of activity is there when this error surfaces? Is it a single
INSERT INTO a SELECT * FROM view? Or is it a PL/SQL loop over
a SELECT * FROM view cursor, with inserts and commits inside the
loop?
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"krishna" <s_venkatakrishna_at_hotmail.com> wrote in message
news:8cdd702b.0302210050.6bc02abd_at_posting.google.com...
> Guys,
>
> I am getting the above when I am importing from
> a view. I have a .sql file running through unix shell script.
>
> I Understand that I have to increase the ROLLBACK Segment size.
> Where should I do this / run this from ? In my script? or has to be
> done at DBA level?
>
> Please help me.
>
> Cheers,
> krish
Received on Fri Feb 21 2003 - 08:07:30 CST
