Monday, April 24, 2023

user level export and import

expdp parfile=PLCT170.par oracle@uslp123sd7dfcvxsza > more PLCT050.par userid= "/ as sysdba" dumpfile=T050.dmp logfile=expdpT050.log schemas=WWSRPLawedxCT050 compression=all directory=SCRIPTS1 reuse_dumpfiles=yes impdp parfile=IMPPLCT170.par oracle@uslp123sd7dfcvxsza >more IMPPLCT050.par userid= "/ as sysdba" dumpfile=T050.dmp logfile=imp_T050.log schemas=WWSRzaswedcvbPLCT050 directory=SCRIPTS1 table_exists_action=REPLACE
at No comments:
Subscribe to: Posts (Atom)

user level export and import

expdp parfile=PLCT170.par oracle@uslp123sd7dfcvxsza > more PLCT050.par userid= "/ as sysdba" dumpfile=T050.dmp logfile=expdpT0...

  • Scripts required for 12.2.X custom
    1) For new table creations - after creating the table in custom schema execute below script to generate editoning view and synonym for it in...
  • How to hold the concurrent programs
    1) To hold the specific concurrent program Hold update fnd_concurrent_requests set HOLD_FLAG='Y' where PHASE_CODE='P'...
  • user level export and import
    expdp parfile=PLCT170.par oracle@uslp123sd7dfcvxsza > more PLCT050.par userid= "/ as sysdba" dumpfile=T050.dmp logfile=expdpT0...