what is datapump? Difference between exp and expdp?
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
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
Why dbms is used?
how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping
What do you understand by cursor?
Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com
What is a field in database?
Define and explain about progress?
What is 2nf in database?
What is blob database?
What are different types of joins in sql?
Describe why operational and informational systems are separate.
What is cold backup and hot backup (in case of oracle)?
What are the different types of languages that are available in the dbms?
What are the different levels of abstraction in the dbms?
I have a table which has lot of inserts, is it a good database design to create indexes on that table?