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

From: Neil Boemio <neil.boemio_at_gecapital.com>
Date: 11 Feb 2002 14:21:41 -0800
Message-ID: <9dfce6cc.0202111421.12826164@posting.google.com>

Stefan, yes this helps! Thanks!

Question: why is it not advisable to make the partitions larger than the datafile to allow for growth (i.e, autoextend)?

---

skapitza_at_volcanomail.com (s.kapitza) wrote in message news:<26703915.0202100530.56dcb8aa_at_posting.google.com>...
> 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 Mon Feb 11 2002 - 16:21:41 CST