oracle 数据库导出 导入模拟

导出文件

exp

hr

c:\hr.dmp

删除用户/新建用户

sqlplus / as sysdba

drop user  hr  cascade;
create user hr identified by hr  ;
grant  create session,create table, create  view,CREATE SEQUENCE,CREATE PROCEDURE,CREATE INDEXTYPE,connect,resource to hr;
grant unlimited tablespace to hr;

select * from jobs;

导入

imp