Oracle数据库的导入导出

错误示例：

imp galasys/HD__Winform@//192.168.100.201:1521/orcl file=E:\DataBaseBackUp\galasys_20180108101909.dmp fromuser=galasys touser=galasys log=/imp.log 
pause

批处理文件执行结果：

已经完成 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、工具-数据库复制-源连接-目的连接