Tema: SELECT * FROM TABLE666 que más necesito para hacer un backup 100% fiable?
Ver Mensaje Individual
  #6 (permalink)  
Antiguo 19/09/2017, 05:10
Avatar de AVBorland
AVBorland
 
Fecha de Ingreso: marzo-2016
Ubicación: Moscu
Mensajes: 42
Antigüedad: 8 años, 7 meses
Puntos: 4
Respuesta: SELECT * FROM TABLE666 que más necesito para hacer un backup 100% fiable?
Código BASH: 
Ver original
  1. c:\Work\wrk_dir>expdp t2/t2 directory=tmp_dr file=dmp.dmp
  2.  
  3. Export: Release 11.2.0.1.0 - Production on Tue Sep 19 14:08:43 2017
  4.  
  5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
  6.  
  7. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
  8. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  9. Legacy Mode Active due to the following parameters:
  10. Legacy Mode Parameter: "file=dmp.dmp" Location: Command Line, Replaced with: "dumpfile=dmp.dmp"
  11. Legacy Mode has set reuse_dumpfiles=true parameter.
  12. Starting "T2"."SYS_EXPORT_SCHEMA_01":  t2/******** directory=tmp_dr dumpfile=dmp.dmp reuse_dumpfiles=true
  13. Estimate in progress using BLOCKS method...
  14. Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
  15. Total estimation using BLOCKS method: 128 KB
  16. Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
  17. Processing object type SCHEMA_EXPORT/TABLE/TABLE
  18. Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
  19. Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
  20. Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
  21. Processing object type SCHEMA_EXPORT/TABLE/COMMENT
  22. . . exported "T2"."TEST_TABLE"                           69.00 KB    8192 rows
  23. Master table "T2"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
  24. ******************************************************************************
  25. Dump file set for T2.SYS_EXPORT_SCHEMA_01 is:
  26.   C:\WORK\DMP.DMP
  27. Job "T2"."SYS_EXPORT_SCHEMA_01" successfully completed at 14:10:41
  28.  
  29. c:\Work\wrk_dir>dir c:\work
  30.  Том в устройстве C имеет метку Windows
  31.  Серийный номер тома: 7E97-8931
  32.  
  33.  Содержимое папки c:\work
  34.  
  35. 19.09.2017  14:09    <DIR>          .
  36. 19.09.2017  14:09    <DIR>          ..
  37. [B][I]19.09.2017  14:10           217*088 DMP.DMP[/I][/B]
  38. 27.04.2017  16:18    <DIR>          Documentum
  39. 19.09.2017  14:10             1*527 export.log
  40. 19.06.2017  09:49    <DIR>          SUV
  41. 19.09.2017  10:37    <DIR>          wrk_dir
  42. 14.07.2017  15:36    <DIR>          &#1040;СДОУ
  43.                2 &#1092;айлов        218*615 байт
  44.                6 &#1087;апок  244*064*333*824 байт свободно
  45.  
  46. c:\Work\wrk_dir>