oracle数据导入导出

1、以操作系统权限认证的oracle sys管理员登陆

sqlplus "/as sysdba"

  

2、创建表空间

create tablespace xx datafile 'F:\app\Administrator\oradata\xx.dbf' size 200m autoextend on next 20m;

3、创建临时表空间

create temporary tablespace xx_temp tempfile 'F:\app\Administrator\oradata\xx_temp.dbf' size 200m autoextend on next 20m;

4、创建用户

create user xx identified by fjkz default tablespace xx temporary tablespace xx_temp;

5、用户授权

grant dba to xx;

 6、数据库备份导出

 expdp xx/xx@orcl  dumpfile=xx.dmp schemas=xx

7、数据库备份导入

 impdp fjkz_dj/fjkz_dj@orcl dumpfile=FJKZ_DJ_20160202.dmp  schemas=fjkz_dj