+++++++++++++++++++++++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
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
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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++++++++++++++++++++++++++++++
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