RE: Change Schema OWNER of ALL Objects in 10gR2 ? ... SOLVED
- From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
- To: VIVEK_SHARMA@xxxxxxxxxxx, "John Darrah" <darrah.john@xxxxxxxxx>
- Date: Thu, 17 May 2007 07:54:03 -0500
You could also have done it this way, no expdp step required:
impdp username/pwd schemas=SCHEMA1 network_link=DB_NAME
directory=dpump_dir remap_schema=schema1:schema2
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of VIVEK_SHARMA
Sent: Thursday, May 17, 2007 2:45 AM
To: John Darrah
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Change Schema OWNER of ALL Objects in 10gR2 ? ... SOLVED
Thanks John for the valuable Advice.
Since 2000 Objects are scattered across 55 Tablespaces, but of Total
Data Size 8 GB only, I achieved the Data transfer from 1 Schema to
Another thru expdp - SCHEMAS=OWNER1 / impdp - REMAP_SCHEMA=OWNER1:OWNER2
Cheers
________________________________
From: John Darrah [mailto:darrah.john@xxxxxxxxx]
Sent: Wednesday, May 16, 2007 3:09 AM
To: VIVEK_SHARMA
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Change Schema OWNER of ALL Objects in 10gR2 ?
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***
------------------------------------------------------------------------------
NOTICE: This electronic mail message and any attached files are confidential.
The information is exclusively for the use of the individual or entity intended
as the recipient. If you are not the intended recipient, any use, copying,
printing, reviewing, retention, disclosure, distribution or forwarding of the
message or any attached file is not authorized and is strictly prohibited. If
you have received this electronic mail message in error, please advise the
sender by reply electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your computer
system. Thank you.
==============================================================================
Other related posts:
