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?

• how do i make sure the fullest amount of the free space of these partitions is used for the database?
• would setting only the paths of the control, redo and data files suffice or must i change the parameters, trace files and archive log files paths to these partitions as well?

any help would be appreciated. Received on Fri Dec 13 2002 - 10:52:09 CST