用户在命令状态下导出时无效
系统 win2000+oracle8i
用户 bill 权限 和sys用户一样
数据库 bill
服务名 bill
我在命令状态下:E:\>exp userid=sys/sys owner=bill file=e:\dd.dmp
Export: Release 8.1.5.0.0 - Production on Thu Nov 29 16:06:33 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
Export done in ZHS16CGB231280 character set and ZHS16CGB231280 NCHAR character
et
About to export specified users ...
EXP-00010: BILL is not a valid username
Export terminated successfully with warnings.
E:\>
但是我在oracle enterprise management中可以成功导出bill用户的所有对象
并且命令状态下:
E:\>imp userid=tst/tst file=e:\dd.dmp fromuser=bill touser=tst ignore=y
可以成功地把bill的对象导入tst中
并没有提示EXP-00010: BILL is not a valid username
谢谢大虾们的帮助