Re: change owner of objects

"dbyy" <noname_at_fooled.com> wrote in message 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
>

Read about transportable tablespaces. This might help you. You just export the metadata and import the metadata back with fromuser = and touser= . I hope the objects for the schema are in separate tablespaces away from other schema objects. Received on Thu Dec 09 2004 - 21:05:03 CST