Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 4. create user newhr identified by 123456;
- grant connect, resource to newhr ;
- exp system file=exp_owner.dmp log=exp_owner.log owner=HR;
- imp system file=exp_tbemployee.dmp log=exp_tbemployee.log fromuser=HR touser= newhr;
- 5 .
- a -
- b - exp system file=exp_tbemployee.dmp log=exp_tbemployee.log tables=employee;
- c - exp system file=exp_full_01.dmp log=exp_full_01.log full=y
- d - exp system file=exp_schema.dmp log=exp_schema.log owner=HR
- e - create user restore identified by 123456;
- grant connect, resource to restore;
- imp system file=exp_tbemployee.dmp log=exp_tbemployee.log fromuser=HR touser=restore ignore=y tables=employee;
- 6.
- a - CREATE OR REPLACE DIRECTORY exerdba_dir AS 'c:\dir1\dir2';
- expdp uwclass/uwclass DIRECTORY=exerdba_dir DUMPFILE=exercdba1_full.dmp FULL=y ENCRYPTION=all ENCRYPTION_ALGORITHM=aes256 ENCRYPTION_MODE=dual ENCRYPTION_PASSWORD=oracle;
- b - expdp uwclass DIRECTORY=exerdba_dir DUMPFILE=exercdba2.dmp SCHEMAS=HR,SCOTT;
- c - expdp uwclass DIRECTORY=exerdba_dir DUMPFILE=exercdba2.dmp TABLES=HR.departments;
- d -
- impdp system DIRECTORY=exerdba_dir DUMPFILE=exercdba1_full.dmp Schema=restore tables= HR.employees ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement