add datafile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: add datafile

  1. #1
    Join Date
    Aug 2000
    Posts
    163

    Cool

    Hellod fellows DBA's
    I need to add another datafile to one of my index tablespaces.
    Please let me know if I'll be better off adding it to the same OS disk or putting it on another disk.
    I am concern about performance problems.
    Thank you.

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Thumbs up


    as long as the current Index datafile is on a different disk, you should be okay to put another datafile on thgat disk.

    - Magnus

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    As magnus suggested, you would be better off by putting the datafile for the index tablespace, in a different place from that of the archive log/ data (i.e table data) tablespace/logfile table space.

    Hope this would help you.
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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