Storage parameters for temporary segments - Default storage parameters set for associated tablespace

Q.  The storage parameters for temporary segments always use the default storage parameters set for the associated tablespace.
- Published on 27 Jul 15

a. True
b. False

ANSWER: True
 

    Discussion

  • Nirja Shah   -Posted on 28 Sep 15
    - Starting with default values, the storage parameters in effect for a database object at a given time are determined by the following, listed in order of precedence (where higher numbers take precedence over lower numbers):

    - Oracle Database default values

    - DEFAULT STORAGE clause of CREATE TABLESPACE statement

    - DEFAULT STORAGE clause of ALTER TABLESPACE statement

    - STORAGE clause of CREATE [TABLE | CLUSTER | MATERIALIZED VIEW | MATERIALIZED VIEW LOG | INDEX] statement

    - STORAGE clause of ALTER [TABLE | CLUSTER | MATERIALIZED VIEW | MATERIALIZED VIEW LOG | INDEX] statement

    - Any storage parameter specified at the object level overrides the corresponding option set at the tablespace level.

    - When storage parameters are not explicitly set at the object level, they default to those at the tablespace level.

    - When storage parameters are not set at the tablespace level, Oracle Database system defaults apply.

    - If storage parameters are altered, the new options apply only to the extents not yet allocated.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)