Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: change owner of objects

Re: change owner of objects

From: Oradba Linux <techiey2k3_at_comcast.net>
Date: Fri, 10 Dec 2004 03:05:03 GMT
Message-ID: <zn8ud.168210$5K2.63085@attbi_s03>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US