Exportar dados exp ou expdp – GPO (Grupo de Profissionais Oracle)

25 de outubro de 2013 às 8:38 pm #106075

Regis Araujo

Participante

@Fabio

Boa tarde Mestre, td tranquilo??

Somente um adendo, creio que você quis dizer 10G ou superior correto?

[oracle@dbaregis10g ~]$ expdp -help


Export: Release 10.2.0.4.0 - 64bit Production on Friday, 25 October, 2013 14:34:55
Copyright (c) 2003, 2007, Oracle.  All rights reserved.
The Data Pump export utility provides a mechanism for transferring data objects

between Oracle databases. The utility is invoked with the following command:
Example: expdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp
You can control how Export runs by entering the 'expdp' command followed

by various parameters. To specify parameters, you use keywords:
Format:  expdp KEYWORD=value or KEYWORD=(value1,value2,...,valueN)

   Example: expdp scott/tiger DUMPFILE=scott.dmp DIRECTORY=dmpdir SCHEMAS=scott

               or TABLES=(T1:P1,T1:P2), if T1 is partitioned table
USERID must be the first parameter on the command line.
Keyword               Description (Default)
ATTACH                Attach to existing job, e.g. ATTACH [=job name].

COMPRESSION           Reduce size of dumpfile contents where valid

                      keyword values are: (METADATA_ONLY) and NONE.

CONTENT               Specifies data to unload where the valid keywords are:

                      (ALL), DATA_ONLY, and METADATA_ONLY.

Abraços..!

Regis Araujo