//创建数据表空间
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