数据恢复步骤

切换到oracle用户
sqlplus
conn / AS sysdba
DROP USER <USER> cascade;
CREATE USER <USER> IDENTIFIED BY <PASSWORD> DEFAULT tablespace <TABLESPACE>;
exit
imp <USER>/<PASSWORD> file=<FILE_NAME> fromuser=<USER> touser=<USER>
*为要恢复的用户，为其密




Related posts:
  1. oracle修改用户密码
    2. 

  2. 在linux重新启动下如何设置oracle服务自动开启
    3. 

  3. Oracle数据库日常维护手册
    4. 

  4. mysql修改数据库权限
    5. 

  5. 用split分割备份文件，和用cat恢复备份
    6.
This entry was written by wd, posted on 八月 5, 2006 at 4:48 下午, filed under Other and tagged , . Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never shared.