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