Re: change owner of objects

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.
>
> My Q:
> We have about 20GB of data in one schema and we want to move this
> data to another schema on the same db.
>
> Is there a quick way to change the owner of all these objects?
> (Quick way might be w/o exporting all data and importing into the new
> schema)
>
> E.g. To change the owner of those objects in the data dictionary. Or
> that not a good idea to do so (if not, why?).
>
> We running Oracle 9i V.9.2 on Windows platform.
>
> Any help much appreciated.
>
>
> TIA
> Fred
>
>

Thank you guys for your advise,

I think we will go the way to exp/imp the data. Cheers
Fred Received on Sat Dec 11 2004 - 06:26:54 CST