Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: rollback segment question
Set the commit=y option during the import this should limit the RBS
requirements
Dennis wrote in message <849bjg$949$1_at_news.seed.net.tw>...
>Dear all,
> A dump file which contains more than 1 GB data was imported into
the
>Oracle database. When it was imported, the error message asked me to
extend
>the rollback segment size. I did what it said. Everything is OK. But I
>just can't figure out why the Oracle server need more rollback segments
when
>I import a dump file (insert new data). Update needs rollback segments to
>store the old value, insert doesn't. Does anyone explain why? Thanks!
>
>Dennis
>
>
Received on Tue Dec 28 1999 - 10:36:22 CST
![]() |
![]() |