Re: Change Schema OWNER of ALL Objects in 10gR2 ?
- From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- To: VIVEK_SHARMA@xxxxxxxxxxx
- Date: Mon, 14 May 2007 21:22:28 +1100
If all and only OWNER1 data resides in one tablespace - you can use
transportable tablespace feature to move all data in virtually no time.
You would use datapump in metadata_only mode to move all non-table objects
(function, procedure, packages, etc.) with the remap_schema parameter.
Same with tablespace(-s) - export then drop tablespace and then import it
back with the remap_schema parameter.
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***
--
Alexander Fatkulin
Other related posts:
