oralce导入导出

oralce 数据导入

1.新的数据库

   a.创建表空间

create tablespace表空间名称
    datafile 
'表空间存储地址' size 100M AutoExtend On Next 50M Maxsize 2048M;

 b.创建用户

create user 用户名称
  identified by 用户名称
  default tablespace 表空间名称
  temporary tablespace TEMP
  profile DEFAULT;
  grant dba to 用户名称;

c.赋予权限

grant administer any sql tuning set to 用户名称;

grant administer database trigger to 用户名称;

grant alter any index to 用户名称 withadmin option;

grant alter any indextype to 用户名称 withadmin option;

grant comment any table to 用户名称 withadmin option;

grant create any index to 用户名称 withadmin option;

grant create any indextype to 用户名称 withadmin option;

grant create any table to 用户名称 withadmin option;

grant create view to 用户名称;

grant delete any table to 用户名称 withadmin option;

grant drop any index to 用户名称with adminoption;

grant drop any indextype to 用户名称 withadmin option;

grant drop any table to 用户名称 with adminoption;

grant execute any operator to 用户名称 withadmin option;

grant execute any procedure to 用户名称 with admin option;

grant insert any table to 用户名称;

grant manage any queue to 用户名称;

grant select any sequence to 用户名称 with admin option;

grant select any table to 用户名称 with admin option;

grant unlimited tablespace to 用户名称 withadmin option;

grant update any table to 用户名称;

4.导出语句

       a.全部导出

exp bpmx/bpmx@qyoms file=地址.dmp buffer=1000000 log='日志.log' full=y；

      b.指定导出

        exp lineloss/lineloss@lineloss file=(F:\LINE20121221.dmp)owner=( lineloss,offlineloss,platform,onlineloss) ignore=y

5.导入

     a.全部导入

       imp bpmx/bpmx@oms file=D:\20160509.dmp  buffer=6400000 full=y;

      b.指定用户导入

      imp lineloss/lineloss@linelossana file=(F:\LINE20121221.dmp)fromuser=( lineloss,offlineloss,platform,onlineloss) ignore=y