错误示例:
imp galasys/HD__Winform@//192.168.100.201:1521/orcl file=E:\DataBaseBackUp\galasys_20180108101909.dmp fromuser=galasys touser=galasys log=/imp.logpause
批处理文件执行结果:
已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入
IMP-00024: 只能指定一种模式 (TABLES, FROMUSER 或 FULL)
IMP-00000: 未成功终止导入
解决:选择了FROMUSER 就不能选择FULL
正确的Oracle导入导出:
一、IMP、EXP
import_gstest.bat
imp galasys/HD__Winform@//192.168.100.201:1521/orcl file=E:\DataBaseBackUp\galasys_20171220143536.dmp fromuser=galasys touser=galasys
pause
exportgsoffline.bat
set d=%date:~0,10%set d=%d:-=%
set d=%d: =0%
set t=%time:~0,8%
set t=%t::=%
set t=%t: =0%
echo "%p%%d%%t%"
exp galasys/HD__Winform@200 file=E:\DataBaseBackUp\galasys_%p%%d%%t%.dmp owner=galasys STATISTICS=NONE
二、sqldeveloper工具的数据库复制功能
1、用system账户登录
2、删除数据库
--删除用户
drop user HDXS;
--提示无法删除当前连接的用户,Kill所有username = HDXS的Session
select username,sid,serial# from v$session;
alter system kill session'13,29987';
drop user HDXS CASCADE;
-- Create the user
create user HDXS identified by HD__XS
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant dba to HDXS with admin option;
-- Grant/Revoke system privileges
grant create public database link to HDXS;
grant debug any procedure to HDXS;
grant unlimited tablespace to HDXS with admin option;
3、工具-数据库复制-源连接-目的连接