exp、imp简单测试

imp

分为以下几个测试场景

imp name1/password1 file=xxxx.dmp full=y fromuser=name2 touser=name3

场景1
name1正确、password1 错误
场景2
name2 错误
场景3
name3 错误
场景4
name1错误、password1 错误即使用非导出用户的其他用户执行导入操作

*********************************************************************************************
场景1
[oracle@Oracle10g db_back]$ imp ilearn123/oracle@prod file=1022_ilearn_full.dmp full=y

Import: Release 10.2.0.1.0 - Production on Tue Sep 23 13:32:37 2014

IMP-00058: ORACLE error 1017 encountered
ORA-01017: invalid username/password; logon deniedUsername:
报错：无效的用户密码
*********************************************************************************************
场景2

name2 错误即：非导出用户
[oracle@Oracle10g db_back]$ imp \'sys/oracle@prod as sysdba\' file=1022_ilearn_full.dmp fromuser=sys123 touser=ilearn

Import: Release 10.2.0.1.0 - Production on Tue Sep 23 13:38:22 2014

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
export 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 file
Import terminated successfully with warnings.
报错： sys123 即 name2 在备份文件中找不到该用户
*********************************************************************************************
场景3

name3 错误即：数据库中不存在该用户
[oracle@Oracle10g db_back]$ imp \'sys/oracle@prod as sysdba\' file=1022_ilearn_full.dmp fromuser=sys touser=ilearn123

Import: Release 10.2.0.1.0 - Production on Tue Sep 23 13:40:20 2014

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

. importing SYS's objects into ILEARN123
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
Import terminated successfully with warnings.
报错：用户不存在
*********************************************************************************************
场景4

[oracle@Oracle10g db_back]$ imp ilearn/oracle@prod file=1022_ilearn_full.dmp fromuser=sys touser=ilearn

Import: Release 10.2.0.1.0 - Production on Tue Sep 23 13:43:39 2014

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V09.02.00 via conventional path

Warning: 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_rpt

Export: Release 10.2.0.1.0 - Production on Tue Sep 23 17:39:46 2014

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
EXP-00026: conflicting modes specified
EXP-00000: Export terminated unsuccessfully

报错：模式冲突
*********************************************************************************************
场景3
[oracle@Oracle10g db_back]$ exp ilearn/oracle@prod file=/home/oracle/db_back/1023_ilearn.dmp owner=ilearn_rpt

Export: Release 10.2.0.1.0 - Production on Tue Sep 23 17:42:37 2014

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

About 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 statistics
Export terminated successfully without warnings.
成功执行

巴特西

exp、imp简单测试

最新文章

热门文章