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

I think I found the answer already (here and on AskTom) the only way will be either exp/imp or create table from.....

I just want to make sure I don't miss any other opportunity.

TIA
Fred Received on Thu Dec 09 2004 - 21:08:14 CST