客户向我们发送了一个我们需要测试的Oracle数据库.我们不使用Oracle或拥有任何内部Oracle专业知识.
我们需要设置数据库,以便我们可以连接到它并调试问题.
我重新安装了Oracle 9(客户端运行的版本)和管理工具.
对于我的生活,我无法导入数据.它不应该是这么复杂.我一定是弄错了.
我试过了：
imp 'sys/password AS SYSDBA' file=c:\database.dmp full=yes log=implog.txt
得到了：
Connected to: Personal Oracle9i Release 9.2.0.1.0 - Production With the Partitioning,OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production Export file created by EXPORT:V09.02.00 via conventional path Warning: the objects were exported by SYSTEM,not by you import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set . importing SYSTEM's objects into SYS . importing ABCDE's objects into ABCDE IMP-00003: ORACLE error 1435 encountered ORA-01435: user does not exist Import terminated successfully with warnings.
但是在管理器中没有任何东西出现在任何架构中的表格中,而且我的智慧结束了.
您需要先创建用户(或架构)
原文链接：https://www.f2er.com/oracle/205332.htmlC:\>sqlplus system/password sql> create user CLIENT_TEST identified by client_test_password; sql> grant connect,unlimited tablespace,resource to CLIENT_TEST; sql> exit
然后,您可以使用fromuser =和touser = IMP开关将数据导入新用户/架构：
C:\>imp system/password FROMUSER=ABCDE TOUSER=client_test file=c:\database.dmp full=yes
希望有所帮助！
