1.create user username identified by userpassword default tablespace dzzw;不要使用user作为你的用户名,user已经是关键字了。 2.imp username/userpassword full=y file=x.dmp;
-- 创建用户 create user username identified by password default tablespace dzzw temporary tablespace temp; -- 给用户赋权限(最好与导出用户的角色和权限相同) grant dba to username with admin option; grant connect to username with admin option;grant alter any table to username with admin option; grant unlimited tablespace to username with admin option;--运行->cmd imp username/password file=...\x.dmp full=y ignore=y --file=...文件的存放路径
在plsql里面create user okflow identified by okflow default tablespace dzzw成功在cmd里面执行下面的报错了 Microsoft Windows XP [版本 5.1.2600] (C) 版权所有 1985-2001 Microsoft Corp.C:\Documents and Settings\Administrator>D:D:\>imp okflow/okflow full=y file=6.dmpImport: Release 10.2.0.1.0 - Production on 星期日 12月 26 11:42:11 2010Copyright (c) 1982, 2005, Oracle. All rights reserved. IMP-00058: 遇到 ORACLE 错误 1045 ORA-01045: user OKFLOW lacks CREATE SESSION privilege; logon denied用户名:
到你的sys下, grant connect,resour to okflow; grant exp_full_database,imp_full_database to okflow;
2.imp username/userpassword full=y file=x.dmp;
-- 创建用户
create user username
identified by password
default tablespace dzzw
temporary tablespace temp;
-- 给用户赋权限(最好与导出用户的角色和权限相同)
grant dba to username with admin option;
grant connect to username with admin option;grant alter any table to username with admin option;
grant unlimited tablespace to username with admin option;--运行->cmd
imp username/password file=...\x.dmp full=y ignore=y
--file=...文件的存放路径
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.C:\Documents and Settings\Administrator>D:D:\>imp okflow/okflow full=y file=6.dmpImport: Release 10.2.0.1.0 - Production on 星期日 12月 26 11:42:11 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.
IMP-00058: 遇到 ORACLE 错误 1045
ORA-01045: user OKFLOW lacks CREATE SESSION privilege; logon denied用户名:
grant connect,resour to okflow;
grant exp_full_database,imp_full_database to okflow;