expdp五種mode
One of the most significant characteristics of an export operation is its mode, because the mode largely determines what is exported. Export provides different modes for unloading different portions of the database. The available modes are as follows:
· Transportable Tablespace Mode
Full Export Mode
In a full database export, the entire database is unloaded. This mode requires that you have the EXP_FULL_DATABASE role.
Schema Mode
This is the default export mode. 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. If you do not have the EXP_FULL_DATABASE role, you can export only your own schema.
Cross-schema references are not exported unless the referenced schema is also specified in the list of schemas to be exported. For example, a trigger defined on a table within one of the specified schemas, but that resides in a schema not explicitly specified, is not exported.
Table Mode
In table mode, only a specified set of tables, partitions, and their dependent objects are unloaded. You must have the EXP_FULL_DATABASE role to specify tables that are not in your own schema. All specified tables must reside in a single schema.
Note that type definitions for columns are not exported in table mode. It is expected that the type definitions already exist in the target instance at import time. Also, as in schema exports, cross-schema references are not exported.
Tablespace Mode
In tablespace mode, only the tables contained in a specified set of tablespaces are unloaded. If a table is unloaded, its dependent objects are also unloaded. Both object metadata and data are unloaded. In tablespace mode, if any part of a table resides in the specified set, then that table and all of its dependent objects are exported.
Transportable Tablespace Mode
In transportable tablespace mode, only the metadata for the tables (and their dependent objects) within a specified set of tablespaces are unloaded. This allows the tablespace datafiles to then be copied to another Oracle database and incorporated using transportable tablespace import. This mode requires that you have the EXP_FULL_DATABASE role.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25744374/viewspace-721604/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- expdp = exp + direct mode + parallel ?Parallel
- Android Media Framework(五)Tunnel ModeAndroidFramework
- MIPI-DSI 三種 Video Mode 理解IDE
- ASP.NET中Session的sessionState 4種mode模式ASP.NETSession模式
- (四)五種IO模型模型
- 五種編碼模式模式
- 五種網路io模型模型
- 五種傳統IO模型模型
- Java五種儲存位置Java
- android Toast五種特效AndroidAST特效
- Window mode
- consistent mode和current mode的區別
- Oracle expdpOracle
- 五種方法建立java物件,你知道幾種呢?Java物件
- java建立物件的五種方式Java物件
- webpack解惑:require的五種用法WebUI
- REST API的五種規則RESTAPI
- React 中的五種元件形式React元件
- mysql 效能調優五種方式MySql
- angular五種服務詳解Angular
- 五種提高SQL效能的方法SQL
- JavaScript征服Style的五種武器JavaScript
- Nginx 的五種快取方法Nginx快取
- 五種提高 SQL 效能的方法SQL
- Docker Swarm modeDockerSwarm
- oracle time modeOracle
- javascript strict modeJavaScript
- TM LOCK MODE
- sql_modeSQL
- Windws XP Mode
- Dataguard mode switch
- 更改Archive ModeHive
- Undo Mode (30)
- ftp命令 binary mode與ascii mode的區別FTPASCII
- impdp/expdp 示例
- oracle expdp and impdpOracle
- JS的五種函式呼叫方式JS函式
- Redis 的五種資料結構Redis資料結構