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 |
I want to export the data date to date from oracle database then what can i do?
what is s/w lifecycle?
What is oracle block? Can two oracle blocks have the same address?
select Nth highest salary by using rownum
4 Answers Ford, TCS, Tech Mahindra,
i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com
What are the advantages and disadvantages of views in the database?
What are the importance of partitioning in dbms?
Mention the different types of cursor?
What is different keys in dbms?
What are 3 types of databases?
What are indexes? What are b-trees?
Can you explain the select into statement?
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)