Only metadata is written to the dump file set in encrypted format. Only encrypted columns are written to the dump file set in encrypted format. Only data is written to the dump file set in encrypted format. ALLĮnable encryption for all data and metadata in the export operation. Specify what to encrypt in the dump file set. The table containing the column to be remapped.Ī PL/SQL package function which is called to modify the data for the specified column. The schema containing the column to be remapped. Specify a percentage for sampling the data blocks to be moved. Specify a subquery that is added to the end of the SELECT statement for the table. Choose the Object Type and specify the Name Clause. Include or Exclude a set of objects from the Export operation. If you select TABLE mode, choose the schema in the Export Schema(Table Mode) drop-down list.Īdd dump files to the dump file set for the export. Unload only database object definitions no table row data is unloaded. Unload only table row data no database object definitions are unloaded. All specified tables must reside in a single schema. You must have the EXP_FULL_DATABASE role to specify tables that are not in your own schema. In table mode, only a specified set of tables, partitions, and their dependent objects are unloaded. If you do not have the EXP_FULL_DATABASE role, you can export only your own schema. If you have the EXP_FULL_DATABASE role, then you can specify a list of schemas and optionally include the schema definitions themselves, as well as system privilege grants to those schemas. Both object metadata and data are unloaded. If a table is unloaded, its dependent objects are also unloaded. In tablespace mode, only the tables contained in a specified set of tablespaces are unloaded. This mode requires that you have the EXP_FULL_DATABASE role. In a full database export, the entire database is unloaded. To show the hidden tabs (advanced options), check the Show Advanced Options box. Hint: The profiles(.exp) are saved under the Settings Location. You can save the Data Pump Export settings to a profile. Then, you can click Execute button to run it. Before execute the Data Pump Export, click Generate SQL button to review the SQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |