Extending data files automatically

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?

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.

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

Thanks guys!