Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004

    Unanswered: creating new tablespace in raw device - oracle RAC - sun cluster

    Hi Gurus.

    Please I want to know how to create a tablespace in raw device.

    I am using:

    - Oracle RAC

    - Veritas Volume Manger and Cluster Volume Manager

    - Sun Cluster

    Is necessary to link the raw device?

    I created one tablespace but after the reboot was gone.

    Is necessary to update a file?

    Please help.

  2. #2
    Join Date
    Dec 2004
    Apeldoorn, the Netherlands
    What statement did you use to create the tablespace?
    What tool did you use; SQL*Plus, Oracle enterprise Manager, something else?

    Give us some more information please.

  3. #3
    Join Date
    Jul 2003
    have unix create the raw file
    ie: /dev/vx/rdsk/sid/tablespace1.dbf <-- 1Gig

    once raw file is created then create your tablespace:
    create tablespace tablespace1
    datafile '/dev/vx/rdsk/sid/tablespace1.dbf' size 1000M
    extent management local uniform size 128k
    segment space management auto;

    I think there is a 1M overhead with raw devices so create your raw file sizes
    with an extra Meg of space.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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