Re: 2 Object Placement Questions...

In answer to 2! sorry for not mentioning in my last post:

You have to take the redo log offline making sure its not the current log from v$logs, then drop the redo log (s) in that group and then alter database add logfile group.. where the file spec is in the new location!!

and add members to that group.

Hope that helps

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:27:45 CDT