原文:
Question: What are the Differences between Data Pump impdp and import utility? I know that import does the same things as impdp, but I'm not clear on the differences.
Answer: The original import utility dates back to the earliest releases of Oracle, and it's quite slow and primitive compared to Data Pump. While the old import (imp) and Data Pump import (impdp) do the same thing, they are completely different utilities, with different syntax and characteristics.
Here are the major syntax differences between import and Data Pump impdp:
- Data Pump does not use the BUFFERS parameter
- Data Pump export represents the data in XML format
- A Data Pump schema import will recreate the user and execute all of the associated security privileges (grants, user password history).
- Data Pump's parallel processing feature is dynamic. You can connect to a Data Pump job that is currently running and dynamically alter the number of parallel processes.
- Data Pump will recreate the user, whereas the old imp utility required the DBA to create the user ID before importing.
中文:
IMP为早版的Oralce使用的导入命令,与impdp命令相比导入数据是非常缓慢的,虽然imp和impdp都是在做相同的事情,但是他们是完全不同的语法和特征;
1、数数据泵不采用缓冲区参数
2、数据泵倒出的是XML格式
3、数据泵将重新架构导入的用户和执行所有相关的权限
4、数据泵并行处理是动态的,你可以连接到当前正在运行的数据泵作业和和同台改变的并行进程数量
5、数据泵将重新创建用户,而imp必须使用sys用户登陆提前创建用户