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 -> Next extent with Locally managed tablespace on 9i

Next extent with Locally managed tablespace on 9i

From: Christian M. <cm_at_sdv.fr>
Date: Fri, 2 Aug 2002 10:10:29 +0200
Message-ID: <3d4a3e21$0$213$4d4eb98e@read.news.fr.uu.net> 





Hi,



I want to migrate on 9i.


Before I was using DMT but now the default tablespace is LMT.
Then, I have created my new database with LMT and I have Imported data.



The problem is that IMP create my tables with an INITIAL parameter equal as
the size of the table.


Or with LMT, INITIAL = NEXT !



So if  I have a table created by the import utility with an Initial extent
of 64M,  is the value of the next extent : 64 M ? If then, how can i change
this value ?



Thanks in advance.



Christian.
Received on Fri Aug 02 2002 - 03:10:29 CDT












Original text of this message













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