表备份sql:
create table table_name_bak as select * from table_name;
表导出sql:
exp userid=scott/oracle@orcl tables=(emp) file=d:\emp.dmp --导出单个表
参考链接:
http://blog.itpub.net/8052765/viewspace-1115474/
https://my.oschina.net/open4source/blog/475656