Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create user LR_REPORTING identified by test;
- grant dba to LR_REPORTING;
- create tablespace LR_REPORTING_DATA datafile 'C:\Users\Administrator\Desktop\dump\LR_REPORTING_DATA.dbf'size 32m autoextend on next 32m maxsize unlimited;
- alter tablespace LR_REPORTING_DATA add datafile 'C:\Users\Administrator\Desktop\dump\second.dbf' size 32m autoextend on maxsize unlimited;
- delete from LR_REPORTING.RESOURCEPERMISSION where RESOURCEPERMISSIONID in (412509,412508);
- commit;
- 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