Advertisement
Guest User

Untitled

a guest
Feb 18th, 2017
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. 4. create user newhr identified by 123456;
  2. grant connect, resource to newhr ;
  3. exp system file=exp_owner.dmp log=exp_owner.log owner=HR;
  4. imp system file=exp_tbemployee.dmp log=exp_tbemployee.log fromuser=HR touser= newhr;
  5.  
  6.  
  7.  
  8. 5 .
  9. a -
  10. b - exp system file=exp_tbemployee.dmp log=exp_tbemployee.log tables=employee;
  11. c - exp system file=exp_full_01.dmp log=exp_full_01.log full=y
  12.  
  13. d - exp system file=exp_schema.dmp log=exp_schema.log owner=HR
  14. e - create user restore identified by 123456;
  15. grant connect, resource to restore;
  16. imp system file=exp_tbemployee.dmp log=exp_tbemployee.log fromuser=HR touser=restore ignore=y tables=employee;
  17.  
  18. 6.
  19. a - CREATE OR REPLACE DIRECTORY exerdba_dir AS 'c:\dir1\dir2';
  20. expdp uwclass/uwclass DIRECTORY=exerdba_dir DUMPFILE=exercdba1_full.dmp FULL=y ENCRYPTION=all ENCRYPTION_ALGORITHM=aes256 ENCRYPTION_MODE=dual ENCRYPTION_PASSWORD=oracle;
  21. b - expdp uwclass DIRECTORY=exerdba_dir DUMPFILE=exercdba2.dmp SCHEMAS=HR,SCOTT;
  22. c - expdp uwclass DIRECTORY=exerdba_dir DUMPFILE=exercdba2.dmp TABLES=HR.departments;
  23. d -
  24. impdp system DIRECTORY=exerdba_dir DUMPFILE=exercdba1_full.dmp Schema=restore tables= HR.employees ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement