DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, August 31, 2015

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)




No comments: