imp的show参数查看exp的dump内容及用户

偶尔会遇到协作导出导入的情况。

如A通过exp将A用户导出，但是没有将用户名告诉B。
B不知道exp时的用户名就无法导入。

通过imp的show=y参数就可以看到导出时的用户名。
由于不知道fromuser，那么我们就直接写full=y。
输出的头部有导出时的用户。

$ imp userid=B/xxx file=/data/xxx/A.dmp log=/data/xxx/A_in.log buffer=100000000 full=y GRANTS=n                       
Import: Release 11.2.0.4.0 - Production on Sun Apr 17 09:06:45 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

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

Warning: the objects were exported by A, not by you

import done in US7ASCII character set and UTF8 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export client uses ZHS16GBK character set (possible charset conversion)
export server uses AL16UTF16 NCHAR character set (possible ncharset conversion)
. importing A's objects into B
. importing A's objects into B

转载请注明：
十字螺丝钉
http://blog.chinaunix.net/uid/23284114.html
QQ:463725310
E-MAIL:houora#gmail.com(#请自行替换为@)