创建表空间及数据的导入导出

//创建数据表空间
drop tablespace hkfg including contents and datafiles;
create tablespace hkfg
logging
datafile 'F:\oracle\product\10.2.0\oradata\orcl\hkfg.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;

 

//创建用户并指定表空间
drop user hkfg cascade
create user hkfg identified by "1"
default tablespace hkfg ;
--temporary tablespace test_temp;

 

//给用户授予权限

grant dba,create session to hkfg;

imp hkfg/1@orcl file=d:\hkfg.dmp full=y;

 

imp sms/sms@pgspay file=D:\mis.dmp log=mis.log fromuser=safe touser=sms

 

导出oracle数据文件
exp hkfg/1@orcl file=f:\hkfg.dmp full=y;

 

 

 

 

exp username/password@pgspay file=d:\paylog

ic.dmp owner=playlogic log=d:\paylogic.log