Re: extend question

From: RP Data Solutions <rpdata_at_cyberus.ca>
Date: Wed, 20 Jan 1999 23:24:01 GMT
Message-ID: <36a663e8.938807193@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 - 17:24:01 CST