将Oracle DMP文件导入到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.

但是在管理器中没有任何东西出现在任何架构中的表格中,而且我的智慧结束了.

C:&;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

希望有所帮助！

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!