RE: Change Schema OWNER of ALL Objects in 10gR2 ? ... SOLVED
- From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
- To: "John Darrah" <darrah.john@xxxxxxxxx>
- Date: Thu, 17 May 2007 13:15:19 +0530
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***
Other related posts:
