Re: 2 Object Placement Questions...

On Thu, 17 Aug 2000 22:29:57 -0400, "Chris England" <chris.england_at_sidetalk.com> 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.

create new_table {storage parameters}
as select * from old_table;
drop old_table;
rename new_table to old_table;

Another way is to export the table, drop it, then create a new one in the target location with the same name and then import. This can help in bringing in the data as well as the grants, if that is an issue.

>
>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.
>

Create the new ones in the target location, then drop the existing ones.

alter database [add/drop] logfile will do it.

Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Fri Aug 18 2000 - 07:08:33 CDT