SIE - Departamento de Educación de Puerto Rico
Puerto Rico
Department of Education
[pic]
Export data from SIE into the Datawarehouse
Script for Export Data from SIE into the Datawarehouse
7/NOV/2012
|Export Data from SIE into the Datawarehouse Script |
| | |
|Project |Export data from SIE into the Datawarehouse |
Version Information
|Version number |1.0.0 |
|Draft/Final as of |07/November/2012 |
|Printed on |9 November 2012 |
|Author |Ricardo Cortés Huertas |
| |rcortes@ |
|Owner |Vicente Graulau Rosario |
|Last Update By |Ricardo Cortés Huertas |
Document Information
Document source
This document is maintained as an online document. Contact the author for the latest version.
Revision history
|Version Number |Date |Summary of Changes |Revision Marks |
|1.0 |07/Nov/2012 |First version |YES |
| | | | |
Reviews
This document has been reviewed internally by the following people.
|Name |Date of Review |
|Vicente Graulau Rosario/PRDE |07/Nov/2012 |
|Ricardo Cortés Huertas/Intelutions | |
Approvals
This document has been approved by the following people. The signed approval forms are filed in the Project Control Book.
| |Function |Date of Approval |Signature |
| | | | |
| | | | |
| | | | |
| | | | |
|Name | | | |
| | | | |
Distribution
This document has been distributed to:
|Name |Function |
|Vicente Graulau Rosario |PRDE SIE Administrator |
|Ricardo Cortés Huertas |Intellutions Consultant |
| |Sharepoint site |
| | |
Table of Contents
Page
1 Introduction 4
1.1 Objectives 4
2 Export Script Section 5
2.1 SCRIPT export_tables_for_datawarehouse.sh 6
2.2 Log files generated during the process. 6
3 Transfer the compressed file to the datawarehouse server. 12
3.1 Steps for the transfer of the compressed file to the datawarehouse server. 12
Export Data from Sie into the Datawarehouse Script
Introduction
One of the purposes of the Export data from SIE into the Datawarehouse Scripts Project is to provide scripts for the export of specific tables from the SIE (Sistema de Información Estudiantil) into the Datwarehouse.
1 Objectives
The objective of this document is to provide scripts documentation to be used in order to do an export of some data from specific tables from the SIE system into the Datawarehouse. The purpose is to load data in a Data Staging system (DS) to be integrated with other data into an ODS (Operational Data Store) ,the final destination is a Datawarehouse with integrated data. The tables included in the export process are the following:
prod.CE_FAMILY,prod.CE_FAMILY_MEMBER,prod.CE_FAMILY_MEMBER_ETHNIC_CODE,prod.CE_FAMILY_MEMBER_LANGUAGE_CODE,prod.CE_FAMILY_MEMBER_MISC_CODE,prod.CE_FAMILY_MEMBER_SPECIAL_PROG, prod.CE_FAMILY_TO_MEMBER,prod.CE_HOUSE_HEAD,prod.CE_HOUSE_HEAD_PHONE,prod.CE_HOUSE_HEAD_TO_MEMBER,prod.DI_INCIDENT,prod.DI_PARTICIPANT,prod.DI_RESPONSE, prod.ENUM_CE_BIRTH_COUNTRY, prod.ENUM_CE_BIRTH_STATE,prod.ENUM_CE_ETHNIC_CODE,prod.ENUM_CE_LANGUAGE_CODE,prod.ENUM_CE_RELATION_CODE,prod.ENUM_DI_CONTEXT_LOCATION_CODE,prod.ENUM_DI_DISCIPLINE_CODE, prod.ENUM_DI_EVENT_CODE,prod.ENUM_DI_EVENT_LOCATION,prod.ENUM_DI_INJURY_TO_TYPE,prod.ENUM_DI_INJURY_TYPE, prod.ENUM_DI_OTHER_FACTOR_CODE,prod.ENUM_DI_PARTICIPANT_ROLE,prod.ENUM_DI_RESPONSE_CODE,prod.ENUM_DI_WEAPON_CODE,prod.ENUM_ST_CTE_COMPLTR_PROG_CD,prod.ENUM_ST_CTE_FINISHER_CODE,prod.ENUM_ST_END_STATUS_CODE,prod.ENUM_ST_ENTRY_CODE,prod.ENUM_ST_SPECIAL_PRG_CATEGORY,prod.ENUM_ST_YR_IN_9TH_GRADE_CD,prod.ENUM_SY_FLEX_OWNER_TYPE, prod.ENUM_SY_GENDER,prod.ENUM_SY_SCHOOL_GRADE_LEVEL,prod.ENUM_TN_POST_SECONDARY_PLANS,prod.GR_CLASS_GRADE_ENTRY,prod.SC_CLASS,prod.SC_COURSE,prod.SC_COURSE_CATALOG,prod.SC_SCHOOL_SCHEDULING_PARAMS,prod.SC_STUDENT_CLASS_MAPPING,prod.SC_TEACHER_CLASS_ASSIGNMENT,prod.ST_CTE_PROGRAM,prod.ST_ENROLLMENT,prod.ST_STUDENT_GROUP,prod.ST_STUDENT_GROUP_ASSOC,prod.SY_CAMPUS,prod.SY_DISTRICT_ZONE,prod.SY_FLEX_DATA,prod.SY_FLEX_FIELDS_DEF,prod.SY_FLEX_OWNER,prod.SY_SCHOOL,prod.SY_STAFF,prod.SY_STAFF_ASSIGNMENT,prod.TN_TRANSCRIPTS_HEADER,prod.ST_TITLE_I_SERVICE_PROFILE, prod.ENUM_ST_TITLE_I_SERVICES, prod.ENUM_AT_ABSENCE_REASON_CODE, prod.ENUM_AT_TARDY_REASON_CODE, prod.GR_GRADE_PERIOD_DEFINITION, prod.ST_STUDENT_SCHOOL_INFO, prod.DI_INCIDENT_EVENT_CODE, prod.CE_DWELLING, prod.ENUM_CE_DWELLING_TYPE, prod.CE_HOMELESS, prod.ENUM_SY_FLEX_ENUM_DATA, prod.TE_STUDENT_FUTURE_TEST, prod.TE_TEST_DEFINITION, prod.TE_TEST_2_OFFERED_GRADE.
All of the above tables are totally included, except the table prod.AT_DAILY_ATTENDANCE_RECORDS that has a condition to include the rows with the logic of school_year equal 2013 as solicited by the datawarehouse in charge.
Export Script Section
The following section describe the selection of tables from the Schoolmax System to be included in the export process that are necessaries in order to be loaded into the Datawarehouse. Is necessary to connect to the server auohsmaxi76 with the ip 140.85.100.111. That server has the script necessary for the process. Once is connected into the corresponding server the process can be proceed. Is a requirement to be in the directory /DE-PR-CUSTOMER in the server. The process consists of five parts:
a. Change to the directory /DE-PR-CUSTOMER.
b. Export of tables to be put into a single file.
c. Exoort of tables to be put into multiple files.
d. Export of a table with a specific condition to be put into another file.
e. Compression of all the export files to be put into a single compressed file.
Log files are generated during the process. To execute the process is needed to move to the path /DE-PR-CUSTOMER in the server specified above and to change the user to orpmax1o. The entries should be:
A. Enter the user and password for the operating system to the server 140.85.,100.111 using SSH Secure Shell or Putty tools.
B. Switch to the user orpmax1o and enter the following command in the command prompt:
PMAX1O1@auohsmaxi76)/home/c_rcorte>
pbrun orpmax1o
C. Change to the directotory or path DE-PR-CUSTOMER and enter the following command in the command prompt:
(PMAX1O1@auohsmaxi76)/pmax1o/oracle
cd /DE-PR-CUSTOMER
D. Execute the shell script, enter the following command:
./ export_tables_for_datawarehouse.sh and click enter.
E. Once the process finished, the prompt appears again.
(PMAX1O1@auohsmaxi76)/pmax1o/oracle
1 SCRIPT export_tables_for_datawarehouse.sh
cd /DE-PR-CUSTOMER
expdp '"/ as sysdba"' file=datawarehouse_tables.dmp log=datawarehouse_tables.log tables=prod.CE_FAMILY,prod.CE_FAMILY_MEMBER,prod.CE_FAMILY_MEMBER_ETHNIC_CODE,prod.CE_FAMILY_MEMBER_LANGUAGE_CODE,prod.CE_FAMILY_MEMBER_MISC_CODE,prod.CE_FAMILY_MEMBER_SPECIAL_PROG, prod.CE_FAMILY_TO_MEMBER,prod.CE_HOUSE_HEAD,prod.CE_HOUSE_HEAD_PHONE,prod.CE_HOUSE_HEAD_TO_MEMBER,prod.DI_INCIDENT,prod.DI_PARTICIPANT,prod.DI_RESPONSE, prod.ENUM_CE_BIRTH_COUNTRY, prod.ENUM_CE_BIRTH_STATE,prod.ENUM_CE_ETHNIC_CODE,prod.ENUM_CE_LANGUAGE_CODE,prod.ENUM_CE_RELATION_CODE,prod.ENUM_DI_CONTEXT_LOCATION_CODE,prod.ENUM_DI_DISCIPLINE_CODE, prod.ENUM_DI_EVENT_CODE,prod.ENUM_DI_EVENT_LOCATION,prod.ENUM_DI_INJURY_TO_TYPE,prod.ENUM_DI_INJURY_TYPE, prod.ENUM_DI_OTHER_FACTOR_CODE,prod.ENUM_DI_PARTICIPANT_ROLE,prod.ENUM_DI_RESPONSE_CODE,prod.ENUM_DI_WEAPON_CODE,prod.ENUM_ST_CTE_COMPLTR_PROG_CD,prod.ENUM_ST_CTE_FINISHER_CODE,prod.ENUM_ST_END_STATUS_CODE,prod.ENUM_ST_ENTRY_CODE,prod.ENUM_ST_SPECIAL_PRG_CATEGORY,prod.ENUM_ST_YR_IN_9TH_GRADE_CD,prod.ENUM_SY_FLEX_OWNER_TYPE
expdp '"/ as sysdba"' file=datawarehouse_tables2.dmp,datawarehouse_tables3.dmp,datawarehouse_tables4.dmp,datawarehouse_tables5.dmp filesize=2G log=datawarehouse_tables_rest.log tables=prod.ENUM_SY_GENDER,prod.ENUM_SY_SCHOOL_GRADE_LEVEL,prod.ENUM_TN_POST_SECONDARY_PLANS,prod.GR_CLASS_GRADE_ENTRY,prod.SC_CLASS,prod.SC_COURSE,prod.SC_COURSE_CATALOG,prod.SC_SCHOOL_SCHEDULING_PARAMS,prod.SC_STUDENT_CLASS_MAPPING,prod.SC_TEACHER_CLASS_ASSIGNMENT,prod.ST_CTE_PROGRAM,prod.ST_ENROLLMENT,prod.ST_STUDENT_GROUP,prod.ST_STUDENT_GROUP_ASSOC,prod.SY_CAMPUS,prod.SY_DISTRICT_ZONE,prod.SY_FLEX_DATA,prod.SY_FLEX_FIELDS_DEF,prod.SY_FLEX_OWNER,prod.SY_SCHOOL,prod.SY_STAFF,prod.SY_STAFF_ASSIGNMENT,prod.TN_TRANSCRIPTS_HEADER,prod.ST_TITLE_I_SERVICE_PROFILE, prod.ENUM_ST_TITLE_I_SERVICES, prod.ENUM_AT_ABSENCE_REASON_CODE, prod.ENUM_AT_TARDY_REASON_CODE, prod.GR_GRADE_PERIOD_DEFINITION, prod.ST_STUDENT_SCHOOL_INFO, prod.DI_INCIDENT_EVENT_CODE, prod.CE_DWELLING, prod.ENUM_CE_DWELLING_TYPE, prod.CE_HOMELESS, prod.ENUM_SY_FLEX_ENUM_DATA, prod.TE_STUDENT_FUTURE_TEST, prod.TE_TEST_DEFINITION, prod.TE_TEST_2_OFFERED_GRADE
expdp '"/ as sysdba"' file=datawarehouse_tables6.dmp log=datawarehouse_tables_rest2.log tables=prod.AT_DAILY_ATTENDANCE_RECORDS query=\'where school_year = 2013\'
tar -cf - datawarehouse_tables.dmp datawarehouse_tables2.dmp datawarehouse_tables3.dmp datawarehouse_tables4.dmp datawarehouse_tables5.dmp datawarehouse_tables6.dmp | gzip > datawarehouse_66_tables.tar.gz.
2 Log files generated during the process.
The following section shows an example of each log file generated in the /DE-PR-CUSTOMER path during the process:
A. The output of the first part of the execution of the shell script generates the following entries:
;;;
Export: Release 11.2.0.2.0 - Production on Wed Nov 7 16:15:36 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
;;; Legacy Mode Active due to the following parameters:
;;; Legacy Mode Parameter: "file=datawarehouse_tables.dmp" Location: Command Line, Replaced with: "dumpfile=PROD_DUMP:datawarehouset_tables.dmp"
;;; Database Directory Object "PROD_DUMP" has been added to file specification: "datawarehouse_tables.dmp".
;;; Legacy Mode Parameter: "log=datawarehouse_tables.log" Location: Command Line, Replaced with: "logfile=PROD_DUMP:datawarehouse_tables.log"
;;; Database Directory Object "PROD_DUMP" has been added to file specification: "datawarehouse_tables.log".
;;; Legacy Mode has set reuse_dumpfiles=true parameter.
Starting "SYS"."SYS_EXPORT_TABLE_01": "/******** AS SYSDBA" dumpfile=PROD_DUMP:datawarehouse_tables.dmp logfile=PROD_DUMP:datawarehouse_tables.log tables=prod.CE_FAMILY,prod.CE_FAMILY_MEMBER,prod.CE_FAMILY_MEMBER_ETHNIC_CODE,prod.CE_FAMILY_MEMBER_LANGUAGE_CODE,prod.CE_FAMILY_MEMBER_MISC_CODE,prod.CE_FAMILY_MEMBER_SPECIAL_PROG, prod.CE_FAMILY_TO_MEMBER,prod.CE_HOUSE_HEAD,prod.CE_HOUSE_HEAD_PHONE,prod.CE_HOUSE_HEAD_TO_MEMBER,prod.DI_INCIDENT,prod.DI_PARTICIPANT,prod.DI_RESPONSE, prod.ENUM_CE_BIRTH_COUNTRY, prod.ENUM_CE_BIRTH_STATE,prod.ENUM_CE_ETHNIC_CODE,prod.ENUM_CE_LANGUAGE_CODE,prod.ENUM_CE_RELATION_CODE,prod.ENUM_DI_CONTEXT_LOCATION_CODE,prod.ENUM_DI_DISCIPLINE_CODE, prod.ENUM_DI_EVENT_CODE,prod.ENUM_DI_EVENT_LOCATION,prod.ENUM_DI_INJURY_TO_TYPE,prod.ENUM_DI_INJURY_TYPE, prod.ENUM_DI_OTHER_FACTOR_CODE,prod.ENUM_DI_PARTICIPANT_ROLE,prod.ENUM_DI_RESPONSE_CODE,prod.ENUM_DI_WEAPON_CODE,prod.ENUM_ST_CTE_COMPLTR_PROG_CD,prod.ENUM_ST_CTE_FINISHER_CODE,prod.ENUM_ST_END_STATUS_CODE,prod.ENUM_ST_ENTRY_CODE,prod.ENUM_ST_SPECIAL_PRG_CATEGORY,prod.ENUM_ST_YR_IN_9TH_GRADE_CD,prod.ENUM_SY_FLEX_OWNER_TYPE reuse_dumpfiles=true
Estimate in progress using BLOCKS method...Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 1.123 GBProcessing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANTProcessing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINTProcessing object type TABLE_EXPORT/TABLE/TRIGGERProcessing object type TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEXProcessing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICSProcessing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS. . exported "PROD"."CE_FAMILY_MEMBER" 267.8 MB 955664 rows. . exported "PROD"."CE_FAMILY" 95.55 MB 907490 rows. . exported "PROD"."CE_FAMILY_MEMBER_LANGUAGE_CODE" 89.86 MB 3149146 rows. . exported "PROD"."CE_HOUSE_HEAD" 124.1 MB 1007641 rows. . exported "PROD"."CE_HOUSE_HEAD_TO_MEMBER" 47.54 MB 1034075 rows. . exported "PROD"."CE_HOUSE_HEAD_PHONE" 46.01 MB 1065351 rows. . exported "PROD"."CE_FAMILY_TO_MEMBER" 32.83 MB 950503 rows. . exported "PROD"."CE_FAMILY_MEMBER_ETHNIC_CODE" 29.77 MB 970001 rows
. . exported "PROD"."ENUM_DI_RESPONSE_CODE" 7.953 MB 56018 rows
. . exported "PROD"."DI_INCIDENT" 638.2 KB 6897 rows
. . exported "PROD"."DI_PARTICIPANT" 434.8 KB 7486 rows
. . exported "PROD"."DI_RESPONSE" 198.9 KB 2168 rows
. . exported "PROD"."ENUM_ST_END_STATUS_CODE" 60.99 KB 358 rows
. . exported "PROD"."CE_FAMILY_MEMBER_SPECIAL_PROG" 8.710 KB 38 rows
. . exported "PROD"."ENUM_CE_BIRTH_COUNTRY" 23.72 KB 239 rows
. . exported "PROD"."ENUM_CE_BIRTH_STATE" 16.32 KB 52 rows
. . exported "PROD"."ENUM_CE_ETHNIC_CODE" 12.65 KB 11 rows
. . exported "PROD"."ENUM_CE_LANGUAGE_CODE" 18.53 KB 74 rows
. . exported "PROD"."ENUM_CE_RELATION_CODE" 11.39 KB 6 rows
. . exported "PROD"."ENUM_DI_CONTEXT_LOCATION_CODE" 12.34 KB 7 rows
. . exported "PROD"."ENUM_DI_EVENT_CODE" 21.70 KB 81 rows. . exported "PROD"."ENUM_DI_INJURY_TO_TYPE" 12.42 KB 19 rows
. . exported "PROD"."ENUM_DI_INJURY_TYPE" 12.06 KB 12 rows
. . exported "PROD"."ENUM_DI_OTHER_FACTOR_CODE" 12.42 KB 9 rows
. . exported "PROD"."ENUM_DI_PARTICIPANT_ROLE" 10.30 KB 3 rows
. . exported "PROD"."ENUM_DI_WEAPON_CODE" 12.32 KB 11 rows
. . exported "PROD"."ENUM_ST_CTE_COMPLTR_PROG_CD" 29.21 KB 143 rows
. . exported "PROD"."ENUM_ST_CTE_FINISHER_CODE" 11.58 KB 4 rows
. . exported "PROD"."ENUM_ST_ENTRY_CODE" 12.92 KB 12 rows
. . exported "PROD"."ENUM_ST_SPECIAL_PRG_CATEGORY" 11.98 KB 8 rows
. . exported "PROD"."ENUM_ST_YR_IN_9TH_GRADE_CD" 11.15 KB 3 rows
. . exported "PROD"."ENUM_SY_FLEX_OWNER_TYPE" 18.49 KB 47 rows
. . exported "PROD"."CE_FAMILY_MEMBER_MISC_CODE" 0 KB 0 rows
. . exported "PROD"."ENUM_DI_DISCIPLINE_CODE" 0 KB 0 rows
. . exported "PROD"."ENUM_DI_EVENT_LOCATION" 0 KB 0 rows
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
/DE-PR-CUSTOMER/datawarehouse_tables.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at 16:16:33
B. The second part of the execution of the shell script generates the following entries:
;;;
Export: Release 11.2.0.2.0 - Production on Wed Nov 7 16:16:34 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
;;; Legacy Mode Active due to the following parameters:
;;; Legacy Mode Parameter: "file=datawarehouse_tables2.dmp,datawarehouse_tables3.dmp,datawarehouse_tables4.dmp,datawarehouse_tables5.dmp" Location: Command Line, Replaced with: "dumpfile=PROD_DUMP:datawarehouse_tables2.dmp,PROD_DUMP:datawarehouse_tables3.dmp,PROD_DUMP:datawarehouse_tables4.dmp,PROD_DUMP:datawarehouse_tables5.dmp"
;;; Database Directory Object "PROD_DUMP" has been added to file specification: "datawarehouse_tables2.dmp".
;;; Database Directory Object "PROD_DUMP" has been added to file specification: "datawarehouse_tables3.dmp".
;;; Database Directory Object "PROD_DUMP" has been added to file specification: "datawarehouse_tables4.dmp".
;;; Database Directory Object "PROD_DUMP" has been added to file specification: "datawarehouse_tables5.dmp".
;;; Legacy Mode Parameter: "log=datawarehouse_tables_rest.log" Location: Command Line, Replaced with: "logfile=PROD_DUMP:datawarehouse_tables_rest.log"
;;; Database Directory Object "PROD_DUMP" has been added to file specification: "datawarehouse_tables_rest.log".
;;; Legacy Mode has set reuse_dumpfiles=true parameter.
Starting "SYS"."SYS_EXPORT_TABLE_01": "/******** AS SYSDBA" dumpfile=PROD_DUMP:datawarehouse_tables2.dmp,PROD_DUMP:datawarehouse_tables3.dmp,PROD_DUMP:datawarehouse_tables4.dmp,PROD_DUMP:datawarehouse_tables5.dmp filesize=2G logfile=PROD_DUMP:datawarehouse_tables_rest.log tables=prod.ENUM_SY_GENDER,prod.ENUM_SY_SCHOOL_GRADE_LEVEL,prod.ENUM_TN_POST_SECONDARY_PLANS,prod.GR_CLASS_GRADE_ENTRY,prod.SC_CLASS,prod.SC_COURSE,prod.SC_COURSE_CATALOG,prod.SC_SCHOOL_SCHEDULING_PARAMS,prod.SC_STUDENT_CLASS_MAPPING,prod.SC_TEACHER_CLASS_ASSIGNMENT,prod.ST_CTE_PROGRAM,prod.ST_ENROLLMENT,prod.ST_STUDENT_GROUP,prod.ST_STUDENT_GROUP_ASSOC,prod.SY_CAMPUS,prod.SY_DISTRICT_ZONE,prod.SY_FLEX_DATA,prod.SY_FLEX_FIELDS_DEF,prod.SY_FLEX_OWNER,prod.SY_SCHOOL,prod.SY_STAFF,prod.SY_STAFF_ASSIGNMENT,prod.TN_TRANSCRIPTS_HEADER,prod.ST_TITLE_I_SERVICE_PROFILE, prod.ENUM_ST_TITLE_I_SERVICES, prod.ENUM_AT_ABSENCE_REASON_CODE, prod.ENUM_AT_TARDY_REASON_CODE, prod.GR_GRADE_PERIOD_DEFINITION, prod.ST_STUDENT_SCHOOL_INFO, prod.DI_INCIDENT_EVENT_CODE, prod.CE_DWELLING, prod.ENUM_CE_DWELLING_TYPE, prod.CE_HOMELESS, prod.ENUM_SY_FLEX_ENUM_DATA, prod.TE_STUDENT_FUTURE_TEST, prod.TE_TEST_DEFINITION, prod.TE_TEST_2_OFFERED_GRADE reuse_dumpfiles=trueEstimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 7.964 GB
Processing object type TABLE_EXPORT/TABLE/TABLEProcessing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEXProcessing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/COMMENTProcessing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINTProcessing object type TABLE_EXPORT/TABLE/TRIGGERProcessing object type TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEXProcessing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICSProcessing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS. . exported "PROD"."GR_CLASS_GRADE_ENTRY" 3.519 GB 56340961 rows. . exported "PROD"."SC_STUDENT_CLASS_MAPPING" 1.648 GB 20201146 rows. . exported "PROD"."ST_ENROLLMENT" 747.4 MB 4203951 rows. . exported "PROD"."SY_FLEX_DATA" 155.7 MB 2768994 rows. . exported "PROD"."SC_CLASS" 232.9 MB 1483580 rows. . exported "PROD"."SC_COURSE" 119.0 MB 857368 rows. . exported "PROD"."ST_STUDENT_GROUP_ASSOC" 89.78 MB 2282291 rows. . exported "PROD"."SC_TEACHER_CLASS_ASSIGNMENT" 58.24 MB 1424902 rows
. . exported "PROD"."TN_TRANSCRIPTS_HEADER" 39.18 MB 932407 rows
. . exported "PROD"."ST_STUDENT_SCHOOL_INFO" 22.63 MB 422299 rows
. . exported "PROD"."ENUM_SY_SCHOOL_GRADE_LEVEL" 7.187 MB 87575 rows
. . exported "PROD"."ST_STUDENT_GROUP" 7.911 MB 147364 rows
. . exported "PROD"."SY_STAFF" 7.845 MB 60269 rows
. . exported "PROD"."GR_GRADE_PERIOD_DEFINITION" 4.387 MB 80402 rows
. . exported "PROD"."SY_STAFF_ASSIGNMENT" 3.821 MB 44812 rows
. . exported "PROD"."ENUM_AT_ABSENCE_REASON_CODE" 3.864 MB 31493 rows
. . exported "PROD"."ENUM_AT_TARDY_REASON_CODE" 1.220 MB 11045 rows
. . exported "PROD"."SC_SCHOOL_SCHEDULING_PARAMS" 1.113 MB 13396 rows
. . exported "PROD"."ST_TITLE_I_SERVICE_PROFILE" 1.333 MB 22279 rows
. . exported "PROD"."SC_COURSE_CATALOG" 580.1 KB 4124 rows
. . exported "PROD"."SY_FLEX_FIELDS_DEF" 529.4 KB 9306 rows. . exported "PROD"."SY_SCHOOL" 464.1 KB 1578 rows
. . exported "PROD"."ST_CTE_PROGRAM" 334.0 KB 5192 rows
. . exported "PROD"."DI_INCIDENT_EVENT_CODE" 218.0 KB 6946 rows
. . exported "PROD"."TE_STUDENT_FUTURE_TEST" 119.8 KB 3441 rows
. . exported "PROD"."CE_DWELLING" 47.97 KB 233 rows
. . exported "PROD"."CE_HOMELESS" 8.968 KB 1 rows
. . exported "PROD"."ENUM_CE_DWELLING_TYPE" 13.11 KB 14 rows
. . exported "PROD"."ENUM_ST_TITLE_I_SERVICES" 13.96 KB 25 rows
. . exported "PROD"."ENUM_SY_FLEX_ENUM_DATA" 11.19 KB 3 rows
. . exported "PROD"."ENUM_SY_GENDER" 10.22 KB 3 rows
. . exported "PROD"."ENUM_TN_POST_SECONDARY_PLANS" 11.95 KB 9 rows
. . exported "PROD"."SY_CAMPUS" 21.13 KB 120 rows
. . exported "PROD"."SY_DISTRICT_ZONE" 10.12 KB 12 rows
. . exported "PROD"."SY_FLEX_OWNER" 12.61 KB 94 rows
. . exported "PROD"."TE_TEST_2_OFFERED_GRADE" 8.265 KB 6 rows
. . exported "PROD"."TE_TEST_DEFINITION" 13.71 KB 1 rows
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
/DE-PR-CUSTOMER/datawarehouse_tables2.dmp
/DE-PR-CUSTOMER/datawarehouse_tables3.dmp
/DE-PR-CUSTOMER/datawarehouse_tables4.dmp
/DE-PR-CUSTOMER/datawarehouse_tables5.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at 16:24:30
C. The third part of the execution of the shell script generates the following entries:
;;;
Export: Release 11.2.0.2.0 - Production on Wed Nov 7 16:24:32 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
;;; Legacy Mode Active due to the following parameters:
;;; Legacy Mode Parameter: "file=datawarehouse_tables6.dmp" Location: Command Line, Replaced with: "dumpfile=PROD_DUMP:datawarehouse_tables6.dmp"
;;; Database Directory Object "PROD_DUMP" has been added to file specification: "datawarehouse_tables6.dmp".
;;; Legacy Mode Parameter: "log=datawarehouse_tables_rest2.log" Location: Command Line, Replaced with: "logfile=PROD_DUMP:datawarehouse_tables_rest2.log"
;;; Database Directory Object "PROD_DUMP" has been added to file specification: "datawarehouse_tables_rest2.log".
;;; Legacy Mode has set reuse_dumpfiles=true parameter.
Starting "SYS"."SYS_EXPORT_TABLE_01": "/******** AS SYSDBA" dumpfile=PROD_DUMP:datawarehouse_tables6.dmp logfile=PROD_DUMP:datawarehouse_tables_rest2.log tables=prod.AT_DAILY_ATTENDANCE_RECORDS query='where school_year = 2013' reuse_dumpfiles=true
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 2.375 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Processing object type TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "PROD"."AT_DAILY_ATTENDANCE_RECORDS" 75.38 MB 1182381 rows
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
/DE-PR-CUSTOMER/datawarehouse_tables6.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at 16:24:45
Transfer the compressed file to the datawarehouse server.
Once the compression is finished, is necessary to transfer the file generated to the server 192.168.22.250 (DE-SMAX-001) in order to put the file in the directory C:\oracle\admin\PMAXIO\dpdump. This process has to be manual for the moment.
1 Steps for the transfer of the compressed file to the datawarehouse server.
The steps to be followed in order to transfer the compressed export file to the server 192.168.22.250 (DE-SMAX-001) are:
A. Connect to the remote server 192.168.22.250 using Remote Desktop Connection tool.
[pic]
B. The username is perezgilbert and need the password:
[pic]
C. Once connected, the following screen appears and is necessary to click Yes.
[pic]
D. In the next screen with the welcome information click OK.
E. Connect to the Core FTP LE tool with the corresponding user:
[pic]
F. The following screen appears. In the left hand the path should be pointing to: C:\oracle\admin\PMAXIO\dpdump\, that corresponds to the server 192.168.22.250 (local) and in the right hand the path should be /DE-PR-CUSTOMER/, and this corresponds to the oracle linux database server that has the compressed file. The screen looks like the following:
[pic]
G. Is necessary to select the file at the left panel and proceed to delete it. Then, drag the file datawarehouse_77_tables.tar.gz from the right panel to the left panel in order to start with the transfer of the compressed file. In the below part of the screen the status in percent of the execution is showed;
[pic]
H. Once the file is been transferred an e-mail should be sent to Lourdes Rodriguez and Gilbert Perez with a copy to Vicente Graulau in order to indicate that the file is in process and the percent used at the moment of the creation of the email.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.