导出用户oracle下的所有表
exp system/oracle owner=oracle file='/tmp/oracle-table-20130509.dmp' log='/tmp/oracle-table-20130509.log';
导入用户oracle下的表:
imp system/oracle file='/tmp/oracle-table-20130509.dmp' log='/tmp/oracle-table-20130509.log' fromuser=oracle;
此文件是导出用户oracle下的所有表 。
按以上sql语句导入数据库即可,如果没有oracle用户,建议创建oracle用户。
含有emp,dept表等。详见log日志。
. about to export ORACLE's tables via Conventional Path ...
. . exporting table BOOK 1 rows exported
. . exporting table CLASS 0 rows exported
. . exporting table CUSTOMER 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table DEPT 4 rows exported
. . exporting table EMP 17 rows exported
. . exporting table GOODS 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table PURCHASE 0 rows exported
. . exporting table SALGRADE 5 rows exported
. . exporting table STU 0 rows exported
. . exporting table TEMP_TABLE 16 rows exported
. . exporting table USR 10 rows exported
1