一位客户发给我们一个 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.
但管理器中没有显示任何模式中的表,我一筹莫展。