Monday, 20 July 2015

expdp and impdp running as scripts from cronjobs

+++++++++++++++++++++++expdp_gp_govp.par+++++++++++++++++++++++++++++++++++
userid= "/ as sysdba"
DUMPFILE=GOVP_GP_EXP_%U.dmp
SCHEMAS=GP
DIRECTORY=GOVTPR_EXP_DIR
PARALLEL=12
COMPRESSION=ALL
LOGFILE=GOVP_GP_EXP_10Oct_14.log
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

+++++++++++++++++++++++exp_cars_cmp.ksh*+++++++++++++++++++++++++++++++++++
exp userid=cars/nueva123@cmp file=exp_cars_cmp_d100714.dmp owner=CARS grants=N statistics=none compress=N recordlength=8192 consistent=Y log=exp_cars_cmp_d100714.log
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

+++++++++++++++++++++++sys.invalid_object_before_import.sh+++++++++++++++++++++++
 select owner||'.'||object_name object_name,object_type,status
  2  from dba_objects
  3  where status != 'VALID'
  4  order by owner,object_type,object_name,status
  5  /
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

+++++++++++++++++++++++++++impdb_gp_govp.par*++++++++++++++++++++++++++++++
impdp userid="'/ as sysdba'"
dumpfile=GOVP_GP_EXP_%U.dmp
logfile=imp_ GOVP_GP.log
directory= GOVTPR_EXP_DIR
schemas =GP
parallel=12
table_exists_action=replace
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+++++++++++++++++++++++++++impdb_gp_govp.sh++++++++++++++++++++++++++++++

impdp userid="'/ as sysdba'"
dumpfile=GOVP_GP_EXP_%U.dmp
logfile=imp_ GOVP_GP.log
directory= GOVTPR_EXP_DIR
schemas =GP
parallel=12
table_exists_action=replace
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

No comments:

Post a Comment