您现在的位置: 精品资料网 >> 管理信息化 >> 信息化方案 >> 资料信息

使用orcle的导出程序(pdf 20页)

所属分类:
信息化方案
文件大小:
106 KB
下载地址:
相关资料:
使用,程序
使用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:

..............................