2008. 8. 6. 14:58

[Oralce] DataBase Export 하는 방법

[oracle@oracle 10g]$ exp fmadmin@DBSID

Export: Release 10.2.0.1.0 - Production on Wed Aug 6 14:52:16 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp > /Database/dataBackup/fm_data.dmp

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 3

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > ACTION_TABLE

. . exporting table                      ACTION_TABLE          4 rows exported
EXP-00091: Exporting questionable statistics.
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > Enter를 치면 빠져나갑니다.