oracle学习基础素材表-emp表-dept表等等

导出用户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