Shulou(Shulou.com)06/01 Report--

EXPDP Introduction

A tool for importing data and metadata using dump file sets. Dump filesets can only be imported by IMPDP. A dump file set consists of table data, database object metadata, and control information. Written in a proprietary binary format. These dump files are written by server, not client, so there must be a Create Directory object to define where the files are stored. such as

CREATE DIRECTORY lzl_dir AS '/home/oracle'; -Create directory definition

GRANT READ, WRITE ON DIRECTORY lzl_dir TO scott; -Grant user directory permissions

View directories via dba_directories view

SQL> select * from dba_directories;

OWNER DIRECTORY_NAME DIRECTORY_PATH

-------- ------------------------------ ----------------------------------------

SYS ORACLE_OCM_CONFIG_DIR/u01/app/oracle/product/11.2/ccr/state

SYS DATA_PUMP_DIR/u01/app/oracle/admin/test/dpdump/

SYS XMLDIR /u01/app/oracle/product/11.2/rdbms/xml

SYS LZL_DIR/home/oracle

directory has been created by default in the database

EXPDP can export a subset of the metadata in the dump file, depending on how it is exported.

Note: Try not to use as sysdba, because sysdba involves core applications and special features, which are somewhat different from ordinary users.

derived modes

Export modes are specified by parameters in the command and include the following modes:

"Full Export Mode"

To export the entire database, specify the FULL parameter, which requires the DATAPUMP_EXP_FULL_DATABASE role.

"Schema Mode"? Specify shemas parameter Export specified schema, Export multiple schemas Must have DATAPUMP_EXP_FULL_DATABASE role If there is no such role, you can only export your own schema. SYS schema cannot be exported. The DATAPUMP_EXP_FULL_DATABASE role is required if you want to export tables that are not your own.

"Table Mode"? Export specified tables, and objects they depend on, using the tables parameter

"Tablespace Mode"? Use the tablespaces parameter to specify the objects stored in the exported tablespaces.

Transportable Tablespace Mode uses the TRANSPORT_TABLESPACES parameter to specify metadata and associated objects for tables in the exported tablespaces. Encrypted columns cannot use this pattern. If timezone is used, the source and target timezones must be equal.

Multiple system schemas cannot be exported, including SYS, ORDSYS, MDSYS.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.