Data Pump and export Parameters-Feedback,Status

Data Pump and export Parameters-Feedback,Status 




Data Pump Parameters-Status 




SQL> select count(*) from don;


  COUNT(*)
———-

     57344

expdp system/oracle full=y directory=TEST_DIR dumpfile=feed.dmp logfile=feed.log


Control+c


Status





Export> status


Job: SYS_EXPORT_TABLE_01
  Operation: EXPORT
  Mode: TABLE
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: /u01/dump/feed.dmp

    bytes written: 4,096









Export Parameters-Feedback






exp scott/tiger tables=don feedback=5000 file=/u01/feed.dmp log=/u01/feed.log




SQL> select count(*) from don;


  COUNT(*)
———-

     57344

[oracle@oracle11g dump]$ exp scott/tiger tables=don feedback=10000 file=/u01/feed.dmp log=/u01/feed.log
Export: Release 11.2.0.3.0 – Production on Mon Aug 31 11:52:56 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)
About to export specified tables via Conventional Path …
. . exporting table                            DON
….. see the five dots (one Dot =10000 rows export completed)
  • August 31, 2015 | 12 views
  • Comments