Interested to Buy Any Domain ? << Click Here >> for more details...
what is datapump? Difference between exp and expdp?
- 2 Answers
- 21648 Views
- Capital IQ, TCS, WNS, I also Faced
- E-Mail Answers
Answer Posted / aanand shirodkar
1. you can deattach or reattch datapump job.
2. you can parallelise datapump job [PARALLEL=4]
3. without export can do import using NETWORK_LINK parameter
4. can calculate export dump file size using ESIMATE_ONLY
5. expdp utility used which is caled by dbms_datapump
procudure
6. remapping capabilities during import
[REMAP_DATAFILE,EMAP_SCHEMA,REMAP_TABLESPACE,REUSE_DATAFILES
]
| Is This Answer Correct ? | 30 Yes | 7 No |
Post New Answer View All Answers
How to determine who is and change the owner of database?
What are the ways to tune reporting services?
What are the various types of relationships in database? Define them.
What are the different technologies used to access Database from Visual Basic?
8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?
Explain what are the two types of oltp?
What is a file in a database?
What is implicit cursor in dbms?
What is query in database?
Is sql a database?
What is the largest component of a database?
Mention the types of join?
All questions related to Control m monitoring tool
Describe the difference between data and database administration.
Where is the data stored in a database?
