Extend Tablespace on raw devices
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Extend Tablespace on raw devices

  1. #1
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630

    Extend Tablespace on raw devices

    Hi People,

    Can someone answer the following
    Suppose I have a tablespace on raw device and it gets full. If we assume that I can extend the raw device at OS level, can I extend the tablespace as well?

    Thanks
    Boris

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    Quote Originally Posted by Bore
    Hi People,

    Can someone answer the following
    Suppose I have a tablespace on raw device and it gets full. If we assume that I can extend the raw device at OS level, can I extend the tablespace as well?

    Thanks
    Boris
    I don't think that you can grow a raw partition, although I'm not sure, but you could always create a new raw device and add a datafile for that device. If you have a test system try both ways.
    this space intentionally left blank

  3. #3
    Join Date
    Jun 2006
    Posts
    259
    Yes,
    If your raw device will allow you to extend the device then simply grow the datafile.

    I know that HPUX/ veritas and several others will allow this.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you can if you manage your RAW volumes with Volume Manager, i.e each RAW Device is a Logical Volume

  5. #5
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Thanks guys
    That was quite important

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