今天使用impdp实施数据导入时遭遇ORA-31631、ORA-39122报错,如下所示:
从报错提示信息来看,是权限不足造成的。通过查阅文档得知,当执行impdp操作指定remap_schema参数时,需要具备imp_full_database权限。接下来,我们给hoegh用户赋予imp_full_database权限。
授权成功后,再次执行impdp语句,成功。
点击(此处)折叠或打开
- 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
hoegh
15.10.10
-- The End --
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30162081/viewspace-1813687/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30162081/viewspace-1813687/