Oracle数据库导入导出
一、准备工作创建表空间:
create temporary tablespace yangwen_temp tempfile 'D:\oracle\oradata\orcl\yangwen_temp.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local; create tablespace yangwen_data logging datafile 'D:\oracle\oradata\orcl\yangwen_data.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local; --创建用户 create user admin123 identified by 123456 default tablespace yangwen_data temporary tablespace yangwen_temp; -- 授权限 grant connect,resource,dba to admin123;
二、导入导出方法
方案一:1.1 数据库的备份-逻辑备份:
expdp wzzjxt/wzzjxt@wzzj DIRECTORY=data_dump_dir dumpfile=%backup_file%.dmp
1.2 数据库的还原-逻辑还原:
impdp aaa/aaa directory=data_dump_dir dumpfile=px.DMP REMAP_SCHEMA=px:aaa
示例:
创建用户以及授权限
create directory DATA_PUMP_DIR as'd:\'; create user v106 identified by v106; grant dba,connect,resource to v106; grant read,write on directory DATA_PUMP_DIR to v106; impdp sanyuechu/sanyuechu DIRECTORY=DATA_PUMP_DIR DUMPFILE=TEST.DMP
方案二:
1.1 数据库的备份-逻辑备份:
exp userName/passWord@IP file=d:/数据库文件.dmp
数据库的还原-逻辑还原:
创建用户:(在sys系统用户执行sql)
create user userName identified by passWord; grant dba,connect,resource to userName; imp userName/passWord@ORCL file=E:\数据库文件.dmp ignore=y full=y log=e:\app\log\imp.log
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。