Oracle数据库备份及恢复

Oracle备份：

exp vta/vtaPwd@hrst file=D:\Backup\daochu.dmp log=D:\Backup\daochu.log owner=vta

Oracle恢复：
imp vtahg/vtahgPwd@hrst file=D:\Backup\daochu.dmp log=D:\Backup\daochu.log fromuser=vta touser=vtahg

fromuser=vta ：原用户
touser=vtahg：目标用户

 

Oracle查空表：
Select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0 or num_rows is null-空表