Re: Tables per Tablespace

Depending on key/data structure, you can also control allocation by partitioning the table, with the partitions on different disks either in the same tablespace or different tablespaces. It primarily means paying attention to the table extents, how full the tablespace is when the files are allocated, etc.

I suggest that instead of thinking of a tablespace per application, you consider a group of tablespaces for the application (isolating indexes from data at least).

In article <90r464$n7j$1_at_news.gte.com>,
  "Kevin Brand" <kevin.brandx_at_tel.gte.com> wrote:
>
> Yes, you can...
>
> alter table <table_name> allocate extent
> ( datafile '/dev/rlvrawdev1' size 10M );
>
> where the datafile clause can contain cooked or raw file name.
>
> I've used this method in situations where I wanted to manually spread
 a
> large object around.
>
> -Kevin
> "Ezr Vinh" <d_a_p_at_my-deja.com> wrote in message
> news:90qmip$cs2$1_at_nnrp1.deja.com...
> > In article <nLWX5.21247$0r2.708971_at_bgtnsc07-
 news.ops.worldnet.att.net>,
> > "Buck Turgidson" <jc_buck_at_YAH00.com> wrote:
> > > Tablespaces can have multiple data files, but can you specify into
> > which file to place a table?????????
> >
> > No, you can't (at least I've never heard of any way to specify a
> > specific file in a tablespace; one must be careful when making
 absolute
> > statements about anything Oracle!)
> >
> > This is why you really need to segregate objects at the tablespace
> > level for I/O considerations.
> >
> > -Dave
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.


Sent via Deja.com http://www.deja.com/
Before you buy.