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

Home -> Community -> Mailing Lists -> Oracle-L -> Change Schema OWNER of ALL Objects in 10gR2 ?

Change Schema OWNER of ALL Objects in 10gR2 ?

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Mon, 14 May 2007 13:46:55 +0530
Message-ID: <BBD944BCAC3AB4499DFBAFB1D8AF30200303968B@BLRKECMSG11.ad.infosys.com>

Folks  

How can the Schema OWNER of ALL Objects Owned by (say) OWNER1 be Changed to OWNER2 in 10gR2?

NOTE - OWNER2 does NOT exist in the Database.

NOTE - Other / multiple schemas & respective Objects should remain unaffected.

NOTE - Database is a Testing Database. Hence Downtime is NOT an issue.  

Qs Is Export , Import the the only way using 1 of the following?  

exp - OWNER=OWNER1 / imp - FROMUSER=OWNER1, TOUSER=OWNER2 ,

expdp - SCHEMAS=OWNER1 / impdp - REMAP_SCHEMA=OWNER1:OWNER2  

Cheers  

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 14 2007 - 03:16:55 CDT

Original text of this message

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