Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2012
    Posts
    133

    Unanswered: partitioning table on default segment

    hi guys,
    is it ok to create table partitions on default segment ?

    alter table table1 partition 4


    TIA

  2. #2
    Join Date
    Feb 2015
    Posts
    24
    Why do you want to do that ?

  3. #3
    Join Date
    Feb 2012
    Posts
    133
    to balance i/o performance on particular table. this will be on selected tables only those tables with heavy insert, select process. on production we don't bind objects to its own segment but rather used the default segment.

Posting Permissions

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