oracle导入导出单个表的办法,Linux oracle 导入导出单个表（没有外键约束的情况下）...

expdp:

SQL> create directory dir_tables as ‘/home/oracle/tables‘;

SQL> grant read,write on directory dir_tables to 用户名;

expdp [email protected] tables=用户名.表名 directory=dir_tables dumpfile=tables.dmp logfile=tables.log

impdp:

SQL> create directory dir_tables as ‘/home/oracle/imp_tables‘;

SQL> grant read,write on directory dir_tables to sys;

impdp system/system密码 directory=dir_tables dumpfile=tables.dmp logfile=tables.log

备注：涉及到级联则不可用,已有表要删除，drop table deepdata.risks

原文：http://www.cnblogs.com/yezongyang/p/5597477.html