Difference B'een storage parameter tablespace and tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Difference B'een storage parameter tablespace and tables

  1. #1
    Join Date
    Feb 2002
    Posts
    36
    HI
    COuld you pl help me to answer me for the following question.
    Why we are setting following parameters in table creation(optional)?
    Next, Initial, Minextents, Maxextents and Pctincrese. Because the same parameter we are setting in Tablespace creation too,if any space difficiency for any tables in that tablespace, we can modify either Maxextents or Datafile size or others, Is that rigth. And then, at what situation we are modifying above parameters in table storage. Thank you

    Siva

  2. #2
    Join Date
    Apr 2001
    Posts
    107
    Tablespace storage parameters are the default storage for each object created into this tablespace without its own storage parameters.
    You can change a specific object parameter for different purposes:
    For exemple, if you know your table will be big, you can allocate initial and next extents bigger than tablespace defaults.
    At the object level, you can, let's say, set custom pctfree, pctused, etc... maybe one specific object will be used for different purposes than the other ones in the TBS (i.e intensive updates and inserts for ex.), you can also specify a maxextents different than the tablespace one, and so on...

    Hope it helps

    Cheers

    Fabien



  3. #3
    Join Date
    Feb 2002
    Posts
    36
    thanks Fabien

    Bye Siva

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width