RE: Renaming schemas directly

From: Bellows, Bambi (Comsys) <"Bellows,>
Date: Mon, 31 Aug 2009 11:59:48 -0500
Message-ID: <AD0CB572A820AB4E8E52ABD38950FD3606AEAD1B_at_a0001-xpo0150-s.hodc.ad.allstate.com>

The problem with that is that you cannot remap schemas and tablespaces in a single datapump or exp/imp operation. I can do one or the other. I am in a situation where we need to allow the users to do both, which means that it is clearly a post-processing step. If the users migrate all tablespaces for a particular schema we can rename the schema as part of the operation and then rename tablespaces in the post-processing step, but if they only bring over one tablespace out of 12, and rename that and also want to rename the schema at the same time, the datapump/exp operation is at the tablespace level and the schema needs to change in the post-processing step.  

---

From: Allen, Brandon [mailto:Brandon.Allen_at_OneNeck.com] Sent: Monday, August 31, 2009 11:56 AM
To: Bellows, Bambi (Comsys); Oracle L
Subject: RE: Renaming schemas directly  

I've never tried that method, and wouldn't advise it on a production DB. The supported method is to use exp/imp with fromuser/touser, or expdp/impdp with remap_schema.  

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_import .htm#sthref340    

Regards,

Brandon    

---

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 31 2009 - 11:59:48 CDT