1.创建表空间(连接数据库后操作)
create tablespace mytest logging datafile 'E:\app\mumu7up\oradata\orcl\mytest.dbf' size 10m autoextend on next 10m maxsize 1024m extent management local;
2.创建用户并赋予权限
2.1创建用户,名字:mytest,密码:123456 使用的表空间:mytest
create user mytest identified by 123456 default tablespace mytest temporary tablespace temp;
2.2赋予权限
grant connect,resource,dba to mytest;
3.创建目录变量
create or replace directory dump_dir as 'E:\dump_dir';
上面语句只是告诉oracel有这个目录,这条命令自己不会自动创建,需要自己手动去创建
5.导出(cmd中操作)
expdp userid=mytest/123456 dumpfile=mytest01.dmp directory=dump_dir
6.导入(cmd中操作)
impdp userid=mytest/123456 dumpfile=mytest01.DMP directory=dump_dir remap_schema=mytest:mytest remap_tablespace=mytest:mytest