![]() The first line specifies the user and password ( userid) for connecting to the Oracle database.Second, create a parameter file named customer.par with the following contents and place the file in the C:\export directory: this parameter file: expdpĬode language: SQL (Structured Query Language) ( sql ) Oracle Data Pump Export exampleįirst, create a new directory object ot_external that maps to the c:\export folder: CREATE DIRECTORY ot_external AS 'C:\export' Ĭode language: SQL (Structured Query Language) ( sql ) The behaviors of the program are determined by the parameters specified either on the command line or in a parameter file. You invoke the Data Pump Export program using the expdp command. Using a subquery to export partial data.Here are some notable features of the Oracle Data Pump Export tool: ![]() According to Oracle, the new Data Pump Export can be up to 40 times faster. The Data pump Export is a replacement of the old Export utility. Notice that Oracle introduced the Data Pump Export utility starting in Oracle 10g. The Export Data Pump tool does not write to the local file system on your client computer. The Data Pump Export works on the server only, therefore, it typically deals with directory object that maps to physical directories on the database server. The dump file set contains table data, database object metadata, and control information that are written in an Oracle-proprietary, binary format. The dump file set then can be imported by the Data Pump Import utility on the same or another Oracle Database system. Oracle Data Pump Export is a built-in utility program for unloading data and metadata into a set of dump files. ![]() Introduction to Oracle Data Pump Export tool Summary: in this tutorial, you will learn how to use the Oracle Data Pump Export utility to unloading data (and metadata) from the Oracle database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |