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

posted @ 2013-08-24 17:52  easynote  阅读(205)  评论(0编辑  收藏  举报