Re: Tables per Tablespace

From: Kevin Brand <kevin.brandx_at_tel.gte.com>
Date: Fri, 8 Dec 2000 11:03:06 -0600
Message-ID: <90r464$n7j$1@news.gte.com>

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.
Received on Fri Dec 08 2000 - 11:03:06 CST