;;; Export: Release 11.1.0.7.0 - 64bit Production on Tuesday, 23 November, 2010 16:43:56 Copyright (c) 2003, 2007, Oracle. All rights reserved. ;;; Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/********@CCSTG1 directory=dp_exp_dir schemas=CCUSER dumpfile=exp_stg_ccuser_1574871.dmp ENCRYPTION_PASSWORD=******** logfile=exp_stg_ccuser_1574871.log Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 504 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/TABLESPACE_QUOTA Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/TABLE/TABLE 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/COMMENT Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE Processing object type SCHEMA_EXPORT/VIEW/VIEW Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/TRIGGER Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA . . exported "CCUSER"."AUDIT_FILTER_LOG" 1.198 MB 14085 rows . . exported "CCUSER"."PATIENT_PROFILE_PICTURE" 268.9 KB 40 rows . . exported "CCUSER"."NETWORK_ROLE_MODULE_PERMISSION" 142.6 KB 3052 rows . . exported "CCUSER"."MEDICAL_ISSUES_LKP" 1.567 MB 21365 rows . . exported "CCUSER"."USER_PROFILE_PICTURE" 12.71 KB 3 rows . . exported "CCUSER"."SESSION_LOG" 37.28 KB 272 rows . . exported "CCUSER"."USER_PROFILE_LOGIN" 12.71 KB 110 rows . . exported "CCUSER"."NETWORK_ROLE_LKP" 16.53 KB 179 rows . . exported "CCUSER"."USER_PROFILE" 27.78 KB 32 rows . . exported "CCUSER"."PATIENT_ISSUES_LNK" 15.98 KB 16 rows . . exported "CCUSER"."CONTACT_LKP" 15.76 KB 11 rows . . exported "CCUSER"."CONTACT_PHONE" 9.726 KB 12 rows . . exported "CCUSER"."INVITATION_TEMPLATES" 66.24 KB 92 rows . . exported "CCUSER"."ITEM_DETAIL" 13.80 KB 14 rows . . exported "CCUSER"."ITEM_DETAIL_RECURRENCE" 9.859 KB 1 rows . . exported "CCUSER"."NOTES_LNK" 10.10 KB 21 rows . . exported "CCUSER"."PATIENT_INSURANCE_LNK" 15.54 KB 4 rows . . exported "CCUSER"."PATIENT_ISSUE_MAP" 6.75 KB 46 rows . . exported "CCUSER"."PATIENT_PROFILE" 23.24 KB 44 rows . . exported "CCUSER"."USER_CALENDER_HEADER" 18.53 KB 40 rows . . exported "CCUSER"."CONTACT_LKP_ARCHIVE" 14.06 KB 1 rows . . exported "CCUSER"."EMERGENCY_PROCEDURE_ARCHIVE" 8.820 KB 9 rows . . exported "CCUSER"."EMERGENCY_PROCEDURE_LNK" 9.367 KB 6 rows . . exported "CCUSER"."IMMUNIZATION_PATIENT_ARCHIVE" 11.32 KB 26 rows . . exported "CCUSER"."ITEM_LKP" 9.554 KB 20 rows . . exported "CCUSER"."JOURNAL_ARCHIVE" 10.17 KB 20 rows . . exported "CCUSER"."JOURNAL_LNK" 8.632 KB 7 rows . . exported "CCUSER"."PATIENT_FINANCIAL_ARCHIVE" 10.49 KB 5 rows . . exported "CCUSER"."PATIENT_INSURANCE_ARCHIVE" 14.29 KB 2 rows . . exported "CCUSER"."PATIENT_LEGAL_LNK" 9.414 KB 4 rows . . exported "CCUSER"."PATIENT_MEASUREMENT_ARCHIVE" 11.12 KB 6 rows . . exported "CCUSER"."PRESCRIPTION_ARCHIVE" 23.71 KB 38 rows . . exported "CCUSER"."PRICING_PURCHASE_TRANSACTION" 10.31 KB 56 rows . . exported "CCUSER"."REMINDER" 10.52 KB 33 rows . . exported "CCUSER"."USER_PROFILE_INVITES" 14.94 KB 14 rows . . exported "CCUSER"."USER_ROLE_PATIENT_LNK" 10.96 KB 52 rows . . exported "CCUSER"."BLOOD_GROUP_LKP" 7.367 KB 10 rows . . exported "CCUSER"."CONTACT_ADDRESS" 11.75 KB 7 rows . . exported "CCUSER"."CONTACT_CATEGORY_LKP" 7.367 KB 4 rows . . exported "CCUSER"."EVENT_TYPE_LKP" 7.703 KB 3 rows . . exported "CCUSER"."IMMUNIZATION_LKP" 15.88 KB 76 rows . . exported "CCUSER"."IMMUNIZATION_PATIENT_LNK" 8.859 KB 6 rows . . exported "CCUSER"."INSURANCE_LKP" 7.718 KB 5 rows . . exported "CCUSER"."ITEM_CATEGORY_LKP" 7.328 KB 6 rows . . exported "CCUSER"."ITEM_DETAIL_ARCHIVE" 13.07 KB 3 rows . . exported "CCUSER"."LAWYER_DESIGNATION_LKP" 7.210 KB 1 rows . . exported "CCUSER"."MEASUREMENT_LNK" 7.929 KB 9 rows . . exported "CCUSER"."MEASUREMENT_TYPE_LKP" 7.859 KB 6 rows . . exported "CCUSER"."MEASUREMENT_UNIT_LKP" 7.484 KB 9 rows . . exported "CCUSER"."MEDICAL_ISSUE_TYPES" 7.351 KB 5 rows . . exported "CCUSER"."MESSAGES" 10.03 KB 24 rows . . exported "CCUSER"."MESSAGES_ARCHIVE" 9.039 KB 1 rows . . exported "CCUSER"."MODULE_LKP" 9.015 KB 20 rows . . exported "CCUSER"."NOTES_ARCHIVE" 7.695 KB 1 rows . . exported "CCUSER"."PATIENT_FINANCIAL_LNK" 10.45 KB 5 rows . . exported "CCUSER"."PATIENT_LEGAL_ARCHIVE" 9.640 KB 7 rows . . exported "CCUSER"."PATIENT_MEASUREMENT_LNK" 11.19 KB 7 rows . . exported "CCUSER"."PERMISSION_LKP" 7.835 KB 4 rows . . exported "CCUSER"."PRESCRIPTION_LNK" 17.17 KB 6 rows . . exported "CCUSER"."PRICING_CATALOUGE" 8.695 KB 3 rows . . exported "CCUSER"."PRICING_ITEM" 9.195 KB 3 rows . . exported "CCUSER"."PRICING_ITEM_TYPE_LKP" 7.257 KB 2 rows . . exported "CCUSER"."PRICING_PACKAGE" 11.00 KB 3 rows . . exported "CCUSER"."PRICING_PLAN_ITEM" 7.804 KB 3 rows . . exported "CCUSER"."PRICING_PURCHASE_HISTORY" 13.48 KB 36 rows . . exported "CCUSER"."RECURRENT_TYPE_LKP" 7.289 KB 5 rows . . exported "CCUSER"."ROLES_LKP" 8.234 KB 4 rows . . exported "CCUSER"."ROLE_MODULE_PERMISSION_LNK" 9.265 KB 68 rows . . exported "CCUSER"."SECRET_QUESTION_LKP" 7.5 KB 5 rows . . exported "CCUSER"."SITE_SETTINGS" 7.468 KB 21 rows . . exported "CCUSER"."STATE_LKP" 9.054 KB 50 rows . . exported "CCUSER"."USER_ADDRESS" 10.78 KB 10 rows . . exported "CCUSER"."USER_ALTERNATE_EMAIL" 7.906 KB 3 rows . . exported "CCUSER"."USER_CALENDER" 11.40 KB 5 rows . . exported "CCUSER"."USER_CALENDER_HEADER_ARCHIVE" 13.67 KB 5 rows . . exported "CCUSER"."USER_PREFERENCES" 8.843 KB 6 rows . . exported "CCUSER"."USER_PROFILE_INVITES_ARCHIVE" 16.15 KB 27 rows . . exported "CCUSER"."USER_PROFILE_PASSWORD_HISTORY" 18.16 KB 141 rows . . exported "CCUSER"."USER_SETTINGS" 5.054 KB 1 rows . . exported "CCUSER"."ALLERGY_LKP" 0 KB 0 rows . . exported "CCUSER"."ALLERGY_PATIENT_ARCHIVE" 0 KB 0 rows . . exported "CCUSER"."ALLERGY_PATIENT_LNK" 0 KB 0 rows . . exported "CCUSER"."AUDIT_LOG" 0 KB 0 rows . . exported "CCUSER"."AUDIT_TRAIL" 0 KB 0 rows . . exported "CCUSER"."CITY_LKP" 0 KB 0 rows . . exported "CCUSER"."CONDITION_LKP" 0 KB 0 rows . . exported "CCUSER"."CONDITION_PATIENT_ARCHIVE" 0 KB 0 rows . . exported "CCUSER"."CONDITION_PATIENT_LNK" 0 KB 0 rows . . exported "CCUSER"."CONTACT_ADDRESS_ARCHIVE" 0 KB 0 rows . . exported "CCUSER"."CONTACT_PHONE_ARCHIVE" 0 KB 0 rows . . exported "CCUSER"."CONTENT_ENTITLEMENT_LKP" 0 KB 0 rows . . exported "CCUSER"."DOSAGE_ARCHIVE" 0 KB 0 rows . . exported "CCUSER"."DRUG_LKP" 0 KB 0 rows . . exported "CCUSER"."ITEM_HISTORY" 0 KB 0 rows . . exported "CCUSER"."LANGUAGE_LKP" 0 KB 0 rows . . exported "CCUSER"."MARITIAL_STATUS_LKP" 0 KB 0 rows . . exported "CCUSER"."PACKAGE_TYPE_LKP" 0 KB 0 rows . . exported "CCUSER"."PATIENT_FAMILY_CONDITION_HISTO" 0 KB 0 rows . . exported "CCUSER"."PATIENT_FAMILY_CONDITION_HIS_1" 0 KB 0 rows . . exported "CCUSER"."PATIENT_FAMILY_HISTORY" 0 KB 0 rows . . exported "CCUSER"."PATIENT_FAMILY_HISTORY_ARCHIVE" 0 KB 0 rows . . exported "CCUSER"."PATIENT_HISTORY_ISSUES_LNK" 0 KB 0 rows . . exported "CCUSER"."PATIENT_MEDICAL_HISTORY" 0 KB 0 rows . . exported "CCUSER"."PATIENT_MEDICAL_HISTORY_ARCHIV" 0 KB 0 rows . . exported "CCUSER"."PRICING_COUPON" 0 KB 0 rows . . exported "CCUSER"."PRICING_COUPON_CODES" 0 KB 0 rows . . exported "CCUSER"."PRICING_DISCOUNT" 0 KB 0 rows . . exported "CCUSER"."PRICING_IMAGES" 0 KB 0 rows . . exported "CCUSER"."PRICING_PLAN" 0 KB 0 rows . . exported "CCUSER"."PROCEDURE_LKP" 0 KB 0 rows . . exported "CCUSER"."PROCEDURE_PATIENT_ARCHIVE" 0 KB 0 rows . . exported "CCUSER"."PROCEDURE_PATIENT_LNK" 0 KB 0 rows . . exported "CCUSER"."RACE_LKP" 0 KB 0 rows . . exported "CCUSER"."SYSDIAGRAMS" 0 KB 0 rows . . exported "CCUSER"."T1" 0 KB 0 rows . . exported "CCUSER"."USER_CALENDER_ARCHIVE" 0 KB 0 rows . . exported "CCUSER"."USER_SECRET_QUESTION_ANSWER" 0 KB 0 rows Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is: /dumps/dp_exp_dir/exp_stg_ccuser_1574871.dmp Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 16:45:38