1. What is expdp and impdp?
2. What are the Pros and Cons of exp & imp Vs expdp & impdp?
3. How we can resume the datapump jobs?
4. How we can restart the datapump jobs?
5. How to export only ddl/metadata of a table?
6. Which memory area used by datapump process?
7. How to improve datapump performance?
8. How to monitor status of datapump jobs?
9. How to stop/start/kill datapump jobs?
10. Can we import a 12c dumpfile into 19c database?
11. Can we import a 19c dumpfile into 12c database?
12. What are remapping capabilities in datapump?
13. Can we compress datapump dumpfile? is yes then how we can perform this?
14. Can we perform views alone export and import?
15. Can we perform synonym alone export and import?
16. Can we perform procedure alone export and import?
17. Can we perform functions alone export and import?
18. Can we perform trigger alone export and import?
19. What is sql loader and what is the use?
20. What are external tables?
21. What is Conventional Load Vs Direct Path Load?
22. How to Reduce the Dump file size ?
23. How to check the dump file size before ?
24. What are the use cases of EXCLUDE and INCLUDE Parameter?
25. What is the meaning of table_exists_action and what are the use cases?
26. Schema expdp and impdp will export all the user grants including roles, system privileges and object privileges?
No comments:
Post a Comment