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 -> IMP, suggestion for extents ..(Need!!!)???

IMP, suggestion for extents ..(Need!!!)???

From: JK Yao <jkyf0131_at_hotmail.com>
Date: 30 Aug 2001 23:47:14 -0700
Message-ID: <93f65984.0108302247.4d0d849@posting.google.com> 





dear all, 



I had exported our database from Oracle7.3.4 with compress=Y and
imported to 8.1.6.



Some big tables, the extents are kind of huge.  For example, one of my
table have EXTENT INITIAL 200M and NEXT 200M, is that ok?  What should
I set my next and initial.  Small and big INITIAL or NEXT have any
effect?



Thanks a lot


regards,


JK
Received on Fri Aug 31 2001 - 01:47:14 CDT












Original text of this message













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