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 -> rollback segment question

rollback segment question

From: Dennis <echome_at_ms16.hinet.net>
Date: 28 Dec 1999 03:42:40 GMT
Message-ID: <849bjg$949$1@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 Mon Dec 27 1999 - 21:42:40 CST












Original text of this message













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