Re: change owner of objects

From: Denis Do <nospam.denisdo_at_yahoo.com>
Date: Fri, 10 Dec 2004 03:26:32 GMT
Message-ID: <slrncri5t8.3jk.nospam.denisdo@denisdo.news.google.com>

On 2004-12-10, dbyy <noname_at_fooled.com> wrote:
> dbyy <noname_at_fooled.com> wrote in
> news:Xns95BAC31AFB91Ddbyyatcanadadotcomni_at_207.35.177.134:
>
>> hi everyone,
>>
>> I'm not sure whether this is the right NG for my questions.
>> If not, please let me know which NG would be the better one.
>>
> be either exp/imp or create table from.....

... and both of them will give you huge IO load ... If it is production env - I would use synonyms (in fact, I always do) If it is development - use direct export , not CTAS

Cheers! Received on Thu Dec 09 2004 - 21:26:32 CST