Re: Replication for datawarehouse

Posted by Roshan on Sep 11, 2018; 9:12am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Replication-for-datawarehouse-tp6664p6688.html

ok.

I created a cript to make the export run once in a month

archicom>cat exportPART.sh
d=$(date "+%d%m%Y")
read n < fileMonth.txt
echo $n
n=$(printf "%02d" "$((${n} + 1))")
echo $n
echo $(n+1)
expdp archicom/archi2017 dumpfile=dump${d}.dmp tables=MOBILE_DATA:MOBILE_DATA_2018_${n} DIRECTORY=BIPART

It's ok now :)

Many thanks,
Regards,

Roshan