今天使用impdp实施数据导入时遭遇ora-31631、ora-39122报错，如下所示：
c:\documents and settings\hoegh>impdp hoegh/hoegh directory=data_pump_directory
dumpfile=hoegh.dmp remap_schema=hoeghfrom:hoegh remap_tablespace=hoeghfromtbs:hoeghtbs
import: release 10.1.0.2.0 - production on 星期六, 10 10月, 2015 9:49
copyright (c) 2003, oracle. all rights reserved.
connected to: oracle database 10g enterprise edition release 10.1.0.2.0 - produc
tion
with the partitioning, olap and data mining options
ora-31631: privileges are required
ora-39122: unprivileged users may not perform remap_schema remappings.
c:\documents and settings\hoegh>
从报错提示信息来看，是权限不足造成的。通过查阅文档得知，当执行impdp操作指定remap_schema参数时，需要具备imp_full_database权限。接下来，我们给hoegh用户赋予imp_full_database权限。
sql>
sql> grant imp_full_database to hoegh;
grant succeeded.
sql>
授权成功后，再次执行impdp语句，成功。
c:\documents and settings\hoegh>
c:\documents and settings\hoegh>impdp hoegh/hoegh directory=data_pump_directory
dumpfile=hoegh.dmp remap_schema=hoeghfrom:hoegh remap_tablespace=hoeghfromtbs:hoeghtbs
import: release 10.1.0.2.0 - production on 星期六, 10 10月, 2015 9:54
copyright (c) 2003, oracle. all rights reserved.
connected to: oracle database 10g enterprise edition release 10.1.0.2.0 - produc
tion
with the partitioning, olap and data mining options
master table hoegh.sys_import_full_01 successfully loaded/unloaded
starting hoegh.sys_import_full_01: hoegh/******** directory=data_pump_directo
ry dumpfile=hoegh.dmp remap_schema=hoeghfrom:hoegh remap_tablespace=hoeghfromtbs:hoeghtbs
processing object type table_export/table/table
processing object type table_export/table/index/index
processing object type table_export/table/constraint/constraint
processing object type table_export/table/index/statistics/index_statistics
processing object type table_export/table/index/functional_and_bitmap/index
processing object type table_export/table/index/statistics/functional_and_bitmap
/index_statistics
processing object type table_export/table/statistics/table_statistics
job hoegh.sys_import_full_01 successfully completed at 09:54