切换到oracle用户
sqlplus
conn / as sysdba
drop user  cascade;
create user  identified by  default tablespace ;
exit
imp / file= fromuser= touser=

*为要恢复的用户，为其密