Advertisement
Guest User

tibi

a guest
Jun 27th, 2019
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. create user LR_REPORTING identified by test;
  2. grant dba to LR_REPORTING;
  3. create tablespace LR_REPORTING_DATA datafile 'C:\Users\Administrator\Desktop\dump\LR_REPORTING_DATA.dbf'size 32m autoextend on next 32m maxsize unlimited;
  4. alter tablespace LR_REPORTING_DATA add datafile 'C:\Users\Administrator\Desktop\dump\second.dbf' size 32m autoextend on maxsize unlimited;
  5.  
  6. delete from LR_REPORTING.RESOURCEPERMISSION where RESOURCEPERMISSIONID in (412509,412508);
  7. commit;
  8.  
  9. impdp LR_REPORTING/test directory=PUMP_DIR dumpfile=expdp_mucamcrmtdbr03.os.amadeus.net_LIFERPPT_LR_REPORTING_20190611_%U.dmp parallel=8
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement