oracl 数据库 exp 导出 imp 导入

create tablespace YN_TZXM datafile 'D:/app/Administrator/oradata/orcl/YN_TZXM.DBF' size 8000m   autoextend on   next 1000m maxsize unlimited EXTENT MANAGEMENT LOCAL;
create temporary tablespace YN_TZXM_TEMP tempfile 'D:/app/Administrator/oradata/orcl/YNTZXMEMP.DBF' size 128m reuse autoextend on next 128m maxsize unlimited;
create user YN_TZXM identified by YN_TZXM default tablespace TZXM temporary tablespace YN_TZXM_TEMP ;
grant connect,resource,dba to YN_TZXM;

exp YN_TZXM/YN_TZXM@ORCL FILE=D:\YN_TZXM.dmp OWNER = YN_TZXM LOG=D:\YN_TZXM.log

imp 用户名/密码@ip:端口/实例 file=D:\backup\YN_TZXM.dmp full=y

上一篇:查找oracle数据库表相关信息语句


下一篇:oracle表空间不够用怎么解决?