Oracle_导入导出

1.导出
grant dba to zhangdan
cm窗口执行：
exp '用户名/密码 as sysdba' tablespaces=(表空间名)  file=d:\文件名.dmp

例如：
exp 'zhangdan/zhangdan as sysdba' tablespaces=(crm)  file=d:\crm.dmp

2.导入
--table space
CREATE TABLESPACE crm
DATAFILE 'd:\JBITDB\EPET.DBF'
SIZE 100M--以分号结束
--create user
CREATE USER zhangdan
IDENTIFIED BY zhangdan
DEFAULT TABLESPACE crm;
--给权限
grant dba to zhangdan
cm窗口执行:
imp 'zhangdan/zhangdan as sysdba' file=d:\crm.dmp full=y

 

exp 'epet/epet as sysdba' tablespaces=(epet_tablespace)  file=d:\epet.dmp

imp 'epet/epet as sysdba' file=d:\epet.dmp full=y

drop tablespace epet_tablespace including contents;

 

drop user epet cascade;