传统路径导出VS直接路径导出(oracle exp direct=y)(二)
COUNT(*)
----------
5000
robin@SZDB:/u02/database/SYBO2SZ/BNR/dump> exp scott/tiger file=exp_testtab2.dmp tables=scott.testtab2 direct=y
Export: Release 10.2.0.3.0 - Production on Fri Jun 21 11:56:37 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.3.0 - 64bit Production
Export done in US7ASCII character set and UTF8 NCHAR character set
server uses UTF8 character set (possible charset conversion)
About to export specified tables via Direct Path ...
Table TESTTAB2 will be exported in conventional path.
. . exporting table TESTTAB2 5000 rows exported
Export terminated successfully without warnings.