使用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:

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