Currently there is a daily export of a database using exp, I want to change this to expdp (datapump)
When i take a dump using export the size is around 3GB. When I do a full export with datapump the size is around 2.6GB.
Does anybody know the difference between both? Is the difference in size normal?
command used
export
exp '/@instance as sysdba' consistent=y full=y file=d:\Dumps\dump.dmp log=d:\Dumps\log\exportGLOBP01.log
datapump
expdp "'/ as sysdba'" full=y directory=datapumpdir dumpfile=$ORACLE_DUMP logfile=exp-"$ORACLE_INSTANCE"_$date.log