change owner of objects

From: dbyy <noname_at_fooled.com>
Date: Fri, 10 Dec 2004 00:10:27 GMT
Message-ID: <Xns95BAC31AFB91Ddbyyatcanadadotcomni@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 Received on Thu Dec 09 2004 - 18:10:27 CST