Red+Hat+Linux5.5下安装Oracle10g

5、创建用户,指定密码和上边创建的用户表空间

CREATE USER hc IDENTIFIED BY hc DEFAULT TABLESPACE NOTIFYDB;

6、赋予权限

grant connect,resource to hc; grant unlimited tablespace to hc; grant create database link to hc;

grant select any sequence,create materialized view to hc; grant IMP_FULL_DATABASE to hc

经过以上操作,我们就可以使用hc/hc登录指定的实例,创建我们自己的表了,赋予导入表权限

imp usrname/password@SID file=XXX.dmp fromuser=username touser=username ignore=y full=y;

导入结果

联系客服:779662525#qq.com(#替换为@)