Re: Spanning a Database over Multiple Partitions

"B. Kloppt" wrote:

> 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.

From the questions you are asking it appears that you have not studied Oracle architecture and are not the DBA. So why has this been assigned to you?

Anyway, go to http://tahiti.oracle.com and search for: "TABLESPACE" and "DATAFILE" You will likely need to create or or more tablespaces; each with multiple datafiles.

Daniel Morgan Received on Fri Dec 13 2002 - 17:20:43 CST