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
Subscribe to:
Posts (Atom)
Plan SQL's
SELECT sql_id, plan_hash_value, executions, inst_id FROM gv$sql WHERE sql_id='bhwamkg4y2pxb'; SELECT ...
-
1) For new table creations - after creating the table in custom schema execute below script to generate editoning view and synonym for it in...
-
1) How to compile a form? A) Open the source code in the client PC using X-Server -------------------------------------------------------...
-
1) To hold the specific concurrent program Hold update fnd_concurrent_requests set HOLD_FLAG='Y' where PHASE_CODE='P'...