Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 9i RAC, Win 2K, and Raw Devices
Hi,
i don´t know what happens if the datafile runs out off space in the partition autoextending. (:)) (this advice is my own opinion so i may be wrong).
I´m running 817 OPS. I´ve configured my datafiles
with no autoextends, maxextends unlimited,
dictionary based tablespaces
to have more control over the database.
unfortunatly i´m not a guru so I´m doing
what makes sense for me.
regards
Stefan Kapitza
neil.boemio_at_gecapital.com (Neil Boemio) wrote in message news:<9dfce6cc.0202111421.12826164_at_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 Tue Feb 12 2002 - 05:25:08 CST