Re: 2 Object Placement Questions...

Chris,

You could do a:

create table tab2
tablespace tabspace
storage ( initial 8K next 8K pctincrease 0 ) as
select * from tab1;

where tab1 is in the initial tablespace and tab2 is now in tabspace. Then you could:

alter table tab2 rename to tab1;

This is another method of reorganizing a table with different storage parameters!

Nevin Hahn
Evoke Communications
nhahn_at_evoke.com

Chris England wrote:

> 1. Can you move tables/objects from one tablespace to another? (Not
> referring to selecting the data out of the existing table, dropping the
> table, recreating it on another tablespace, then sqlloading it) I'd like to
> be able to do this using SQL if possible.
>
> 2. Can you/how do you move redo logs. I would like to move the redo logs
> from their current locations in order to reduce possible i/o contention.
>
> Thanks!
Received on Thu Aug 17 2000 - 14:17:48 CDT