Re: 2 Object Placement Questions...

From: Gocha Mchedlishvili <gocham_at_ixpres.com>
Date: Thu, 17 Aug 2000 21:22:07 -0700
Message-ID: <399c9101_5@isp.uncensored-news.com>

In 8i you can do
ALTER TABLE ... MOVE ... Gocha

"Chris England" <chris.england_at_sidetalk.com> wrote in message news:spntjnmir5j177_at_corp.supernews.com...
> 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!
>
>
>
>

---

Posted Via Uncensored-News.Com - Still Only $9.95 - http://www.uncensored-news.com  With Servers In California, Texas And Virginia - The Worlds Uncensored News Source    Received on Thu Aug 17 2000 - 23:22:07 CDT