RE: Renaming schemas directly

  • From: "Bellows, Bambi (Comsys)" <bbel5@xxxxxxxxxxxx>
  • To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>, "Oracle L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 31 Aug 2009 11:59:48 -0500

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@xxxxxxxxxxx] 
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.








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.

Other related posts: