oracle 数据库导入导出写法

//查看数据库版本  目前 11.2.0.1.0
select * from v$version;


sqlplus sys/admin@localhost:1521/orcl as sysdba;
create or replace directory bak_path as 'D:\bakup';






//导出数据


//导出具体表
expdp 'sys/1234@192.168.1.123:1521/orcl as sysdba' directory=bak_path dumpfile=%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%.dmp logfile=yc1.log schemas=sk INCLUDE=TABLE:\"in (\'SYS_CS\')\" version=10.2.0.3.0


expdp 'sys/1234@192.168.1.123:1521/orcl as sysdba' directory=bak_path dumpfile=%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%.dmp logfile=yc.log schemas=yc  version=10.2.0.3.0
//导入数据


impdp 'sys/1234@localhost:1521/orcl as sysdba' directory=bak_path dumpfile=sk.dmp   remap_schema=sk:sk remap_tablespace=users:users


//导入数据时，如果表存在，则替换


impdp 'sys/1234@192.168.1.123:1521/orcl as sysdba' TABLE_EXISTS_ACTION=replace   directory=bak_path dumpfile=20171101.dmp   remap_schema=sk:sk remap_tablespace=users:users












//exp导出
 EXP sk/sk@ORCL  FILE=D:\SONIC.DMP  TABLES=(SYS_CS) 


//IMP导入
@echo off
sqlplus sk/sk
@drop
imp sk/sk@ORCL  file=D:\SONIC.DMP fromuser=sk touser=sk full=y