Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: rollback segment question

Re: rollback segment question

From: Jim Brennan <synergz_at_yahoo.com>
Date: Tue, 28 Dec 1999 11:36:22 -0500
Message-ID: <kD5a4.915$X2.24298@nnrp1.uunet.ca>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US