· 清空用户数据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