第一步登陆sqlplus登陆用户。
第二部:创建表空间
第三部:创建用户
代码如下:
CREATE USER "HDS" PROFILE "DEFAULT"
IDENTIFIED BY hds
DEFAULT TABLESPACE HDSDATA
TEMPORARY TABLESPACE temp
ACCOUNT UNLOCK;
GRANT CREATE VIEW TO "HDS";
GRANT "CONNECT" TO "HDS";
GRANT "RESOURCE" TO "HDS";
GRANT DEBUG ANY PROCEDURE TO "HDS";
GRANT EXECUTE ANY PROCEDURE TO "HDS";
GRANT SELECT ANY TABLE TO "HDS";
GRANT SELECT ANY DICTIONARY TO "HDS";
grant unlimited tablespace to "HDS";
我第四步:导入数据
imp system/orcl@orcl file=E:\oracle\orcl\orcl_his.dmp log=E:\oracle\orcl\log\orcl_his.dmp.log fromuser=SYHIS touser=SYHIS ignore=y
imp system/orcl@orcl file=E:\oracle\orcl\orcl_hds.dmp log=E:\oracle\orcl\log\orcl_hds.dmp.log fromuser=HDS touser=HDS ignore=y
求大神告诫第四步该怎么解决啊?
system/orcl@orcl这个是什么意思?我的数据库设置的信息是
windows用户liuyuqing123
密码:liuyuqing123
数据库全名:orclhd123
管理口令:Lyq7784742839
可插入数据库名:pdborclhd123
EM database Express https://localhost:5501/em
system/orcl@orcl 应该怎么修改呢?
这是我安装完oracle数据库后,用sysdba用户登陆的。第四步中文件的路径是正确的