what is datapump? Difference between exp and expdp?
Answers were Sorted based on User's Feedback
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 |
Answer / dba
Here you can see more details..
http://shonythomas.blogspot.in/2012/02/datapump-vs-expimp-difference-or.html
| Is This Answer Correct ? | 1 Yes | 1 No |
What is relational database ? Give me an example !
Is this statement true or false? All databases must be in third normal form?
Define object-oriented model.
what is database
When the SYSTEM TABLESPACE can be made off-line ?
How do you create a database for an organization?
What are two types of data in a database environment?
Which is the most used database?
What is data model in database?
What are the importance of partitioning in dbms?
What are the 4 types of database?
What is entity and its types?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)