DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Hybrid View

  1. #1
    Join Date
    Aug 2004

    Tablespaces in partition table

    Hi All,

    Could you guys suggest me what is the better approach to use tablespaces in partition table?

    I have very huge data and partitioned by range weekly. Here question is: Shall we use separate tablespace for each partition or we can use same tablespace for multiple partitions?

    Please give some points advantages and disadvantages in each case.

  2. #2
    Join Date
    Sep 2002
    it reallyt doesnt matter, just spread your IO out

  3. #3
    Join Date
    Apr 2006
    It's more a case of personal tast, ease of management etc. As Davey says a primary aim of yours should be to provide maximum IO bandwidth for the way your application accesses the data. We can't answer that as we don't know your application, or your disk setup.

    I've worked at places where each partition has it's own tablespace and it's fine but you need to know what you're trying to achieve by either method.

    Personally I prefer them to be separate, I feel like I have more flexibility, but other people think there's too many tablespaces to manage in a large, highly partitioned db.

  4. #4
    Join Date
    Nov 2006
    One good point is that if you keep all the data for a specific week or set of weeks in separate tablespace, you can in some point in time make the TS read only, when data will not change anymore and hence make the backup easyer and faster ( since you backup the read only tablespaces only once)
    Later you could put the TS on read only media, and even plug it out of the database and plug it back in when needed ( that's possible since 9i and there is special feature for that in 10g)
    So to summarize, this will allow you to know where physically the data for specific period resides and hence drop/move/archive/backup easyer
    Of cource that maight be not relevant at all in your case

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.