T100 数据还原.txt

1、找到昨晚备份,用root用户解压:gunzip -d exp_hc01.dmp.gz 2、如果toptet数据库开了就进toptst里去 进toptet数据库:sqlplus sys/tiptop100@toptst as sysdba 执行: create user test identified by test default tablespace dbs1 temporary tablespace temp; grant create session,create table to test; grant resource to test; grant create synon