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
