imp分为以下几个测试场景imp name1/password1 file=xxxx.dmp full=y fromuser=name2 touser=name3场景1 name1正确、password1 错误场景2name2 错误场景3name3 错误场景4name1错误、password1 错误 即 使用非导出用户的其他用户执行导入操作*********************************************************************************************场景1[oracle@Oracle10g db_back]$ imp ilearn123/oracle@prod file=1022_ilearn_full.dmp full=yImport: Release 10.2.0.1.0 - Production on Tue Sep 23 13:32:37 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.IMP-00058: ORACLE error 1017 encounteredORA-01017: invalid username/password; logon deniedUsername: 报错：无效的用户 密码*********************************************************************************************场景2name2 错误即：非导出用户[oracle@Oracle10g db_back]$ imp \'sys/oracle@prod as sysdba\' file=1022_ilearn_full.dmp fromuser=sys123 touser=ilearnImport: Release 10.2.0.1.0 - Production on Tue Sep 23 13:38:22 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V09.02.00 via conventional pathimport done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character setexport client uses UTF8 character set (possible charset conversion)export server uses UTF8 NCHAR character set (possible ncharset conversion)IMP-00034: Warning: FromUser "SYS123" not found in export fileImport terminated successfully with warnings.报错： sys123 即 name2 在备份文件中找不到该用户*********************************************************************************************场景3name3 错误即：数据库中不存在该用户[oracle@Oracle10g db_back]$ imp \'sys/oracle@prod as sysdba\' file=1022_ilearn_full.dmp fromuser=sys touser=ilearn123Import: Release 10.2.0.1.0 - Production on Tue Sep 23 13:40:20 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining options. importing SYS's objects into ILEARN123IMP-00003: ORACLE error 1435 encounteredORA-01435: user does not existImport terminated successfully with warnings.报错：用户不存在*********************************************************************************************场景4[oracle@Oracle10g db_back]$ imp ilearn/oracle@prod file=1022_ilearn_full.dmp fromuser=sys touser=ilearnImport: Release 10.2.0.1.0 - Production on Tue Sep 23 13:43:39 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V09.02.00 via conventional pathWarning: the objects were exported by SYS, not by you*IMP-00091: Above error occurred on the following function and object: GRANT STREAMS$_EVALUATION_CONTEXT. Remaining PL/SQL blocks for this object will be skipped.*Import terminated successfully with warnings.一个警告***************************************************************************************************************************************************************************************************************************************************************************************exp场景1指定FULL 模式场景2指定FULL 模式、OWNER 模式场景3指定OWNER 模式*********************************************************************************************场景1[oracle@Oracle10g db_back]$ exp ilearn/oracle@prod file=/home/oracle/db_back/1023_ilearn.dmp full=y成功执行*********************************************************************************************场景2[oracle@Oracle10g db_back]$ exp ilearn/oracle@prod file=/home/oracle/db_back/1023_ilearn.dmp full=y owner=ilearn_rptExport: Release 10.2.0.1.0 - Production on Tue Sep 23 17:39:46 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsEXP-00026: conflicting modes specifiedEXP-00000: Export terminated unsuccessfully报错：模式冲突*********************************************************************************************场景3[oracle@Oracle10g db_back]$ exp ilearn/oracle@prod file=/home/oracle/db_back/1023_ilearn.dmp owner=ilearn_rptExport: Release 10.2.0.1.0 - Production on Tue Sep 23 17:42:37 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsExport done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character setAbout to export specified users .... exporting pre-schema procedural objects and actions. exporting foreign function library names for user ILEARN_RPT . exporting PUBLIC type synonyms. exporting private type synonyms. exporting object type definitions for user ILEARN_RPT About to export ILEARN_RPT's objects .... exporting database links. exporting sequence numbers. exporting cluster definitions. about to export ILEARN_RPT's tables via Conventional Path .... exporting synonyms. exporting views. exporting stored procedures. exporting operators. exporting referential integrity constraints. exporting triggers. exporting indextypes. exporting bitmap, functional and extensible indexes. exporting posttables actions. exporting materialized views. exporting snapshot logs. exporting job queues. exporting refresh groups and children. exporting dimensions. exporting post-schema procedural objects and actions. exporting statisticsExport terminated successfully without warnings.成功执行
转载于:https://www.cnblogs.com/iyoume2008/p/4690595.html
