linuxoracle用户数据导出和导入

需要新创建一个kanbandev开发账户，而把kanban用户正式数据导入到开发账户中去，方便开发

--切换用户
su - oracle
登录oracle数据库

oracle@djjsdev:/home/oracle$ sqlplus / as sysdba
--创建表空间
create tablespace kanban_dev
datafile '/u02/oradata/func44/kanban_dev.dbf'
size 100m
autoextend on
next 20m
extent management local;

 

--创建临时表空间
create temporary tablespace kanbantemp_dev 
tempfile '/u02/oradata/func44/kanbantemp_dev.dbf'
size 50m 
autoextend on 
next 20m  
extent management local;

 

--创建用户
create user kanbandev identified by kanbandev default tablespace kanban_dev temporary tablespace kanbantemp_dev;
--赋权限
grant connect,resource to kanbandev ;

--导出用户对象
oracle@oracle:/u02/oradata/func44$ exp kanban/kanban file='/u02/kanbandata/kanban20170312.dmp' log ='/u02/kanbandata/kanban.log'
--导入用户对象
oracle@oracle:/u02/oradata/func44$ imp kanbandev/kanbandev file='/u02/kanbandata/kanban20170312.dmp' log ='/u02/kanbandata/kanbanimp.log'  fromuser=kanban touser=kanbandev