导入我的 oracle 10g 数据库时出错
我在 Debian 机器上运行我的 oracle。今天我决定创建一个新用户和一个新表空间。然后我使用同一台机器上的用户系统导出数据库。当我尝试导入到新用户帐户时出现一些错误。 这就是我所做的：
./imp mynewuser/passwrdb@orcl file=newdump_sept.dmp system/tomynewuser
Import: Release 10.2.0.1.0 - Production on Thu Sep 29 18:06:23 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release
10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by SYSTEM, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00085: multiple input files specified for unbounded export file
IMP-00000: Import terminated unsuccessfully
对我的问题有什么建议吗？
I am running my oracle on a debian machine. Today I decided to create a new user and a new tablespace. Then I export a database with the user System which on the same machine. I got some error when I try to import to my new user account.
here is what I've done:
./imp mynewuser/passwrdb@orcl file=newdump_sept.dmp system/tomynewuser
Import: Release 10.2.0.1.0 - Production on Thu Sep 29 18:06:23 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release
10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by SYSTEM, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00085: multiple input files specified for unbounded export file
IMP-00000: Import terminated unsuccessfully
Any suggestion to my problem?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
来自 http://www.error-code.org。 uk/view.asp?e=ORACLE-IMP-00085 ：
您可能应该使用：
寻求帮助：
imp help=yFrom http://www.error-code.org.uk/view.asp?e=ORACLE-IMP-00085 :
You should probably use:
For help:
imp help=y就我而言，我通过使用 SYS 用户而不是 SYSTEM 用户导入转储文件解决了错误，并且导入工作没有错误。
In my case I solved the error by importing the dump file by using SYS user instead of SYSTEM user and import working without errors.