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: extend question

Re: extend question

From: Pat Minnis <pminnis_at_maverick.net>
Date: Wed, 20 Jan 1999 19:52:13 -0600
Message-ID: <bOvp2.433$4a1.2773181@news.goodnet.com>


Also, the datafile autoextend doesn't come into play unless the objects in the tablespace composed of its datafiles exceeds the combined size of those datafiles.

RP Data Solutions wrote in message <36a663e8.938807193_at_news.cyberus.ca>...
>Steve:
>
>Tablespaces have default storage parameters, datafiles do not. A table
>created without storage parameters will take the defaults from the
>tablespace... If storage parameters are defined in the create table
>statement these over-ride the tablespace storage parameters...
>
>Hope this helps...
>
>Robert Prendin
>
>steve_young_at_my-dejanews.com wrote:
>
>>Hi, there. I am getting confused about the extend usage. I realized that
I
>>can set the extend parameter in TABLESPACE, DATAFILE(within the
tablespace)
>>and OBJECT(within the tablespace) itself. My question is: when a
particular
>>object(says, a table) is extending, does it use the extend parameter
within
>>the object or datafile or tablespace?? If it uses the parameter within the
>>object, why do we need to set the parameters for datafile or tablespace?
>>
>>Thanks!!
>>
>>Steve
>>
>>-----------== Posted via Deja News, The Discussion Network ==----------
>>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>Robert Prendin
>RP Data Solutions Inc.
>Specializing in ORACLE DBA Support Services
>
>
>
Received on Wed Jan 20 1999 - 19:52:13 CST

Original text of this message

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