oracle备份恢复

· 清空用户数据
sqlplus / as sysdba
>drop user xxx cascade;
>create user xxx identified by xxoo;
>grant connect,resource,dba to xxx;

· 恢复用户数据
imp xxx/xxoo@localhost:8987/xxxdb file=zzz.dmp