Data Pump es el utilitario utilizado para generar respaldos multiplaforma en una base de datos Oracle. Independientemente de que tengas respaldos implementados con RMAN con todas o algunas de las características, es necesario contar con un "Plan B", que te permita recuperar tu base de datos, en un equipo con una arquitectura distinta a la cuál utilizas el día de hoy.
Se ha hablado muchas cosas de Data Pump, la mayor parte de usuarios desconocen las enormes ventajas de rendimiento que esta herramienta a incorporado a las labores de respaldos desde la versión 10g.
Este post no esta dedicado a hablar sobre las ventajas de Data Pump, las cuáles pueden ser observadas en el capítulo de la documentación oficial de Oracle en el link https://docs.oracle.com/database/121/SUTIL/dp_overview.htm#SUTIL100.
He hecho una comparación de tan sólo una de las virtudes de Data Pump, como lo es el nivel de compresión. Mis pruebas me permiten afirmar que Data Pump 12c, es un 11.6% mejor a la hora de comprimir el archivo generado como producto de una exportación de datos, que su antecesor 11g.
Las pruebas fueron realizadas en la edición Enterprise Edition, la cuál contiene mayores "características" que la versión "Standard Edition"; sin embargo, es realmente impactante los resultados obtenidos, que llegan a ser mejores que los niveles de compresión que se registran con el utilitario GZIP del sistema operativo.
A continuación podrán seguir paso a paso, el test realizado y ver los resultados resumen obtenidos.
| Tamaño | Porcentaje | 11g | Dif con 12c | ||
| Expdp Normal sin compresión | 48140288 | 100 | % Compresión | % Compresión | |
| Expdp Normal con compresión | 6586368 | 13,7 | 86,318 | 74,67 | 11,648 |
| gzip -cv9 | 6715604 | 14,0 | 86,050 | 86,5 | |
| gzip -cv1 | 8671021 | 18,0 | 81,988 | 82,7 |
[oracle@dbvisit01 respaldos]$ ls -la
total 68496
drwxr-xr-x. 2 oracle oinstall 4096 Jan 15 12:08 .
dr-xr-xr-x. 27 root root 4096 Jan 15 11:12 ..
-rw-r--r--. 1 oracle oinstall 8671021 Jan 15 11:28 ejemplo3_cv1.zip
-rw-r--r--. 1 oracle oinstall 6715604 Jan 15 11:26 ejemplo3_cv9.zip
-rw-r-----. 1 oracle oinstall 6586368 Jan 15 12:04 ejemplo3.dmp
-rw-r-----. 1 oracle oinstall 48140288 Jan 15 12:02 ejemplo.dmp
-rw-r--r--. 1 oracle oinstall 7547 Jan 15 12:04 export.log
[oracle@dbvisit01 respaldos]$ expdp system/oracle DIRECTORY=EXP_DMP dumpfile=ejemplo3.dmp schemas=SH compression=none
Export: Release 12.1.0.2.0 - Production on Thu Jan 15 12:03:09 2015
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** DIRECTORY=EXP_DMP dumpfile=ejemplo3.dmp schemas=SH compression=none
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 274.9 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/BITMAP_INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW
Processing object type SCHEMA_EXPORT/DIMENSION
. . exported "SH"."CUSTOMERS" 10.27 MB 55500 rows
. . exported "SH"."COSTS":"COSTS_Q1_1998" 139.6 KB 4411 rows
. . exported "SH"."COSTS":"COSTS_Q1_1999" 183.7 KB 5884 rows
. . exported "SH"."COSTS":"COSTS_Q1_2000" 120.7 KB 3772 rows
. . exported "SH"."COSTS":"COSTS_Q1_2001" 228.0 KB 7328 rows
. . exported "SH"."COSTS":"COSTS_Q2_1998" 79.68 KB 2397 rows
. . exported "SH"."COSTS":"COSTS_Q2_1999" 132.7 KB 4179 rows
. . exported "SH"."COSTS":"COSTS_Q2_2000" 119.1 KB 3715 rows
. . exported "SH"."COSTS":"COSTS_Q2_2001" 184.7 KB 5882 rows
. . exported "SH"."COSTS":"COSTS_Q3_1998" 131.3 KB 4129 rows
. . exported "SH"."COSTS":"COSTS_Q3_1999" 137.5 KB 4336 rows
. . exported "SH"."COSTS":"COSTS_Q3_2000" 151.6 KB 4798 rows
. . exported "SH"."COSTS":"COSTS_Q3_2001" 234.6 KB 7545 rows
. . exported "SH"."COSTS":"COSTS_Q4_1998" 144.8 KB 4577 rows
. . exported "SH"."COSTS":"COSTS_Q4_1999" 159.2 KB 5060 rows
. . exported "SH"."COSTS":"COSTS_Q4_2000" 160.4 KB 5088 rows
. . exported "SH"."COSTS":"COSTS_Q4_2001" 278.5 KB 9011 rows
. . exported "SH"."SALES":"SALES_Q1_1998" 1.413 MB 43687 rows
. . exported "SH"."SALES":"SALES_Q1_1999" 2.071 MB 64186 rows
. . exported "SH"."SALES":"SALES_Q1_2000" 2.012 MB 62197 rows
. . exported "SH"."SALES":"SALES_Q1_2001" 1.965 MB 60608 rows
. . exported "SH"."SALES":"SALES_Q2_1998" 1.160 MB 35758 rows
. . exported "SH"."SALES":"SALES_Q2_1999" 1.754 MB 54233 rows
. . exported "SH"."SALES":"SALES_Q2_2000" 1.802 MB 55515 rows
. . exported "SH"."SALES":"SALES_Q2_2001" 2.051 MB 63292 rows
. . exported "SH"."SALES":"SALES_Q3_1998" 1.634 MB 50515 rows
. . exported "SH"."SALES":"SALES_Q3_1999" 2.166 MB 67138 rows
. . exported "SH"."SALES":"SALES_Q3_2000" 1.910 MB 58950 rows
. . exported "SH"."SALES":"SALES_Q3_2001" 2.130 MB 65769 rows
. . exported "SH"."SALES":"SALES_Q4_1998" 1.581 MB 48874 rows
. . exported "SH"."SALES":"SALES_Q4_1999" 2.014 MB 62388 rows
. . exported "SH"."SALES":"SALES_Q4_2000" 1.814 MB 55984 rows
. . exported "SH"."SALES":"SALES_Q4_2001" 2.258 MB 69749 rows
. . exported "SH"."SUPPLEMENTARY_DEMOGRAPHICS" 697.6 KB 4500 rows
. . exported "SH"."FWEEK_PSCAT_SALES_MV" 419.9 KB 11266 rows
. . exported "SH"."PROMOTIONS" 59.17 KB 503 rows
. . exported "SH"."TIMES" 381.7 KB 1826 rows
. . exported "SH"."CAL_MONTH_SALES_MV" 6.382 KB 48 rows
. . exported "SH"."CHANNELS" 7.414 KB 5 rows
. . exported "SH"."COUNTRIES" 10.46 KB 23 rows
. . exported "SH"."DIMENSION_EXCEPTIONS" 0 KB 0 rows
. . exported "SH"."PRODUCTS" 26.72 KB 72 rows
. . exported "SH"."T" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_1995" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_1996" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_H1_1997" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_H2_1997" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q1_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q1_2003" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q2_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q2_2003" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q3_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q3_2003" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q4_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q4_2003" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_1995" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_1996" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_H1_1997" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_H2_1997" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q1_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q1_2003" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q2_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q2_2003" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q3_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q3_2003" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q4_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q4_2003" 0 KB 0 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/respaldos/ejemplo.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Thu Jan 15 12:02:42 2015 elapsed 0 00:01:21
[oracle@dbvisit01 respaldos]$ expdp system/oracle DIRECTORY=EXP_DMP dumpfile=ejemplo3.dmp schemas=SH compression=all
Export: Release 12.1.0.2.0 - Production on Thu Jan 15 12:03:09 2015
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** DIRECTORY=EXP_DMP dumpfile=ejemplo3.dmp schemas=SH compression=all
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 274.9 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/BITMAP_INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW
Processing object type SCHEMA_EXPORT/DIMENSION
. . exported "SH"."CUSTOMERS" 2.260 MB 55500 rows
. . exported "SH"."COSTS":"COSTS_Q1_1998" 32.57 KB 4411 rows
. . exported "SH"."COSTS":"COSTS_Q1_1999" 44.15 KB 5884 rows
. . exported "SH"."COSTS":"COSTS_Q1_2000" 28.01 KB 3772 rows
. . exported "SH"."COSTS":"COSTS_Q1_2001" 52.73 KB 7328 rows
. . exported "SH"."COSTS":"COSTS_Q2_1998" 20.11 KB 2397 rows
. . exported "SH"."COSTS":"COSTS_Q2_1999" 29.98 KB 4179 rows
. . exported "SH"."COSTS":"COSTS_Q2_2000" 25.95 KB 3715 rows
. . exported "SH"."COSTS":"COSTS_Q2_2001" 42.92 KB 5882 rows
. . exported "SH"."COSTS":"COSTS_Q3_1998" 30.49 KB 4129 rows
. . exported "SH"."COSTS":"COSTS_Q3_1999" 30.46 KB 4336 rows
. . exported "SH"."COSTS":"COSTS_Q3_2000" 35.58 KB 4798 rows
. . exported "SH"."COSTS":"COSTS_Q3_2001" 53.40 KB 7545 rows
. . exported "SH"."COSTS":"COSTS_Q4_1998" 33.91 KB 4577 rows
. . exported "SH"."COSTS":"COSTS_Q4_1999" 36.82 KB 5060 rows
. . exported "SH"."COSTS":"COSTS_Q4_2000" 38.71 KB 5088 rows
. . exported "SH"."COSTS":"COSTS_Q4_2001" 60.15 KB 9011 rows
. . exported "SH"."SALES":"SALES_Q1_1998" 137.7 KB 43687 rows
. . exported "SH"."SALES":"SALES_Q1_1999" 196.8 KB 64186 rows
. . exported "SH"."SALES":"SALES_Q1_2000" 177.1 KB 62197 rows
. . exported "SH"."SALES":"SALES_Q1_2001" 184.9 KB 60608 rows
. . exported "SH"."SALES":"SALES_Q2_1998" 109.5 KB 35758 rows
. . exported "SH"."SALES":"SALES_Q2_1999" 160.6 KB 54233 rows
. . exported "SH"."SALES":"SALES_Q2_2000" 156.8 KB 55515 rows
. . exported "SH"."SALES":"SALES_Q2_2001" 183.3 KB 63292 rows
. . exported "SH"."SALES":"SALES_Q3_1998" 148.9 KB 50515 rows
. . exported "SH"."SALES":"SALES_Q3_1999" 194.2 KB 67138 rows
. . exported "SH"."SALES":"SALES_Q3_2000" 170.6 KB 58950 rows
. . exported "SH"."SALES":"SALES_Q3_2001" 194.7 KB 65769 rows
. . exported "SH"."SALES":"SALES_Q4_1998" 146.2 KB 48874 rows
. . exported "SH"."SALES":"SALES_Q4_1999" 183.3 KB 62388 rows
. . exported "SH"."SALES":"SALES_Q4_2000" 163.3 KB 55984 rows
. . exported "SH"."SALES":"SALES_Q4_2001" 216.2 KB 69749 rows
. . exported "SH"."SUPPLEMENTARY_DEMOGRAPHICS" 187.7 KB 4500 rows
. . exported "SH"."FWEEK_PSCAT_SALES_MV" 85.28 KB 11266 rows
. . exported "SH"."PROMOTIONS" 15.40 KB 503 rows
. . exported "SH"."TIMES" 47.69 KB 1826 rows
. . exported "SH"."CAL_MONTH_SALES_MV" 5.218 KB 48 rows
. . exported "SH"."CHANNELS" 5.289 KB 5 rows
. . exported "SH"."COUNTRIES" 6.125 KB 23 rows
. . exported "SH"."DIMENSION_EXCEPTIONS" 0 KB 0 rows
. . exported "SH"."PRODUCTS" 9.117 KB 72 rows
. . exported "SH"."T" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_1995" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_1996" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_H1_1997" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_H2_1997" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q1_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q1_2003" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q2_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q2_2003" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q3_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q3_2003" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q4_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q4_2003" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_1995" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_1996" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_H1_1997" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_H2_1997" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q1_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q1_2003" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q2_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q2_2003" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/BITMAP_INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW
Processing object type SCHEMA_EXPORT/DIMENSION
. . exported "SH"."CUSTOMERS" 10.27 MB 55500 rows
. . exported "SH"."COSTS":"COSTS_Q1_1998" 139.6 KB 4411 rows
. . exported "SH"."COSTS":"COSTS_Q1_1999" 183.7 KB 5884 rows
. . exported "SH"."COSTS":"COSTS_Q1_2000" 120.7 KB 3772 rows
. . exported "SH"."COSTS":"COSTS_Q1_2001" 228.0 KB 7328 rows
. . exported "SH"."COSTS":"COSTS_Q2_1998" 79.68 KB 2397 rows
. . exported "SH"."COSTS":"COSTS_Q2_1999" 132.7 KB 4179 rows
. . exported "SH"."COSTS":"COSTS_Q2_2000" 119.1 KB 3715 rows
. . exported "SH"."COSTS":"COSTS_Q2_2001" 184.7 KB 5882 rows
. . exported "SH"."COSTS":"COSTS_Q3_1998" 131.3 KB 4129 rows
. . exported "SH"."COSTS":"COSTS_Q3_1999" 137.5 KB 4336 rows
. . exported "SH"."COSTS":"COSTS_Q3_2000" 151.6 KB 4798 rows
. . exported "SH"."COSTS":"COSTS_Q3_2001" 234.6 KB 7545 rows
. . exported "SH"."COSTS":"COSTS_Q4_1998" 144.8 KB 4577 rows
. . exported "SH"."COSTS":"COSTS_Q4_1999" 159.2 KB 5060 rows
. . exported "SH"."COSTS":"COSTS_Q4_2000" 160.4 KB 5088 rows
. . exported "SH"."COSTS":"COSTS_Q4_2001" 278.5 KB 9011 rows
. . exported "SH"."SALES":"SALES_Q1_1998" 1.413 MB 43687 rows
. . exported "SH"."SALES":"SALES_Q1_1999" 2.071 MB 64186 rows
. . exported "SH"."SALES":"SALES_Q1_2000" 2.012 MB 62197 rows
. . exported "SH"."SALES":"SALES_Q1_2001" 1.965 MB 60608 rows
. . exported "SH"."SALES":"SALES_Q2_1998" 1.160 MB 35758 rows
. . exported "SH"."SALES":"SALES_Q2_1999" 1.754 MB 54233 rows
. . exported "SH"."SALES":"SALES_Q2_2000" 1.802 MB 55515 rows
. . exported "SH"."SALES":"SALES_Q2_2001" 2.051 MB 63292 rows
. . exported "SH"."SALES":"SALES_Q3_1998" 1.634 MB 50515 rows
. . exported "SH"."SALES":"SALES_Q3_1999" 2.166 MB 67138 rows
. . exported "SH"."SALES":"SALES_Q3_2000" 1.910 MB 58950 rows
. . exported "SH"."SALES":"SALES_Q3_2001" 2.130 MB 65769 rows
. . exported "SH"."SALES":"SALES_Q4_1998" 1.581 MB 48874 rows
. . exported "SH"."SALES":"SALES_Q4_1999" 2.014 MB 62388 rows
. . exported "SH"."SALES":"SALES_Q4_2000" 1.814 MB 55984 rows
. . exported "SH"."SALES":"SALES_Q4_2001" 2.258 MB 69749 rows
. . exported "SH"."SUPPLEMENTARY_DEMOGRAPHICS" 697.6 KB 4500 rows
. . exported "SH"."FWEEK_PSCAT_SALES_MV" 419.9 KB 11266 rows
. . exported "SH"."PROMOTIONS" 59.17 KB 503 rows
. . exported "SH"."TIMES" 381.7 KB 1826 rows
. . exported "SH"."CAL_MONTH_SALES_MV" 6.382 KB 48 rows
. . exported "SH"."CHANNELS" 7.414 KB 5 rows
. . exported "SH"."COUNTRIES" 10.46 KB 23 rows
. . exported "SH"."DIMENSION_EXCEPTIONS" 0 KB 0 rows
. . exported "SH"."PRODUCTS" 26.72 KB 72 rows
. . exported "SH"."T" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_1995" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_1996" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_H1_1997" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_H2_1997" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q1_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q1_2003" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q2_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q2_2003" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q3_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q3_2003" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q4_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q4_2003" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_1995" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_1996" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_H1_1997" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_H2_1997" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q1_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q1_2003" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q2_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q2_2003" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q3_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q3_2003" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q4_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q4_2003" 0 KB 0 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/respaldos/ejemplo.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Thu Jan 15 12:02:42 2015 elapsed 0 00:01:21
[oracle@dbvisit01 respaldos]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Thu Jan 15 12:14:50 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL>
No hay comentarios:
Publicar un comentario
Te agradezco tus comentarios. Te esperamos de vuelta.