Re: Moving All object from one schema to another schema in Oracle

From: Gerd Kock <info_at_gerd-kock.de>
Date: Fri, 12 Nov 1999 22:30:40 GMT
Message-ID: <382c9433.24306318@news.btx.dtag.de>

I think you have to read the data dictionary views (user_tables, user_views, user_sequences, user_... and so on) and create the DDL-statements and perform them using dynamic pl/sql. look at the package DBMS_SQL.

Gerd
On Fri, 12 Nov 1999 17:51:29 GMT, lbarik_at_pacbell.mobile.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
>(Both users are in the same instance/database)
>
>Thanks
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Nov 12 1999 - 16:30:40 CST