Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Spanning a Database over Multiple Partitions
hi all,
i am using oracle 9.2.0 and i need to create a very large database to
accomodate a large influx of data.
i have the following two partitions available on my oracle server:
(excerpt from df -h)
/dev/sda1 17G 33M 15G 1% /mnt/sda1 /dev/sdb1 17G 33M 15G 1% /mnt/sdb1
since i will be expecting a lot of data to be imported into this database, it will have to be very large, much larger than the 15GB free on each partition, therefore i was thinking of spanning it over the two partitions.
if this is at all possible, my questions are:
- how is this done? i understand that i would need to set the paths of
the database files to point to, let's say, partition /mnt/sda1, but
how would i set the size? i couldn't find any such options for
database size to set in the dbca.
- how do i make use of the second partition?
any help would be appreciated. Received on Fri Dec 13 2002 - 10:52:09 CST