Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2008

    Post Unanswered: datafile extension

    hi all,
    we have oracle 10g datase on aix 5.3 operating system and are using ASM storage system.
    the users tablespace is running out of space and its not autoextensible.
    i want to extend the datafile but when i select the filename from dba_data_files so that i can get the path for the location of the datafile on the operating system i only get the path on the disks but for me to be able to extend the datafile i need to know the path on the operating system. i don't seem to be getting the path and i guess it has something to do with the mapping. i need to find the file to device mapping so that i can extend the users tablespace. you can also help me with some advice on the best way to go about extending the tablespace because it looks like its not as straight forward as when you are not using ASM storage
    thank you.

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL


    ASM files do not have path to operating system if using "raw" devices.

    But you can still extend the ASM file with the 'ALTER' command as with any other file.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    asmcmd lsdg
    Lists all disk groups & their attributes
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Mar 2008
    thanks, i managed to extend, i think i was making a mistake sumwhere.

Posting Permissions

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