Objectives
After completing this lesson,you should be able to:
- Describe ways to move data
- Create and use directory objects
- Use SQL*Loader to load data from a non-Oracle database(or user files)
- Use external tables to move data via platform-independent files
- Explain the general architecture of Oracle Data Pump
- Use Data Pump Export and Import to move data between Oracle database
Moving Data:General Architecture
数据泵的作用
- 生产库导出到测试库
- 数据库导出到其他类型的数据库
- 导出元数据(数据库对象的原始定义)
- 跨平台的移植(windows->linux)
- 实现数据升级(10g数据升级到11g数据)
- 性能调优(表碎片太多,通过数据泵先将数据导出,然后删除原始对象,再创建新对象,最后通过数据泵导入)