Subject: Re: How to set default initial extent when creating new table
Newsgroups: comp.databases.oracle.server
References: <5u50dq$3te$1@news.minn.net>
Organization: InterAccess, Co. - Chicagoland's Full Service Internet Provider
Reply-To: akaplan@interaccess.com
Distribution: 

dtang@minn.net wrote:
: Hi:
: I  get a probelm about Oracle V8 on NT. When Oracle creates new table
: , if initial size of extent is not specified, ORACLE sets initial
: exetent to  1M. It will waste a lot space for a small temporary table.
: But the intance's  db_block_size = 8k. How to set default initial size
: of extent.
: 
: Please e-mail me at dtang@minn.net
Dong,

What you need to do is alter the DEFAULT storage parameters for the tablespace that
the table is created. If you do not specify storage clauses when a table is created,
Oracle looks at the defaults for the tablespace. You can type something similar to:

ALTER TABLESPACE USER_DATA DEFAULT STORAGE (INITIAL 10K NEXT 5K);

Good luck,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 105+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page ack to Ari Kaplan's Home Page