Re: Change Schema OWNER of ALL Objects in 10gR2 ?

  • From: "John Darrah" <darrah.john@xxxxxxxxx>
  • To: VIVEK_SHARMA@xxxxxxxxxxx
  • Date: Tue, 15 May 2007 15:38:51 -0600

transport tablespace fromuser touser might work

create user owner2;
alter all tablespaces with objects owned by owner1 to read only status;
exp transport_tablespace=y tablespaces= the tablespaces w/ objects owned by
owner1
drop tablespaces
imp transport_tablespace = y  fromuser=owner1 touser=owner2

I'm not sure if this will work in your specific situation by its worth a
look.

On 5/14/07, VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx> wrote:


 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


  **************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this e-mail
or its contents to any other person and any such actions are unlawful. This
e-mail may contain viruses. Infosys has taken every reasonable precaution to
minimize this risk, but is not liable for any damage you may sustain as a
result of any virus in this e-mail. You should carry out your own virus
checks before opening the e-mail or attachment. Infosys reserves the right
to monitor and review the content of all messages sent to or from this
e-mail address. Messages sent to or from this e-mail address may be stored
on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2007