我用system ,123456登录pl/sql,用命令创建用户,添加权限
create user cmsportal identified by cmsportal default tablespace system temporary tablespace temp;
alter user tcmsportal quota unlimited on system;
grant create session to cmsportal;
grant create table to cmsportal;
commit;然后在dos下执行imp导入命令imp cmsportal/cmsportal@cmsorac file=e:\cdga.dmp ignore=y touser=cmsportal fromuser=cdga 报imp-00013:只有DBA才能导入由其它DBA导出的文件然后我又改了下导入命令imp system/123456@cmsorac file=e:\cdga.dmp ignore=y touser=cmsportal fromuser=cdga full=y
报ora-01017:invalid username/password; logon denied各位高手,我该怎么搞才能正确导入数据库啦,,谢谢啦!!!
create user cmsportal identified by cmsportal default tablespace system temporary tablespace temp;
alter user tcmsportal quota unlimited on system;
grant create session to cmsportal;
grant create table to cmsportal;
commit;然后在dos下执行imp导入命令imp cmsportal/cmsportal@cmsorac file=e:\cdga.dmp ignore=y touser=cmsportal fromuser=cdga 报imp-00013:只有DBA才能导入由其它DBA导出的文件然后我又改了下导入命令imp system/123456@cmsorac file=e:\cdga.dmp ignore=y touser=cmsportal fromuser=cdga full=y
报ora-01017:invalid username/password; logon denied各位高手,我该怎么搞才能正确导入数据库啦,,谢谢啦!!!
grant connection,resource to tcmsportal
你system用户的密码错了吧
改成 imp system/123456@cmsorac as sysdba file=e:\cdga.dmp ignore=y touser=cmsportal fromuser=cdga full=y
要么就用一般的用户导出来 别用system
grant dba, connect, unlimited tablespace, select any table, select any dictionary to ffff;
导入:
imp aichannel/aichannel@HUST full=y file=d:datanewsmgnt.dmp ignore=y
或者如果用sys导入的话 :
dos下:imp 回车 它会提示你输入,按步骤输入即可,注意用户名的时候,这样写:sys as sysdba
其他 没什么问题了,我也是刚才搞定导出导入
第一个就不说了说第二个--你的system 的密码是否是123456
imp system/123456@cmsorac file=e:\cdga.dmp ignore=y touser=cmsportal fromuser=cdga full=y而且你的写法也有问题--指定了touser,fromuser full=y 就冲突了
imp system/123456@cmsorac file=e:\cdga.dmp ignore=y touser=cmsportal fromuser=cdga