【예제】☜ $ exp userid=scott/tiger tables=(scott.emp) Export: Release 11.1.0.6.0 - Production on Thu Jun 4 12:51:01 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Export done in KO16KSC5601 character set and AL16UTF16 NCHAR character set server uses KO16MSWIN949 character set (possible charset conversion) About to export specified tables via Conventional Path ... . . exporting table EMP 14 rows exported EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. Export terminated successfully with warnings. $ $ ls -l expdat.dmp -rw-r--r-- 1 jijoe junik 7168 6월 4일 12:51 expdat.dmp $ file expdat.dmp expdat.dmp: 데이터 $
먼저 해당 테이블을 drop한 다음에
$ imp userid=scott/tiger file=expdat.dmp tables=emp Import: Release 11.1.0.6.0 - Production on Sun Jun 7 12:18:59 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Export file created by EXPORT:V11.01.00 via conventional path import done in KO16KSC5601 character set and AL16UTF16 NCHAR character set import server uses KO16MSWIN949 character set (possible charset conversion) . importing SCOTT's objects into SCOTT . importing SCOTT's objects into SCOTT . . importing table "EMP" 14 rows imported Import terminated successfully without warnings. $