Re: Moving all the object from one schema to another In ORACLE

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Mon, 15 Nov 1999 15:10:21 GMT
Message-ID: <3830225D.33F8D6ED@edcmail.cr.usgs.gov>

You can do this using just SQL commands by querying the data dictionary for all of FirstUser's tables, views, indexes, constraints, synonyms, links, etc. But it is so much easier to use exp/imp. Why not use that?

HTH,
Brian

lbarik_at_my-deja.com wrote:
>
> I have several object created under a user name called 'FirstUser', Now
> I want it move all the object to another user called 'SecondUser',
> Basicaly I want to drop 'FirstUser' after all the objects has been
> transfred to 'SecondUser'.
> I know, I can transfer the whole schema user 'FirstUser'
> to 'SeocndUser' using export/import, But I would like accomplish this
> using SQL/PL*SQL
>
> Thanks
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Nov 15 1999 - 09:10:21 CST