Data Pump in 11g ; New parameters

August 24th, 2010 | Posted in Blog, datapump 11g | No Comments



Data Pump in 11g
This article is an overview of some of the new Data pump parameters in 11g Oracle Database.

ENCRYPTION

Oracle Database 11g presents Data Pump Encryption parameters. This is a mechanism to encrypt the metadata only or the Data only or the columns only or all (metadata & data & Columns).
To use the encryption you should specify either the ENCRYPTION or the ENCRYPTION_PASSWORD parameter.
Data pump encryption is specified by the encryption parameter, the algorithm of the encryption and the mode of the encryption.

ENCRYPTION Parameter:
Following is an example:


Data Pump in 11g
This article is an overview of some of the new Data pump parameters in 11g Oracle Database.

ENCRYPTION

Oracle Database 11g presents Data Pump Encryption parameters. This is a mechanism to encrypt the metadata only or the Data only or the columns only or all (metadata & data & Columns).
To use the encryption you should specify either the ENCRYPTION or the ENCRYPTION_PASSWORD parameter.
Data pump encryption is specified by the encryption parameter, the algorithm of the encryption and the mode of the encryption.

ENCRYPTION Parameter:
Following is an example:


Data Pump in 11g
This article is an overview of some of the new Data pump parameters in 11g Oracle Database.

ENCRYPTION

Oracle Database 11g presents Data Pump Encryption parameters. This is a mechanism to encrypt the metadata only or the Data only or the columns only or all (metadata & data & Columns).
To use the encryption you should specify either the ENCRYPTION or the ENCRYPTION_PASSWORD parameter.
Data pump encryption is specified by the encryption parameter, the algorithm of the encryption and the mode of the encryption.

ENCRYPTION Parameter:
Following is an example:


Data Pump in 11g
This article is an overview of some of the new Data pump parameters in 11g Oracle Database.

ENCRYPTION

Oracle Database 11g presents Data Pump Encryption parameters. This is a mechanism to encrypt the metadata only or the Data only or the columns only or all (metadata & data & Columns).
To use the encryption you should specify either the ENCRYPTION or the ENCRYPTION_PASSWORD parameter.
Data pump encryption is specified by the encryption parameter, the algorithm of the encryption and the mode of the encryption.

ENCRYPTION Parameter:
Following is an example:


Data Pump in 11g
This article is an overview of some of the new Data pump parameters in 11g Oracle Database.

ENCRYPTION

Oracle Database 11g presents Data Pump Encryption parameters. This is a mechanism to encrypt the metadata only or the Data only or the columns only or all (metadata & data & Columns).
To use the encryption you should specify either the ENCRYPTION or the ENCRYPTION_PASSWORD parameter.
Data pump encryption is specified by the encryption parameter, the algorithm of the encryption and the mode of the encryption.

ENCRYPTION Parameter:
Following is an example:
C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:encrypt.db.dmp ENCRYPTION=metadata_only ENCRYPTION_PASSWORD=WISSEM

ENCRYPTION_ALGORITHM Parameter:
This parameter is to specify the cryptographic algorithm: {AES128 | AES192 | AES256}

C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:encrypt.db.dmp ENCRYPTION=metadata_only ENCRYPTION_PASSWORD=WISSEM ENCRYPTION_ALGORITHM=AES256

ENCRYPTION_MODE Parameter:
It Specifies the type of security to use when encryption and decryption are performed.
ENCRYPTION_MODE = {DUAL | PASSWORD | TRANSPARENT}

C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:encrypt.db.dmp ENCRYPTION=metadata_only ENCRYPTION_PASSWORD=WISSEM ENCRYPTION_ALGORITHM=AES256 ENCRYPTION_MODE=dual

COMPRESSION

Oracle Database 11g presents Data Pump compression. This is a mechanism to compress both metadata and Data.

Following is how to use it:
C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 14:48:56
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Iniciando “SYS”.”SYS_EXPORT_FULL_01″: full=yes userid=”/******** AS SYSDBA” dumpfile=DATA_PUMP_DIR:full.db1.dmp compression=ALL
Estimaci¾n en curso mediante el mÚtodo BLOCKS…
Procesando el tipo de objeto DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Estimaci¾n total mediante el mÚtodo BLOCKS: 152.2 MB
Procesando el tipo de objeto DATABASE_EXPORT/TABLESPACE
Procesando el tipo de objeto DATABASE_EXPORT/PROFILE
……
Procesando el tipo de objeto DATABASE_EXPORT/SYS_USER/USER
La tabla maestra “SYS”.”SYS_EXPORT_FULL_01″ se ha cargado/descargado correctamente
******************************************************************************
El juego de archivos de volcado para SYS.SYS_EXPORT_FULL_01 es:
F:\APP\ORAWISS\ADMIN\ORAWISS\DPDUMP\FULL.DB.DMP
El trabajo “SYS”.”SYS_EXPORT_FULL_01″ ha terminado correctamente en 14:46:43

REUSE DUMP FILE

When the export attempts to write to a dump file that already exists. You will have following error:
C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 14:47:47
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: valor de argumento no vßlido
ORA-39000: especificaci¾n de archivo de volcado err¾nea
ORA-31641: no se ha podido crear el archivo de volcado “F:\app\orawiss\admin\orawiss\dpdump\full.db.dmp”
ORA-27038: el archivo creado ya existe
OSD-04010: opci┐CREATE> especificada; el archivo ya existe
To fix this you should use the option REUSE_DUMPFILES=y; this is a new parameter that allow the overwrite of the existing dump file.

C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL REUSE_DUMPFILES=y

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 14:51:36
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Iniciando “SYS”.”SYS_EXPORT_FULL_02″: full=yes userid=”/******** AS SYSDBA” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL REUSE_DUMPFILES=y
Estimaci¾n en curso mediante el mÚtodo BLOCKS…
Procesando el tipo de objeto DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
…..
******************************************************************************
El juego de archivos de volcado para SYS.SYS_EXPORT_FULL_02 es:
F:\APP\ORAWISS\ADMIN\ORAWISS\DPDUMP\FULL.DB.DMP
El trabajo “SYS”.”SYS_EXPORT_FULL_02″ ha terminado correctamente en 15:02:01
C:\Documents and Settings\welkhlifi>

REMAPPING DATA

The REMAP_DATA parameter allows you to remap a column value as a parameter and return a modified version of the data using a packaged function.

Following is how to use it:
– Function used by the remap created under sys user for example:
Create or replace package Translare_package
as
function modify_salary ( p_salary NUMBER) return NUMBER;
end;
/
Create or replace package body Translare_package as
function modify_salary (p_salary NUMBER) return NUMBER
as
v_return NUMBER;
begin
v_return:= p_salary * 2;
return v_return;
end;
end;
/

C:\Documents and Settings\welkhlifi>expdp userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:hr.salary.dmp compression=ALL REUSE_DUMPFILES=y TABLES=hr.employees REMAP_DATA=hr.employees.salary:SYS.Translare_package.modify_salary

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 15:18:27
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Iniciando “SYS”.”SYS_EXPORT_TABLE_01″: userid=”/******** AS SYSDBA” dumpfile=DA
TA_PUMP_DIR:hr.salary.dmp compression=ALL REUSE_DUMPFILES=y TABLES=hr.employees
REMAP_DATA=hr.employees.salary:SYS.Translare_package.modify_salary
Estimaci¾n en curso mediante el mÚtodo BLOCKS…
Procesando el tipo de objeto TABLE_EXPORT/TABLE/TABLE_DATA
Estimaci¾n total mediante el mÚtodo BLOCKS: 64 KB
Procesando el tipo de objeto TABLE_EXPORT/TABLE/TABLE
Procesando el tipo de objeto TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/INDEX/INDEX
Procesando el tipo de objeto TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Procesando el tipo de objeto TABLE_EXPORT/TABLE/COMMENT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/TRIGGER
Procesando el tipo de objeto TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . “HR”.”EMPLOYEES” 8.765 KB 107 filas exportadas
La tabla maestra “SYS”.”SYS_EXPORT_TABLE_01″ se ha cargado/descargado correctame
nte
******************************************************************************
El juego de archivos de volcado para SYS.SYS_EXPORT_TABLE_01 es:
F:\APP\ORAWISS\ADMIN\ORAWISS\DPDUMP\HR.SALARY.DMP
El trabajo “SYS”.”SYS_EXPORT_TABLE_01″ ha terminado correctamente en 15:18:44
C:\Documents and Settings\welkhlifi>

RENAMING TABLES DURING EXPORT OR IMPORT

You can rename the table during the import process.
Following is how to use it:

C:\Documents and Settings\welkhlifi>impdp userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp REMAP_TABLE=hr.employees:employees2
Import: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 15:23:18
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
….

IGNORE NO DEFERRED CONSTRAINTS

Set the DATA options parameter to SKIP_CONSTRAINT_ERRORS will cause the import program to skip errors generated by the no deferred database constraints.
Following is how to use it:

C:\Documents and Settings\welkhlifi>impdp userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp tables=HR.JOBS data_options=SKIP_CONSTRAINT_ERRORS

Nice Reading
Wissem C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:encrypt.db.dmp ENCRYPTION=metadata_only ENCRYPTION_PASSWORD=WISSEM

ENCRYPTION_ALGORITHM Parameter:
This parameter is to specify the cryptographic algorithm: {AES128 | AES192 | AES256}

C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:encrypt.db.dmp ENCRYPTION=metadata_only ENCRYPTION_PASSWORD=WISSEM ENCRYPTION_ALGORITHM=AES256

ENCRYPTION_MODE Parameter:
It Specifies the type of security to use when encryption and decryption are performed.
ENCRYPTION_MODE = {DUAL | PASSWORD | TRANSPARENT}

C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:encrypt.db.dmp ENCRYPTION=metadata_only ENCRYPTION_PASSWORD=WISSEM ENCRYPTION_ALGORITHM=AES256 ENCRYPTION_MODE=dual

COMPRESSION

Oracle Database 11g presents Data Pump compression. This is a mechanism to compress both metadata and Data.

Following is how to use it:
C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 14:48:56
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Iniciando “SYS”.”SYS_EXPORT_FULL_01″: full=yes userid=”/******** AS SYSDBA” dumpfile=DATA_PUMP_DIR:full.db1.dmp compression=ALL
Estimaci¾n en curso mediante el mÚtodo BLOCKS…
Procesando el tipo de objeto DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Estimaci¾n total mediante el mÚtodo BLOCKS: 152.2 MB
Procesando el tipo de objeto DATABASE_EXPORT/TABLESPACE
Procesando el tipo de objeto DATABASE_EXPORT/PROFILE
……
Procesando el tipo de objeto DATABASE_EXPORT/SYS_USER/USER
La tabla maestra “SYS”.”SYS_EXPORT_FULL_01″ se ha cargado/descargado correctamente
******************************************************************************
El juego de archivos de volcado para SYS.SYS_EXPORT_FULL_01 es:
F:\APP\ORAWISS\ADMIN\ORAWISS\DPDUMP\FULL.DB.DMP
El trabajo “SYS”.”SYS_EXPORT_FULL_01″ ha terminado correctamente en 14:46:43

REUSE DUMP FILE

When the export attempts to write to a dump file that already exists. You will have following error:
C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 14:47:47
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: valor de argumento no vßlido
ORA-39000: especificaci¾n de archivo de volcado err¾nea
ORA-31641: no se ha podido crear el archivo de volcado “F:\app\orawiss\admin\orawiss\dpdump\full.db.dmp”
ORA-27038: el archivo creado ya existe
OSD-04010: opci┐CREATE> especificada; el archivo ya existe
To fix this you should use the option REUSE_DUMPFILES=y; this is a new parameter that allow the overwrite of the existing dump file.

C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL REUSE_DUMPFILES=y

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 14:51:36
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Iniciando “SYS”.”SYS_EXPORT_FULL_02″: full=yes userid=”/******** AS SYSDBA” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL REUSE_DUMPFILES=y
Estimaci¾n en curso mediante el mÚtodo BLOCKS…
Procesando el tipo de objeto DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
…..
******************************************************************************
El juego de archivos de volcado para SYS.SYS_EXPORT_FULL_02 es:
F:\APP\ORAWISS\ADMIN\ORAWISS\DPDUMP\FULL.DB.DMP
El trabajo “SYS”.”SYS_EXPORT_FULL_02″ ha terminado correctamente en 15:02:01
C:\Documents and Settings\welkhlifi>

REMAPPING DATA

The REMAP_DATA parameter allows you to remap a column value as a parameter and return a modified version of the data using a packaged function.

Following is how to use it:
– Function used by the remap created under sys user for example:
Create or replace package Translare_package
as
function modify_salary ( p_salary NUMBER) return NUMBER;
end;
/
Create or replace package body Translare_package as
function modify_salary (p_salary NUMBER) return NUMBER
as
v_return NUMBER;
begin
v_return:= p_salary * 2;
return v_return;
end;
end;
/

C:\Documents and Settings\welkhlifi>expdp userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:hr.salary.dmp compression=ALL REUSE_DUMPFILES=y TABLES=hr.employees REMAP_DATA=hr.employees.salary:SYS.Translare_package.modify_salary

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 15:18:27
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Iniciando “SYS”.”SYS_EXPORT_TABLE_01″: userid=”/******** AS SYSDBA” dumpfile=DA
TA_PUMP_DIR:hr.salary.dmp compression=ALL REUSE_DUMPFILES=y TABLES=hr.employees
REMAP_DATA=hr.employees.salary:SYS.Translare_package.modify_salary
Estimaci¾n en curso mediante el mÚtodo BLOCKS…
Procesando el tipo de objeto TABLE_EXPORT/TABLE/TABLE_DATA
Estimaci¾n total mediante el mÚtodo BLOCKS: 64 KB
Procesando el tipo de objeto TABLE_EXPORT/TABLE/TABLE
Procesando el tipo de objeto TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/INDEX/INDEX
Procesando el tipo de objeto TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Procesando el tipo de objeto TABLE_EXPORT/TABLE/COMMENT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/TRIGGER
Procesando el tipo de objeto TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . “HR”.”EMPLOYEES” 8.765 KB 107 filas exportadas
La tabla maestra “SYS”.”SYS_EXPORT_TABLE_01″ se ha cargado/descargado correctame
nte
******************************************************************************
El juego de archivos de volcado para SYS.SYS_EXPORT_TABLE_01 es:
F:\APP\ORAWISS\ADMIN\ORAWISS\DPDUMP\HR.SALARY.DMP
El trabajo “SYS”.”SYS_EXPORT_TABLE_01″ ha terminado correctamente en 15:18:44
C:\Documents and Settings\welkhlifi>

RENAMING TABLES DURING EXPORT OR IMPORT

You can rename the table during the import process.
Following is how to use it:

C:\Documents and Settings\welkhlifi>impdp userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp REMAP_TABLE=hr.employees:employees2
Import: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 15:23:18
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
….

IGNORE NO DEFERRED CONSTRAINTS

Set the DATA options parameter to SKIP_CONSTRAINT_ERRORS will cause the import program to skip errors generated by the no deferred database constraints.
Following is how to use it:

C:\Documents and Settings\welkhlifi>impdp userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp tables=HR.JOBS data_options=SKIP_CONSTRAINT_ERRORS

Nice Reading
Wissem C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:encrypt.db.dmp ENCRYPTION=metadata_only ENCRYPTION_PASSWORD=WISSEM

ENCRYPTION_ALGORITHM Parameter:
This parameter is to specify the cryptographic algorithm: {AES128 | AES192 | AES256}

C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:encrypt.db.dmp ENCRYPTION=metadata_only ENCRYPTION_PASSWORD=WISSEM ENCRYPTION_ALGORITHM=AES256

ENCRYPTION_MODE Parameter:
It Specifies the type of security to use when encryption and decryption are performed.
ENCRYPTION_MODE = {DUAL | PASSWORD | TRANSPARENT}

C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:encrypt.db.dmp ENCRYPTION=metadata_only ENCRYPTION_PASSWORD=WISSEM ENCRYPTION_ALGORITHM=AES256 ENCRYPTION_MODE=dual

COMPRESSION

Oracle Database 11g presents Data Pump compression. This is a mechanism to compress both metadata and Data.

Following is how to use it:
C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 14:48:56
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Iniciando “SYS”.”SYS_EXPORT_FULL_01″: full=yes userid=”/******** AS SYSDBA” dumpfile=DATA_PUMP_DIR:full.db1.dmp compression=ALL
Estimaci¾n en curso mediante el mÚtodo BLOCKS…
Procesando el tipo de objeto DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Estimaci¾n total mediante el mÚtodo BLOCKS: 152.2 MB
Procesando el tipo de objeto DATABASE_EXPORT/TABLESPACE
Procesando el tipo de objeto DATABASE_EXPORT/PROFILE
……
Procesando el tipo de objeto DATABASE_EXPORT/SYS_USER/USER
La tabla maestra “SYS”.”SYS_EXPORT_FULL_01″ se ha cargado/descargado correctamente
******************************************************************************
El juego de archivos de volcado para SYS.SYS_EXPORT_FULL_01 es:
F:\APP\ORAWISS\ADMIN\ORAWISS\DPDUMP\FULL.DB.DMP
El trabajo “SYS”.”SYS_EXPORT_FULL_01″ ha terminado correctamente en 14:46:43

REUSE DUMP FILE

When the export attempts to write to a dump file that already exists. You will have following error:
C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 14:47:47
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: valor de argumento no vßlido
ORA-39000: especificaci¾n de archivo de volcado err¾nea
ORA-31641: no se ha podido crear el archivo de volcado “F:\app\orawiss\admin\orawiss\dpdump\full.db.dmp”
ORA-27038: el archivo creado ya existe
OSD-04010: opci┐CREATE> especificada; el archivo ya existe
To fix this you should use the option REUSE_DUMPFILES=y; this is a new parameter that allow the overwrite of the existing dump file.

C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL REUSE_DUMPFILES=y

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 14:51:36
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Iniciando “SYS”.”SYS_EXPORT_FULL_02″: full=yes userid=”/******** AS SYSDBA” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL REUSE_DUMPFILES=y
Estimaci¾n en curso mediante el mÚtodo BLOCKS…
Procesando el tipo de objeto DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
…..
******************************************************************************
El juego de archivos de volcado para SYS.SYS_EXPORT_FULL_02 es:
F:\APP\ORAWISS\ADMIN\ORAWISS\DPDUMP\FULL.DB.DMP
El trabajo “SYS”.”SYS_EXPORT_FULL_02″ ha terminado correctamente en 15:02:01
C:\Documents and Settings\welkhlifi>

REMAPPING DATA

The REMAP_DATA parameter allows you to remap a column value as a parameter and return a modified version of the data using a packaged function.

Following is how to use it:
– Function used by the remap created under sys user for example:
Create or replace package Translare_package
as
function modify_salary ( p_salary NUMBER) return NUMBER;
end;
/
Create or replace package body Translare_package as
function modify_salary (p_salary NUMBER) return NUMBER
as
v_return NUMBER;
begin
v_return:= p_salary * 2;
return v_return;
end;
end;
/

C:\Documents and Settings\welkhlifi>expdp userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:hr.salary.dmp compression=ALL REUSE_DUMPFILES=y TABLES=hr.employees REMAP_DATA=hr.employees.salary:SYS.Translare_package.modify_salary

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 15:18:27
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Iniciando “SYS”.”SYS_EXPORT_TABLE_01″: userid=”/******** AS SYSDBA” dumpfile=DA
TA_PUMP_DIR:hr.salary.dmp compression=ALL REUSE_DUMPFILES=y TABLES=hr.employees
REMAP_DATA=hr.employees.salary:SYS.Translare_package.modify_salary
Estimaci¾n en curso mediante el mÚtodo BLOCKS…
Procesando el tipo de objeto TABLE_EXPORT/TABLE/TABLE_DATA
Estimaci¾n total mediante el mÚtodo BLOCKS: 64 KB
Procesando el tipo de objeto TABLE_EXPORT/TABLE/TABLE
Procesando el tipo de objeto TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/INDEX/INDEX
Procesando el tipo de objeto TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Procesando el tipo de objeto TABLE_EXPORT/TABLE/COMMENT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/TRIGGER
Procesando el tipo de objeto TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . “HR”.”EMPLOYEES” 8.765 KB 107 filas exportadas
La tabla maestra “SYS”.”SYS_EXPORT_TABLE_01″ se ha cargado/descargado correctame
nte
******************************************************************************
El juego de archivos de volcado para SYS.SYS_EXPORT_TABLE_01 es:
F:\APP\ORAWISS\ADMIN\ORAWISS\DPDUMP\HR.SALARY.DMP
El trabajo “SYS”.”SYS_EXPORT_TABLE_01″ ha terminado correctamente en 15:18:44
C:\Documents and Settings\welkhlifi>

RENAMING TABLES DURING EXPORT OR IMPORT

You can rename the table during the import process.
Following is how to use it:

C:\Documents and Settings\welkhlifi>impdp userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp REMAP_TABLE=hr.employees:employees2
Import: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 15:23:18
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
….

IGNORE NO DEFERRED CONSTRAINTS

Set the DATA options parameter to SKIP_CONSTRAINT_ERRORS will cause the import program to skip errors generated by the no deferred database constraints.
Following is how to use it:

C:\Documents and Settings\welkhlifi>impdp userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp tables=HR.JOBS data_options=SKIP_CONSTRAINT_ERRORS

Nice Reading
Wissem C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:encrypt.db.dmp ENCRYPTION=metadata_only ENCRYPTION_PASSWORD=WISSEM

ENCRYPTION_ALGORITHM Parameter:
This parameter is to specify the cryptographic algorithm: {AES128 | AES192 | AES256}

C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:encrypt.db.dmp ENCRYPTION=metadata_only ENCRYPTION_PASSWORD=WISSEM ENCRYPTION_ALGORITHM=AES256

ENCRYPTION_MODE Parameter:
It Specifies the type of security to use when encryption and decryption are performed.
ENCRYPTION_MODE = {DUAL | PASSWORD | TRANSPARENT}

C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:encrypt.db.dmp ENCRYPTION=metadata_only ENCRYPTION_PASSWORD=WISSEM ENCRYPTION_ALGORITHM=AES256 ENCRYPTION_MODE=dual

COMPRESSION

Oracle Database 11g presents Data Pump compression. This is a mechanism to compress both metadata and Data.

Following is how to use it:
C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 14:48:56
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Iniciando “SYS”.”SYS_EXPORT_FULL_01″: full=yes userid=”/******** AS SYSDBA” dumpfile=DATA_PUMP_DIR:full.db1.dmp compression=ALL
Estimaci¾n en curso mediante el mÚtodo BLOCKS…
Procesando el tipo de objeto DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Estimaci¾n total mediante el mÚtodo BLOCKS: 152.2 MB
Procesando el tipo de objeto DATABASE_EXPORT/TABLESPACE
Procesando el tipo de objeto DATABASE_EXPORT/PROFILE
……
Procesando el tipo de objeto DATABASE_EXPORT/SYS_USER/USER
La tabla maestra “SYS”.”SYS_EXPORT_FULL_01″ se ha cargado/descargado correctamente
******************************************************************************
El juego de archivos de volcado para SYS.SYS_EXPORT_FULL_01 es:
F:\APP\ORAWISS\ADMIN\ORAWISS\DPDUMP\FULL.DB.DMP
El trabajo “SYS”.”SYS_EXPORT_FULL_01″ ha terminado correctamente en 14:46:43

REUSE DUMP FILE

When the export attempts to write to a dump file that already exists. You will have following error:
C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 14:47:47
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: valor de argumento no vßlido
ORA-39000: especificaci¾n de archivo de volcado err¾nea
ORA-31641: no se ha podido crear el archivo de volcado “F:\app\orawiss\admin\orawiss\dpdump\full.db.dmp”
ORA-27038: el archivo creado ya existe
OSD-04010: opci┐CREATE> especificada; el archivo ya existe
To fix this you should use the option REUSE_DUMPFILES=y; this is a new parameter that allow the overwrite of the existing dump file.

C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL REUSE_DUMPFILES=y

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 14:51:36
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Iniciando “SYS”.”SYS_EXPORT_FULL_02″: full=yes userid=”/******** AS SYSDBA” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL REUSE_DUMPFILES=y
Estimaci¾n en curso mediante el mÚtodo BLOCKS…
Procesando el tipo de objeto DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
…..
******************************************************************************
El juego de archivos de volcado para SYS.SYS_EXPORT_FULL_02 es:
F:\APP\ORAWISS\ADMIN\ORAWISS\DPDUMP\FULL.DB.DMP
El trabajo “SYS”.”SYS_EXPORT_FULL_02″ ha terminado correctamente en 15:02:01
C:\Documents and Settings\welkhlifi>

REMAPPING DATA

The REMAP_DATA parameter allows you to remap a column value as a parameter and return a modified version of the data using a packaged function.

Following is how to use it:
– Function used by the remap created under sys user for example:
Create or replace package Translare_package
as
function modify_salary ( p_salary NUMBER) return NUMBER;
end;
/
Create or replace package body Translare_package as
function modify_salary (p_salary NUMBER) return NUMBER
as
v_return NUMBER;
begin
v_return:= p_salary * 2;
return v_return;
end;
end;
/

C:\Documents and Settings\welkhlifi>expdp userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:hr.salary.dmp compression=ALL REUSE_DUMPFILES=y TABLES=hr.employees REMAP_DATA=hr.employees.salary:SYS.Translare_package.modify_salary

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 15:18:27
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Iniciando “SYS”.”SYS_EXPORT_TABLE_01″: userid=”/******** AS SYSDBA” dumpfile=DA
TA_PUMP_DIR:hr.salary.dmp compression=ALL REUSE_DUMPFILES=y TABLES=hr.employees
REMAP_DATA=hr.employees.salary:SYS.Translare_package.modify_salary
Estimaci¾n en curso mediante el mÚtodo BLOCKS…
Procesando el tipo de objeto TABLE_EXPORT/TABLE/TABLE_DATA
Estimaci¾n total mediante el mÚtodo BLOCKS: 64 KB
Procesando el tipo de objeto TABLE_EXPORT/TABLE/TABLE
Procesando el tipo de objeto TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/INDEX/INDEX
Procesando el tipo de objeto TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Procesando el tipo de objeto TABLE_EXPORT/TABLE/COMMENT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/TRIGGER
Procesando el tipo de objeto TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . “HR”.”EMPLOYEES” 8.765 KB 107 filas exportadas
La tabla maestra “SYS”.”SYS_EXPORT_TABLE_01″ se ha cargado/descargado correctame
nte
******************************************************************************
El juego de archivos de volcado para SYS.SYS_EXPORT_TABLE_01 es:
F:\APP\ORAWISS\ADMIN\ORAWISS\DPDUMP\HR.SALARY.DMP
El trabajo “SYS”.”SYS_EXPORT_TABLE_01″ ha terminado correctamente en 15:18:44
C:\Documents and Settings\welkhlifi>

RENAMING TABLES DURING EXPORT OR IMPORT

You can rename the table during the import process.
Following is how to use it:

C:\Documents and Settings\welkhlifi>impdp userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp REMAP_TABLE=hr.employees:employees2
Import: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 15:23:18
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
….

IGNORE NO DEFERRED CONSTRAINTS

Set the DATA options parameter to SKIP_CONSTRAINT_ERRORS will cause the import program to skip errors generated by the no deferred database constraints.
Following is how to use it:

C:\Documents and Settings\welkhlifi>impdp userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp tables=HR.JOBS data_options=SKIP_CONSTRAINT_ERRORS

Nice Reading
Wissem C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:encrypt.db.dmp ENCRYPTION=metadata_only ENCRYPTION_PASSWORD=WISSEM

ENCRYPTION_ALGORITHM Parameter:
This parameter is to specify the cryptographic algorithm: {AES128 | AES192 | AES256}

C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:encrypt.db.dmp ENCRYPTION=metadata_only ENCRYPTION_PASSWORD=WISSEM ENCRYPTION_ALGORITHM=AES256

ENCRYPTION_MODE Parameter:
It Specifies the type of security to use when encryption and decryption are performed.
ENCRYPTION_MODE = {DUAL | PASSWORD | TRANSPARENT}

C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:encrypt.db.dmp ENCRYPTION=metadata_only ENCRYPTION_PASSWORD=WISSEM ENCRYPTION_ALGORITHM=AES256 ENCRYPTION_MODE=dual

COMPRESSION

Oracle Database 11g presents Data Pump compression. This is a mechanism to compress both metadata and Data.

Following is how to use it:
C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 14:48:56
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Iniciando “SYS”.”SYS_EXPORT_FULL_01″: full=yes userid=”/******** AS SYSDBA” dumpfile=DATA_PUMP_DIR:full.db1.dmp compression=ALL
Estimaci¾n en curso mediante el mÚtodo BLOCKS…
Procesando el tipo de objeto DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Estimaci¾n total mediante el mÚtodo BLOCKS: 152.2 MB
Procesando el tipo de objeto DATABASE_EXPORT/TABLESPACE
Procesando el tipo de objeto DATABASE_EXPORT/PROFILE
……
Procesando el tipo de objeto DATABASE_EXPORT/SYS_USER/USER
La tabla maestra “SYS”.”SYS_EXPORT_FULL_01″ se ha cargado/descargado correctamente
******************************************************************************
El juego de archivos de volcado para SYS.SYS_EXPORT_FULL_01 es:
F:\APP\ORAWISS\ADMIN\ORAWISS\DPDUMP\FULL.DB.DMP
El trabajo “SYS”.”SYS_EXPORT_FULL_01″ ha terminado correctamente en 14:46:43

REUSE DUMP FILE

When the export attempts to write to a dump file that already exists. You will have following error:
C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 14:47:47
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: valor de argumento no vßlido
ORA-39000: especificaci¾n de archivo de volcado err¾nea
ORA-31641: no se ha podido crear el archivo de volcado “F:\app\orawiss\admin\orawiss\dpdump\full.db.dmp”
ORA-27038: el archivo creado ya existe
OSD-04010: opci┐CREATE> especificada; el archivo ya existe
To fix this you should use the option REUSE_DUMPFILES=y; this is a new parameter that allow the overwrite of the existing dump file.

C:\Documents and Settings\welkhlifi>expdp full=yes userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL REUSE_DUMPFILES=y

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 14:51:36
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Iniciando “SYS”.”SYS_EXPORT_FULL_02″: full=yes userid=”/******** AS SYSDBA” dumpfile=DATA_PUMP_DIR:full.db.dmp compression=ALL REUSE_DUMPFILES=y
Estimaci¾n en curso mediante el mÚtodo BLOCKS…
Procesando el tipo de objeto DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
…..
******************************************************************************
El juego de archivos de volcado para SYS.SYS_EXPORT_FULL_02 es:
F:\APP\ORAWISS\ADMIN\ORAWISS\DPDUMP\FULL.DB.DMP
El trabajo “SYS”.”SYS_EXPORT_FULL_02″ ha terminado correctamente en 15:02:01
C:\Documents and Settings\welkhlifi>

REMAPPING DATA

The REMAP_DATA parameter allows you to remap a column value as a parameter and return a modified version of the data using a packaged function.

Following is how to use it:
– Function used by the remap created under sys user for example:
Create or replace package Translare_package
as
function modify_salary ( p_salary NUMBER) return NUMBER;
end;
/
Create or replace package body Translare_package as
function modify_salary (p_salary NUMBER) return NUMBER
as
v_return NUMBER;
begin
v_return:= p_salary * 2;
return v_return;
end;
end;
/

C:\Documents and Settings\welkhlifi>expdp userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:hr.salary.dmp compression=ALL REUSE_DUMPFILES=y TABLES=hr.employees REMAP_DATA=hr.employees.salary:SYS.Translare_package.modify_salary

Export: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 15:18:27
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Iniciando “SYS”.”SYS_EXPORT_TABLE_01″: userid=”/******** AS SYSDBA” dumpfile=DA
TA_PUMP_DIR:hr.salary.dmp compression=ALL REUSE_DUMPFILES=y TABLES=hr.employees
REMAP_DATA=hr.employees.salary:SYS.Translare_package.modify_salary
Estimaci¾n en curso mediante el mÚtodo BLOCKS…
Procesando el tipo de objeto TABLE_EXPORT/TABLE/TABLE_DATA
Estimaci¾n total mediante el mÚtodo BLOCKS: 64 KB
Procesando el tipo de objeto TABLE_EXPORT/TABLE/TABLE
Procesando el tipo de objeto TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/INDEX/INDEX
Procesando el tipo de objeto TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Procesando el tipo de objeto TABLE_EXPORT/TABLE/COMMENT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Procesando el tipo de objeto TABLE_EXPORT/TABLE/TRIGGER
Procesando el tipo de objeto TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . “HR”.”EMPLOYEES” 8.765 KB 107 filas exportadas
La tabla maestra “SYS”.”SYS_EXPORT_TABLE_01″ se ha cargado/descargado correctame
nte
******************************************************************************
El juego de archivos de volcado para SYS.SYS_EXPORT_TABLE_01 es:
F:\APP\ORAWISS\ADMIN\ORAWISS\DPDUMP\HR.SALARY.DMP
El trabajo “SYS”.”SYS_EXPORT_TABLE_01″ ha terminado correctamente en 15:18:44
C:\Documents and Settings\welkhlifi>

RENAMING TABLES DURING EXPORT OR IMPORT

You can rename the table during the import process.
Following is how to use it:

C:\Documents and Settings\welkhlifi>impdp userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp REMAP_TABLE=hr.employees:employees2
Import: Release 11.1.0.7.0 – Production on Viernes, 20 Agosto, 2010 15:23:18
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Conectado a: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
….

IGNORE NO DEFERRED CONSTRAINTS

Set the DATA options parameter to SKIP_CONSTRAINT_ERRORS will cause the import program to skip errors generated by the no deferred database constraints.
Following is how to use it:

C:\Documents and Settings\welkhlifi>impdp userid=”‘/ as sysdba’” dumpfile=DATA_PUMP_DIR:full.db.dmp tables=HR.JOBS data_options=SKIP_CONSTRAINT_ERRORS

Nice Reading
Wissem



No Comments to “Data Pump in 11g ; New parameters”

There are no comments yet, add one below.


Leave a Comment





Polls

which oracle topic interests you most?

View Results

Loading ... Loading ...


Oracle Class Tweets


Recent Posts


Recent Comments

  • Adrian Iriarte: Saludos, Que buen articulo, casi siempre al momento de querer implementar soluciones para el...
  • Patricia: Hi Wissem, is there a workaround for this? I mean I want to use the sqlnet.authentication_services =none,...
  • Brian: I created the cdb manually using the instruction, but then I tried to create pdb within in, it failed. have...
  • Farmer Johnson: Hi Wissem. How did you avoid the error you had previsouly encountered: “sudo opatch auto...
  • Héctor Moro: Querido Nelson; Después de entrevistar a mas de 50 profesionales de primer nivel en Uruguay, al fin te...
  • What is NO2 Maximus: I genuinely apрreciated your site! You shoulԁ update it wiϳth new info!
  • Nav: Indeed helpful, to the point article..
  • Koti: Can you please explain all the sections of AWR report in RAC. I mean to ask output produced by awrgrpt.sql...
  • Himanshu: Nice post.can you please comment on this Why RMAN restored the DATA_REORTING datafie to +DATA diskgroup?
  • Enrique: Great post.
  • gabriel: what version of sqldeveloper support plugable database?
  • Kal: Quality – thanks…
  • wissem: Well , like I mentioned in the post, delete service and add service using IP.
  • Kelly: were you able to solve this? Thanks!
  • wissem: Hello, You can buy the book from PakT: http://www.packtpub.com/oracle -data-guard-11gr2-administr...
  • goutham: hi i want to buy this book.could you please let me know how can i buy this book. i am in Malaysia. thanks...
  • cesar Lopez: Hola me gustaria saber tu punto de vista de MYSQl vs ORACLE para una sistema de Nomina de unos 1500...
  • wissem: Check my previous article in English; Oracle 12c: RMAN recover Table http://www.oracle-class.com/?p =2866
  • NILESH: Sir, English please
  • Ramakrishna: I want step by step installation of Hyper-table in windows and also usage of Hyper-table like data...

Oracle-Class Forums Latest Activity