Re: 9i RAC, Win 2K, and Raw Devices

hello neil,

• a datafile equals 1 logical partition
• a tablespace consist of several datafiles so your tablespace consist eventualy of several log. partitions
• a partition canot expand but your "datafiles" can that means you can make your partitons greater as your datafiles (but not advisable)
• you have to add "datafiles" (partitons) to expand your tablespace

hth.

Stefan Kapitza

neil.boemio_at_gecapital.com (Neil Boemio) wrote in message news:<9dfce6cc.0202100038.f40265a_at_posting.google.com>...
> I'm new to raw devices so I need some clarification here regarding 9i
> RAC on Win 2K.
> Is it true that you can only have 1 file per logical partition on a
> raw device. Does this mean that a tablespace can only have one file?
> Or can a tablespace have a number of files on a number of different
> logical partitions?
>
> Also, when a datafile fills up a logical partition, can that partition
> be extended? Or, if the above is true, can another logical partition
> be created (assuming you have the space) and then add another datafile
> to the tablespace using the new partition?
>
> Is this generally how to deal with running out of space? Is there a
> different way?
>
> Thanks!
> Neil
Received on Sun Feb 10 2002 - 07:30:19 CST