Extending data files automatically
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Extending data files automatically

Hybrid View

  1. #1
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    Hi Gurus,

    I have a drive A and a drive B.

    I have data files on A.
    When they get full, I want to auto extend the data files to drive B.

    How do I do this?

    Hemant

  2. #2
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    If your datafile is on Drive A, it cannot be extended on Drive B (since it does not exist on Drive B).

    You can create another datafile for the same tablespace on Drive B- and then it will work.

  3. #3
    Join Date
    Mar 2002
    Posts
    534
    Hi,

    If you have large tables and do a lot of full table scans I recommand you, for the same tablespace, to create two datafiles (one on each drive). The adavante of doing this is to spead the IO over several disks.

    The extents of tables created on this tablespace will automaticly be distributed over the 2 files.

    This will, of course, only be effective if your drives A and B are two phisycaly different disks.

    Mike

  4. #4
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    Thanks guys!
    Hemant

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