Exportación completa Aca miramos todo el LOG de Exportacion con el siguiente comando.

Oscar FarfanTarea29 de Abril de 2017

28.410 Palabras (114 Páginas)299 Visitas

Página 1 de 114

Exportacion

Creamos el directorio BACKUP

[pic 1]

Creamos la carpeta de Backup en C:

[pic 2]

[pic 3]

PERMISOS DIRECTORIOS DE BACKUP

[pic 4]

Otorgamos los permisos de lectura y escritura dentro del Directorio

[pic 5]

VERIFICAR LOS DIRECTORIOS CREADOS

[pic 6]

Exportación completa Aca miramos todo el LOG de Exportacion con el siguiente comando.

$ expdp userid=system/BDatos*2017 dumpfile=copia_oracle_export.dmp logfile=copia_oracle_export.log directory=CARPETA_BACKUP full=y;

;;;

Export: Release 11.2.0.2.0 - Production on Mié Abr 19 07:01:50 2017

;;;

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

Starting "SYSTEM"."SYS_EXPORT_FULL_01": userid=system/******** dumpfile=copia_oracle_export.dmp logfile=copia_oracle_export.log directory=CARPETA_BACKUP full=y

Estimate in progress using BLOCKS method...

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 162.5 MB

Processing object type DATABASE_EXPORT/TABLESPACE

Processing object type DATABASE_EXPORT/PROFILE

Processing object type DATABASE_EXPORT/SYS_USER/USER

Processing object type DATABASE_EXPORT/SCHEMA/USER

Processing object type DATABASE_EXPORT/ROLE

Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT

Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT

Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT

Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE

Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA

Processing object type DATABASE_EXPORT/RESOURCE_COST

Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK

Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK

Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE

Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY

Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type DATABASE_EXPORT/CONTEXT

Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM

Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM

Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC

Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM

Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ

Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM

Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT

Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC

Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION

Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE

Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC

Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION

Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE

Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW

Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER

Processing object type DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW

Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ

Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA

Processing object type DATABASE_EXPORT/AUDIT

. . exported "APEX_040000"."WWV_FLOW_PAGE_PLUGS" 27.16 MB 38892 rows

. . exported "APEX_040000"."WWV_FLOW_STEP_ITEMS" 19.41 MB 46584 rows

. . exported "APEX_040000"."WWV_FLOW_STEP_PROCESSING" 11.27 MB 10220 rows

. . exported "APEX_040000"."WWV_FLOW_WORKSHEETS" 4.562 MB 1496 rows

. . exported "APEX_040000"."WWV_FLOW_STEPS" 4.286 MB 8780 rows

. . exported "APEX_040000"."WWV_FLOW_STEP_ITEM_HELP" 5.121 MB 29004 rows

. . exported "APEX_040000"."WWV_FLOW_REGION_REPORT_COLUMN" 4.215 MB 26720 rows

. . exported "APEX_040000"."WWV_FLOW_WORKSHEET_COLUMNS" 3.871 MB 16952 rows

. . exported "APEX_040000"."WWV_FLOW_TEMPLATES" 2.458 MB 484 rows

. . exported "APEX_040000"."WWV_FLOW_LIST_ITEMS" 2.830 MB 14256 rows

. . exported "APEX_040000"."WWV_FLOW_STEP_BUTTONS" 2.923 MB 18756 rows

. . exported "APEX_040000"."WWV_FLOW_STEP_VALIDATIONS" 2.936 MB 9340 rows

. . exported "APEX_040000"."WWV_FLOW_LIST_OF_VALUES_DATA" 2.349 MB 24092 rows

. . exported "APEX_040000"."WWV_FLOW_MESSAGES$" 1.839 MB 19840 rows

. . exported "APEX_040000"."WWV_FLOW_STEP_BRANCHES" 2.305 MB 14464 rows

. . exported "APEX_040000"."WWV_FLOW_LIST_TEMPLATES" 928.2 KB 772 rows

. . exported "APEX_040000"."WWV_FLOW_PAGE_PLUG_TEMPLATES" 1.530 MB 1684 rows

. . exported "APEX_040000"."WWV_FLOW_FLASH_MAP_REGIONS" 836.8 KB 13891 rows

. . exported "APEX_040000"."WWV_FLOW_LISTS_OF_VALUES$" 1.172 MB 5796 rows

. . exported "APEX_040000"."WWV_FLOW_MENU_OPTIONS" 909.1 KB 7824 rows

. . exported "APEX_040000"."WWV_FLOW_STEP_COMPUTATIONS" 1.230 MB 4940 rows

. . exported "APEX_040000"."WWV_FLOW_ROW_TEMPLATES" 482.7 KB 500 rows

. . exported "APEX_040000"."WWV_FLOW_PROCESSING" 585.6 KB 284 rows

. . exported "APEX_040000"."WWV_FLOW_PAGE_DA_ACTIONS" 408.9 KB 2844 rows

. . exported "APEX_040000"."WWV_FLOW_CUSTOM_AUTH_SETUPS" 44.28 KB 76 rows

. . exported "APEX_040000"."WWV_FLOW_BUTTON_TEMPLATES" 170.4 KB 428 rows

. . exported "APEX_040000"."WWV_FLOW_LISTS" 221.7 KB 2904 rows

. . exported "APEX_040000"."WWV_FLOW_FLASH_CHART5_SERIES" 112.6 KB 100 rows

. . exported "APEX_040000"."WWV_FLOW_PAGE_DA_EVENTS" 176.7 KB 1224 rows

. . exported "APEX_040000"."WWV_FLOW_PLUGIN_ATTRIBUTES" 170.5 KB 476 rows

. . exported "APEX_040000"."WWV_FLOW_PLUGINS" 140.9 KB 212 rows

. . exported "APEX_040000"."WWV_FLOW_SHORTCUTS" 112.7 KB 216 rows

. . exported "APEX_040000"."WWV_DEMO_DEPT" 8.335 KB 5 rows

. . exported "APEX_040000"."WWV_FLOW_FLASH_CHARTS_5" 99.37 KB 88 rows

. . exported "APEX_040000"."WWV_FLOW_RANDOM_IMAGES" 50.37 KB 42 rows

. . exported "APEX_040000"."WWV_FLOW_REGION_UPD_RPT_COLS" 124.6 KB 1853 rows

...

Descargar como (para miembros actualizados) txt (109 Kb) pdf (852 Kb) docx (133 Kb)

Leer 113 páginas más »

Leer documento completo Guardar

Disponible sólo en Clubensayos.com