Oracle通过dmp导出用户所有对象及导入另一库中

最新推荐文章于 2024-01-11 17:57:15 发布

cherry7434

最新推荐文章于 2024-01-11 17:57:15 发布

阅读量1k

点赞数

本文链接：https://blog.csdn.net/cherry7434/article/details/98652056

版权

Linus系统上:
首先源库设置临时字符集并导出:
export NLS_LANG=‘SIMPLIFIED CHINESE_CHINA.AL32UTF8’
exp username1/password@10.1.3.331/dbname file=/oracle/filename.dmp full=y ignore=y;
目标库上如果有的话先删除:
export NLS_LANG=‘SIMPLIFIED CHINESE_CHINA.AL32UTF8’
sqlplus /nolog;
conn / as sysdba;
drop user username2 cascade;
(此处如果遇到该user有session没有关闭的话需要强制杀除:
select sid, serial#, username, program from v$session where username = ‘USERNAME2’;
alter system kill session ‘SID, SERIAL’; )
create user username2 identified by password;
grant create session to username;
grant sysdba to username2;
alter user username2 quota unlimitied on 表空间名;
grant all privileges to username;
exit;
最后导入dmp文件
imp ‘username/password as sysdba’ file=/oracle/文件名.dmp fromuser=username1 touser=username2 ignore=y log=文件名.log