export incremental

$vi expinc

insert the following lines in the file

userid=userid/password

buffer=64000

file=expfull161106.dmp

log=expfull161106.log

compress=n

grants=y

indexes=y

direct=n

rows=y

# The following will not work for INCTYPE=COMPLETE

#consistent=y

full=y

#owner=dotsoft

#tables=<tables>

#recordlength=<rclength>

INCTYPE=INCREMENTAL

triggers=y

statistics=NONE

constraints=y

feedback=10000

$ exp parfile=expinc

NOTE

This will export entire table in which some dml activity was happened

SELECT * FROM DBA_EXP_FILES;

EXP_VERSION EXP_TYPE    FILE_NAME                               

----------- ----------- -----------------------------------

          1 COMPLETE    expfull161106.dmp        

          2 INCREMENTAL expinc161106.dmp