For a complete description of the parameters available in the command-line interface, see Parameters Available in Export's Command-Line Mode. You can interact with Data Pump Export by using a command line, a parameter file, or an interactive-command mode.Ĭommand-Line Interface: Enables you to specify most of the Export parameters directly on the command line. To see some examples of the various ways in which you can use Data Pump Export, refer to Examples of Using Data Pump Export. This is done using data filters and metadata filters, which are specified through Export parameters. See Default Locations for Dump, Log, and SQL Files for more information about directory objects.ĭata Pump Export enables you to specify that a job should move a subset of the data and metadata, as determined by the export mode. During an import operation, the Data Pump Import utility uses these files to locate each database object in the dump file set.īecause the dump files are written by the server, rather than by the client, the data base administrator (DBA) must create directory objects. The files are written in a proprietary, binary format. The dump file set is made up of one or more disk files that contain table data, database object metadata, and control information. The dump file set can be imported on the same system or it can be moved to another system and loaded there. The dump file set can be imported only by the Data Pump Import utility.
See Chapter 19, "Original Export and Import" for a description of the original Export utility.ĭata Pump Export (hereinafter referred to as Export for ease of reading) is a utility for unloading data and metadata into a set of operating system files called a dump file set. Although its functionality and its parameters are similar to those of the original Export utility ( exp), they are completely separate utilities and their files are not compatible. Data Pump Export (invoked with the expdp command) is a new utility as of Oracle Database 10 g.
0 kommentar(er)
