linux oracle 数据库导出

按用户导出：

exp idc/idc  file=/opt/daoc/idc.dmp owner=idc  compress=n   buffer=100000000 log=/opt/daoc/idc.log

给用户设置查询别的表权限

grant select any sequence to idc;
grant select any table to idc;

导出单表：

exp idc/idc  file=/opt/daoc/table.dmp    tables=tablename compress=n   buffer=100000000 log=/opt/daoc/table.log