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 |
Enlist some commands of dml?
What is database join?
How is view stored in database?
What are the factors causing the reparsing of SQL statements in SGA?
How to Ensure Data Integrity in a Relational Database?
What are records and fields in a database?
What are different partitioning techniques in database?
Which is fastest database?
How to select the first record in a given set of rows?
What are the features of rdbms?
Where is the database stored?
what is the difference between two and three-tier architectures?
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)