Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: extend question
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
![]() |
![]() |