Chinaunix首页 | 论坛 | 博客
  • 博客访问: 68543
  • 博文数量: 22
  • 博客积分: 300
  • 博客等级: 二等列兵
  • 技术积分: 167
  • 用 户 组: 普通用户
  • 注册时间: 2010-03-03 22:28
文章分类

全部博文(22)

文章存档

2011年(22)

我的朋友

分类: Oracle

2011-09-05 22:23:31

impdp中remap_schema用法格式

  1. REMAP_SCHEMA
  2. Default: none
  3. Purpose
  4. Loads all objects from the source schema into a target schema.
  5. Syntax and Description
  6. REMAP_SCHEMA=source_schema:target_schema
  7. Multiple REMAP_SCHEMA lines can be specified, but the source schema must be different for each one. However, different source schemas can map to the same target schema. The mapping may not be 100 percent complete, because there are certain schema references that Import is not capable of finding. For example, Import will not find schema references embedded within the body of definitions of types, views, procedures, and packages.
  8. If the schema you are remapping to does not already exist, the import operation creates it, provided the dump file set contains the necessary CREATE USER metadata for the source schema and you are importing with enough privileges.
阅读(1980) | 评论(0) | 转发(0) |
0

上一篇:面试题锦集

下一篇:Oracle sql 日常积累

给主人留下些什么吧!~~