使用orcle的导出程序(pdf 20页)
使用orcle的导出程序(pdf 20页)内容简介
Oracle’s Export utility allows you to extract data from a
database and write that data to an operating system
file. Together with the Import utility, which you will read about
in the next chapter, this provides you with a convenient way
to move data between databases. You can export an entire
database, or you can choose to limit the export to objects
owned by a specific user or to a specific list of tables. This
chapter discusses how you can use the Export utility and all
of its options to export data to operating system files.
Using Oracle8i’s Export Utility
The file to which you extract data when you use Oracle8i’s
Export utility is referred to as a dump file. Export’s dump files
contain both metadata and data. Metadata refers to the data
definition language (DDL) statements necessary to re-create
the objects that have been exported. If you export your entire
database, for example, the dump file will contain CREATE
TABLE statements, GRANT statements, and everything else
necessary to re-create your database. Some of the more
important uses for the Export utility include the following:
..............................
database and write that data to an operating system
file. Together with the Import utility, which you will read about
in the next chapter, this provides you with a convenient way
to move data between databases. You can export an entire
database, or you can choose to limit the export to objects
owned by a specific user or to a specific list of tables. This
chapter discusses how you can use the Export utility and all
of its options to export data to operating system files.
Using Oracle8i’s Export Utility
The file to which you extract data when you use Oracle8i’s
Export utility is referred to as a dump file. Export’s dump files
contain both metadata and data. Metadata refers to the data
definition language (DDL) statements necessary to re-create
the objects that have been exported. If you export your entire
database, for example, the dump file will contain CREATE
TABLE statements, GRANT statements, and everything else
necessary to re-create your database. Some of the more
important uses for the Export utility include the following:
..............................
上一篇:代码标准文档(pdf 12页)
用户登陆
信息化方案热门资料
信息化方案相关下载