今天想把一个DB1上的schema备份还原到DB2上去,备份的动作很顺利,还原的时候报错了,报错如下(部分报错信息):
开始使用数据泵备还原chenguangfair。
Import: Release 11.2.0.4.0 - Production on 星期四 6月 9 10:04:11 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
已成功加载/卸载了主表 "SYS"."SYS_IMPORT_FULL_03"
启动 "SYS"."SYS_IMPORT_FULL_03": "sys/********@orcl AS SYSDBA" remap_schema=CHENGUANGFAIR:chenguangfair directory=chenguangfair_dumpfile_dest transform=oid:n dumpfile=CHENGUANGFAIR_20160608130442.DMP logfile=CHENGUANGFAIR_20160608130442_recover.log
处理对象类型 SCHEMA_EXPORT/USER
ORA-31685: 由于权限不足, 对象类型 USER:"CHENGUANGFAIR" 失败。失败的 sql 为:
CREATE USER "CHENGUANGFAIR" IDENTIFIED BY VALUES 'S:2336