设为首页收藏本站

Botang唐波's Oracle Station

查看: 205|回复: 0

活动第39次(2018-07-14星期六下午)

[复制链接]

745

主题

1118

帖子

8120

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
8120
发表于 2018-7-14 14:47:14 | 显示全部楼层 |阅读模式
检查一下在根容器上有没有统一审计,并且打开新的统一审计:
  1. select  * from  audit_unified_enabled_policies;

  2. CREATE AUDIT POLICY audit_tablespace
  3. ACTIONS create tablespace;

  4. select  * from  audit_unified_enabled_policies;

  5. audit policy AUDIT_TABLESPACE;

  6. select  * from  audit_unified_enabled_policies;
复制代码
如果要关掉统一审计,并且查看哪些是关掉的统一审计策略:
  1. noaudit policy AUDIT_TABLESPACE;

  2. select * from audit_unified_enabled_policies;

  3. select * from audit_unified_policies  order by 1;
复制代码

统一审计轨迹(unified_audit_trail),每个插件数据库看自己的,根容器看全部的:
  1. SELECT dbusername, action_name, object_name
  2.   2  FROM unified_audit_trail
  3.   3  ;

  4. DBUSERNAME
  5. ------------------------------
  6. ACTION_NAME
  7. ----------------------------------------------------------------
  8. OBJECT_NAME
  9. --------------------------------------------------------------------------------
  10. SYS
  11. CREATE TABLESPACE
  12. TBS_ORCL

  13. SYS
  14. CREATE TABLESPACE
  15. TBS_ORCL

  16. DBUSERNAME
  17. ------------------------------
  18. ACTION_NAME
  19. ----------------------------------------------------------------
  20. OBJECT_NAME
  21. --------------------------------------------------------------------------------

  22. SYS
  23. COMMIT


  24. SYS
  25. COMMIT

  26. DBUSERNAME
  27. ------------------------------
  28. ACTION_NAME
  29. ----------------------------------------------------------------
  30. OBJECT_NAME
  31. --------------------------------------------------------------------------------


  32. SYS
  33. LOGON



  34. SQL> conn sys/oracle_4U@pdb2 as sysdba
  35. Connected.
  36. SELECT dbusername, action_name, object_name
  37.   2  FROM unified_audit_trail
  38.   3  ;

  39. DBUSERNAME
  40. ------------------------------
  41. ACTION_NAME
  42. ----------------------------------------------------------------
  43. OBJECT_NAME
  44. --------------------------------------------------------------------------------
  45. SYS
  46. DROP USER
  47. LU_PDB2

  48. SYS
  49. LOGON


  50. DBUSERNAME
  51. ------------------------------
  52. ACTION_NAME
  53. ----------------------------------------------------------------
  54. OBJECT_NAME
  55. --------------------------------------------------------------------------------

  56. SYS
  57. COMMIT


  58. SYS
  59. COMMIT

  60. DBUSERNAME
  61. ------------------------------
  62. ACTION_NAME
  63. ----------------------------------------------------------------
  64. OBJECT_NAME
  65. --------------------------------------------------------------------------------


  66. SYS
  67. DROP USER
  68. LU_PDB2


  69. SQL>
复制代码
根容器上的表空间创建是不会有统一审计的,统一审计只针对插件数据库。
如果找不到审计轨迹,要么等待,要么执行DBMS_AUDIT_MGMT.FLUSH_UNIFIED_AUDIT_TRAIL, 然后再去看 unified_audit_trail。

最后需要区分一下cdb_unified_audit_trail和unidied_audit_trail:
Screenshot-PL-SQL Developer - sys@CDB2 as SYSDBA - [SQL Window - SELECT policy_n.png

-------------------------------------------------------------逻辑备份的FULL TRANSPORTABLE模式:
expdp help=y
找到TRANSPORTABLE
Specify whether transportable method can be used.
Valid keyword values are: ALWAYS and [NEVER].

采用“嫁接”和“生长”结合的方法移动数据:
  1. [oracle@station90 bin]$ expdp system/oracle_4U  dumpfile=expfull.dmp  full=y transportable=always  logfile=expfull.log

  2. Export: Release 12.1.0.2.0 - Production on Sat Jul 14 15:18:49 2018

  3. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

  4. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
  5. With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
  6. Starting "SYSTEM"."SYS_EXPORT_FULL_01":  system/******** dumpfile=expfull.dmp full=y transportable=always logfile=expfull.log
  7. Estimate in progress using BLOCKS method...
  8. Processing object type DATABASE_EXPORT/PLUGTS_FULL/FULL/PLUGTS_TABLESPACE
  9. Processing object type DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK
  10. Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
  11. Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
  12. Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
  13. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
  14. Total estimation using BLOCKS method: 5.578 MB
  15. Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
  16. Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
  17. Processing object type DATABASE_EXPORT/TABLESPACE
  18. Processing object type DATABASE_EXPORT/PROFILE
  19. Processing object type DATABASE_EXPORT/SYS_USER/USER
  20. Processing object type DATABASE_EXPORT/SCHEMA/USER
  21. Processing object type DATABASE_EXPORT/RADM_FPTM
  22. Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
  23. Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
  24. Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
  25. Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
  26. Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT
  27. Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
  28. Processing object type DATABASE_EXPORT/RESOURCE_COST
  29. Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
  30. Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
  31. Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
  32. Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
  33. Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
  34. Processing object type DATABASE_EXPORT/SCHEMA/TYPE/INC_TYPE
  35. Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
  36. Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
  37. Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
  38. Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
  39. Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
  40. Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
  41. Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
  42. Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER
  43. Processing object type DATABASE_EXPORT/SCHEMA/XMLSCHEMA/XMLSCHEMA
  44. Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
  45. Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
  46. Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MARKER
  47. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PROCACT_INSTANCE
  48. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
  49. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
  50. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
  51. Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
  52. Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
  53. Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
  54. Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
  55. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
  56. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
  57. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
  58. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
  59. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
  60. Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
  61. Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
  62. Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
  63. Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODY
  64. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
  65. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/BITMAP_INDEX/INDEX
  66. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
  67. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
  68. Processing object type DATABASE_EXPORT/STATISTICS/MARKER
  69. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/SECONDARY_TABLE/TABLE
  70. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/SECONDARY_TABLE/INDEX/INDEX
  71. ORA-39340: unsupported object, INDEX:"SH"."SYS_IL0000092978C00006[        DISCUZ_CODE_3        ]quot; will be skipped.
  72. ORA-39340: unsupported object, INDEX:"SH"."SYS_IL0000092981C00002[        DISCUZ_CODE_3        ]quot; will be skipped.
  73. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/SECONDARY_TABLE/CONSTRAINT
  74. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX
  75. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
  76. Processing object type DATABASE_EXPORT/SCHEMA/VIEW/TRIGGER
  77. Processing object type DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW
  78. Processing object type DATABASE_EXPORT/SCHEMA/DIMENSION
  79. Processing object type DATABASE_EXPORT/END_PLUGTS_BLK
  80. Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER
  81. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE
  82. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
  83. Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
  84. Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
  85. Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE
  86. Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
  87. . . exported "SYS"."KU$_USER_MAPPING_VIEW"               6.140 KB      42 rows
  88. . . exported "ORDDATA"."ORDDCM_DOCS"                     252.9 KB       9 rows
  89. . . exported "WMSYS"."WM$CONSTRAINTS_TABLE[        DISCUZ_CODE_3        ]quot;                 0 KB       0 rows
  90. . . exported "SYS"."AUD[        DISCUZ_CODE_3        ]quot;                                    0 KB       0 rows
  91. . . exported "WMSYS"."WM$LOCKROWS_INFO[        DISCUZ_CODE_3        ]quot;                     0 KB       0 rows
  92. . . exported "WMSYS"."WM$UDTRIG_INFO[        DISCUZ_CODE_3        ]quot;                       0 KB       0 rows
  93. . . exported "LBACSYS"."OLS$AUDIT_ACTIONS"               5.757 KB       8 rows
  94. . . exported "LBACSYS"."OLS$DIP_EVENTS"                  5.539 KB       2 rows
  95. . . exported "LBACSYS"."OLS$INSTALLATIONS"               6.960 KB       2 rows
  96. . . exported "LBACSYS"."OLS$PROPS"                       6.234 KB       5 rows
  97. . . exported "SYS"."DAM_CLEANUP_EVENTS[        DISCUZ_CODE_3        ]quot;                     0 KB       0 rows
  98. . . exported "SYS"."DAM_CLEANUP_JOBS[        DISCUZ_CODE_3        ]quot;                       0 KB       0 rows
  99. . . exported "SYS"."DAM_CONFIG_PARAM[        DISCUZ_CODE_3        ]quot;                   6.531 KB      14 rows
  100. . . exported "SYS"."TSDP_ASSOCIATION[        DISCUZ_CODE_3        ]quot;                       0 KB       0 rows
  101. . . exported "SYS"."TSDP_CONDITION[        DISCUZ_CODE_3        ]quot;                         0 KB       0 rows
  102. . . exported "SYS"."TSDP_FEATURE_POLICY[        DISCUZ_CODE_3        ]quot;                    0 KB       0 rows
  103. . . exported "SYS"."TSDP_PARAMETER[        DISCUZ_CODE_3        ]quot;                     5.953 KB       1 rows
  104. . . exported "SYS"."TSDP_POLICY[        DISCUZ_CODE_3        ]quot;                        5.921 KB       1 rows
  105. . . exported "SYS"."TSDP_PROTECTION[        DISCUZ_CODE_3        ]quot;                        0 KB       0 rows
  106. . . exported "SYS"."TSDP_SENSITIVE_DATA[        DISCUZ_CODE_3        ]quot;                    0 KB       0 rows
  107. . . exported "SYS"."TSDP_SENSITIVE_TYPE[        DISCUZ_CODE_3        ]quot;                    0 KB       0 rows
  108. . . exported "SYS"."TSDP_SOURCE[        DISCUZ_CODE_3        ]quot;                            0 KB       0 rows
  109. . . exported "SYS"."TSDP_SUBPOL[        DISCUZ_CODE_3        ]quot;                        6.328 KB       1 rows
  110. . . exported "SYSTEM"."REDO_DB"                          25.59 KB       1 rows
  111. . . exported "SYSTEM"."REDO_LOG"                             0 KB       0 rows
  112. . . exported "WMSYS"."WM$BATCH_COMPRESSIBLE_TABLES[        DISCUZ_CODE_3        ]quot;         0 KB       0 rows
  113. . . exported "WMSYS"."WM$CONS_COLUMNS[        DISCUZ_CODE_3        ]quot;                      0 KB       0 rows
  114. . . exported "WMSYS"."WM$ENV_VARS[        DISCUZ_CODE_3        ]quot;                      6.015 KB       3 rows
  115. . . exported "WMSYS"."WM$EVENTS_INFO[        DISCUZ_CODE_3        ]quot;                   5.812 KB      12 rows
  116. . . exported "WMSYS"."WM$HINT_TABLE[        DISCUZ_CODE_3        ]quot;                    9.453 KB      75 rows
  117. . . exported "WMSYS"."WM$MODIFIED_TABLES[        DISCUZ_CODE_3        ]quot;                   0 KB       0 rows
  118. . . exported "WMSYS"."WM$MP_GRAPH_WORKSPACES_TABLE[        DISCUZ_CODE_3        ]quot;         0 KB       0 rows
  119. . . exported "WMSYS"."WM$MP_PARENT_WORKSPACES_TABLE[        DISCUZ_CODE_3        ]quot;        0 KB       0 rows
  120. . . exported "WMSYS"."WM$NESTED_COLUMNS_TABLE[        DISCUZ_CODE_3        ]quot;              0 KB       0 rows
  121. . . exported "WMSYS"."WM$NEXTVER_TABLE[        DISCUZ_CODE_3        ]quot;                 6.375 KB       1 rows
  122. . . exported "WMSYS"."WM$REMOVED_WORKSPACES_TABLE[        DISCUZ_CODE_3        ]quot;          0 KB       0 rows
  123. . . exported "WMSYS"."WM$RESOLVE_WORKSPACES_TABLE[        DISCUZ_CODE_3        ]quot;          0 KB       0 rows
  124. . . exported "WMSYS"."WM$RIC_LOCKING_TABLE[        DISCUZ_CODE_3        ]quot;                 0 KB       0 rows
  125. . . exported "WMSYS"."WM$RIC_TABLE[        DISCUZ_CODE_3        ]quot;                         0 KB       0 rows
  126. . . exported "WMSYS"."WM$RIC_TRIGGERS_TABLE[        DISCUZ_CODE_3        ]quot;                0 KB       0 rows
  127. . . exported "WMSYS"."WM$UDTRIG_DISPATCH_PROCS[        DISCUZ_CODE_3        ]quot;             0 KB       0 rows
  128. . . exported "WMSYS"."WM$VERSION_HIERARCHY_TABLE[        DISCUZ_CODE_3        ]quot;       5.984 KB       1 rows
  129. . . exported "WMSYS"."WM$VERSION_TABLE[        DISCUZ_CODE_3        ]quot;                     0 KB       0 rows
  130. . . exported "WMSYS"."WM$VT_ERRORS_TABLE[        DISCUZ_CODE_3        ]quot;                   0 KB       0 rows
  131. . . exported "WMSYS"."WM$WORKSPACES_TABLE[        DISCUZ_CODE_3        ]quot;              12.10 KB       1 rows
  132. . . exported "WMSYS"."WM$WORKSPACE_PRIV_TABLE[        DISCUZ_CODE_3        ]quot;          7.054 KB      10 rows
  133. . . exported "WMSYS"."WM$WORKSPACE_SAVEPOINTS_TABLE[        DISCUZ_CODE_3        ]quot;        0 KB       0 rows
  134. . . exported "LBACSYS"."OLS$AUDIT"                           0 KB       0 rows
  135. . . exported "LBACSYS"."OLS$COMPARTMENTS"                    0 KB       0 rows
  136. . . exported "LBACSYS"."OLS$DIP_DEBUG"                       0 KB       0 rows
  137. . . exported "LBACSYS"."OLS$GROUPS"                          0 KB       0 rows
  138. . . exported "LBACSYS"."OLS$LAB"                             0 KB       0 rows
  139. . . exported "LBACSYS"."OLS$LEVELS"                          0 KB       0 rows
  140. . . exported "LBACSYS"."OLS$POL"                             0 KB       0 rows
  141. . . exported "LBACSYS"."OLS$POLICY_ADMIN"                    0 KB       0 rows
  142. . . exported "LBACSYS"."OLS$POLS"                            0 KB       0 rows
  143. . . exported "LBACSYS"."OLS$POLT"                            0 KB       0 rows
  144. . . exported "LBACSYS"."OLS$PROFILE"                         0 KB       0 rows
  145. . . exported "LBACSYS"."OLS$PROFILES"                        0 KB       0 rows
  146. . . exported "LBACSYS"."OLS$PROG"                            0 KB       0 rows
  147. . . exported "LBACSYS"."OLS$SESSINFO"                        0 KB       0 rows
  148. . . exported "LBACSYS"."OLS$USER"                            0 KB       0 rows
  149. . . exported "LBACSYS"."OLS$USER_COMPARTMENTS"               0 KB       0 rows
  150. . . exported "LBACSYS"."OLS$USER_GROUPS"                     0 KB       0 rows
  151. . . exported "LBACSYS"."OLS$USER_LEVELS"                     0 KB       0 rows
  152. . . exported "SYS"."FGA_LOG$FOR_EXPORT"                      0 KB       0 rows
  153. . . exported "SYSTEM"."SCHEDULER_JOB_ARGS"                   0 KB       0 rows
  154. . . exported "SYSTEM"."SCHEDULER_PROGRAM_ARGS"           9.515 KB      12 rows
  155. . . exported "SYS"."AUDTAB$TBS$FOR_EXPORT"               5.953 KB       2 rows
  156. . . exported "SYS"."DBA_SENSITIVE_DATA"                      0 KB       0 rows
  157. . . exported "SYS"."DBA_TSDP_POLICY_PROTECTION"              0 KB       0 rows
  158. . . exported "SYS"."NACL$_ACE_EXP"                       9.929 KB       1 rows
  159. . . exported "SYS"."NACL$_HOST_EXP"                      6.914 KB       1 rows
  160. . . exported "SYS"."NACL$_WALLET_EXP"                        0 KB       0 rows
  161. . . exported "WMSYS"."WM$EXP_MAP"                        7.718 KB       3 rows
  162. Master table "SYSTEM"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
  163. ******************************************************************************
  164. Dump file set for SYSTEM.SYS_EXPORT_FULL_01 is:
  165.   /u01/app/oracle/admin/orcl/dpdump/expfull.dmp
  166. ******************************************************************************
  167. Datafiles required for transportable tablespace EXAMPLE:
  168.   /u01/app/oracle/oradata/orcl/example01.dbf
  169. Datafiles required for transportable tablespace USERS:
  170.   /u01/app/oracle/oradata/orcl/users01.dbf
  171. Job "SYSTEM"."SYS_EXPORT_FULL_01" completed with 2 error(s) at Sat Jul 14 15:22:09 2018 elapsed 0 00:03:18

  172. [oracle@station90 bin]$
复制代码

/u01/app/oracle/admin/orcl/dpdump/expfull.dmp用于“生长”。拷贝到数据泵的工作目录。

以下用于“嫁接”。拷贝到pdb_orcl的数据文件目录。
Datafiles required for transportable tablespace EXAMPLE:
  /u01/app/oracle/oradata/orcl/example01.dbf
Datafiles required for transportable tablespace USERS:
  /u01/app/oracle/oradata/orcl/users01.dbf

  1. [oracle@station90 bin]$ impdp system/oracle_4U@pdb_orcl directory=dp_orcl  dumpfile=expfull.dmp  full=y transport_datafiles='/u01/app/oracle/oradata/cdb2/pdb_orcl/example01.dbf','/u01/app/oracle/oradata/cdb2/pdb
  2. pdb21/    pdb22/    pdb_orcl/ pdbseed/  
  3. [oracle@station90 bin]$ impdp system/oracle_4U@pdb_orcl directory=dp_orcl  dumpfile=expfull.dmp  full=y transport_datafiles='/u01/app/oracle/oradata/cdb2/pdb_orcl/example01.dbf','/u01/app/oracle/oradata/cdb2/pdb_orcl/users01.dbf'  

  4. Import: Release 12.1.0.2.0 - Production on Sat Jul 14 15:45:24 2018

  5. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

  6. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
  7. With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
  8. and Unified Auditing options
  9. Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
  10. Source time zone is +00:00 and target time zone is -07:00.
  11. Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/********@pdb_orcl directory=dp_orcl dumpfile=expfull.dmp full=y transport_datafiles=/u01/app/oracle/oradata/cdb2/pdb_orcl/example01.dbf,/u01/app/oracle/oradata/cdb2/pdb_orcl/users01.dbf
  12. Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
  13. Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
  14. Processing object type DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK
  15. Processing object type DATABASE_EXPORT/TABLESPACE
  16. ORA-39083: Object type TABLESPACE:"UNDOTBS1" failed to create with error:
  17. ORA-01516: nonexistent log file, data file, or temporary file "/u01/app/oracle/oradata/orcl/undotbs01.dbf"
  18. Failing sql is:
  19. ALTER DATABASE DATAFILE '/u01/app/oracle/oradata/orcl/undotbs01.dbf' RESIZE 157286400
  20. ORA-31684: Object type TABLESPACE:"TEMP" already exists
  21. Processing object type DATABASE_EXPORT/PROFILE
  22. Processing object type DATABASE_EXPORT/SYS_USER/USER
  23. Processing object type DATABASE_EXPORT/SCHEMA/USER
  24. Processing object type DATABASE_EXPORT/RADM_FPTM
  25. Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
  26. Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
  27. Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
  28. Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
  29. Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT
  30. Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
  31. Processing object type DATABASE_EXPORT/RESOURCE_COST
  32. Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
  33. Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
  34. Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
  35. Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
  36. Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
  37. Processing object type DATABASE_EXPORT/SCHEMA/TYPE/INC_TYPE
  38. Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
  39. Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
  40. Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
  41. Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
  42. Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
  43. ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
  44. ORA-65040: operation not allowed from within a pluggable database
  45. ORA-13900: missing or invalid parameter metric_id
  46. Failing sql is:
  47. BEGIN
  48. dbms_server_alert.set_threshold(2104,dbms_server_alert.operator_GT,'1200',NULL,NULL,1,3,'orcl',dbms_server_alert.object_type_SYSTEM,'');COMMIT; END;
  49. Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
  50. Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
  51. Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
  52. . . imported "SYS"."KU$_EXPORT_USER_MAP"                 6.140 KB      42 rows
  53. Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER
  54. Processing object type DATABASE_EXPORT/SCHEMA/XMLSCHEMA/XMLSCHEMA
  55. Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
  56. Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
  57. . . imported "ORDDATA"."ORDDCM_DOCS_TRANSIENT"           252.9 KB       9 rows
  58. . . imported "WMSYS"."E$CONSTRAINTS_TABLE[        DISCUZ_CODE_4        ]quot;                  0 KB       0 rows
  59. . . imported "SYS"."AMGT$DP$AUD[        DISCUZ_CODE_4        ]quot;                            0 KB       0 rows
  60. . . imported "WMSYS"."E$LOCKROWS_INFO[        DISCUZ_CODE_4        ]quot;                      0 KB       0 rows
  61. . . imported "WMSYS"."E$UDTRIG_INFO[        DISCUZ_CODE_4        ]quot;                        0 KB       0 rows
  62. . . imported "SYS"."AMGT$DP$DAM_CLEANUP_EVENTS[        DISCUZ_CODE_4        ]quot;             0 KB       0 rows
  63. . . imported "SYS"."AMGT$DP$DAM_CLEANUP_JOBS[        DISCUZ_CODE_4        ]quot;               0 KB       0 rows
  64. . . imported "SYS"."AMGT$DP$DAM_CONFIG_PARAM[        DISCUZ_CODE_4        ]quot;           6.531 KB      14 rows
  65. . . imported "SYS"."DP$TSDP_ASSOCIATION[        DISCUZ_CODE_4        ]quot;                    0 KB       0 rows
  66. . . imported "SYS"."DP$TSDP_CONDITION[        DISCUZ_CODE_4        ]quot;                      0 KB       0 rows
  67. . . imported "SYS"."DP$TSDP_FEATURE_POLICY[        DISCUZ_CODE_4        ]quot;                 0 KB       0 rows
  68. . . imported "SYS"."DP$TSDP_PARAMETER[        DISCUZ_CODE_4        ]quot;                  5.953 KB       1 rows
  69. . . imported "SYS"."DP$TSDP_POLICY[        DISCUZ_CODE_4        ]quot;                     5.921 KB       1 rows
  70. . . imported "SYS"."DP$TSDP_PROTECTION[        DISCUZ_CODE_4        ]quot;                     0 KB       0 rows
  71. . . imported "SYS"."DP$TSDP_SENSITIVE_DATA[        DISCUZ_CODE_4        ]quot;                 0 KB       0 rows
  72. . . imported "SYS"."DP$TSDP_SENSITIVE_TYPE[        DISCUZ_CODE_4        ]quot;                 0 KB       0 rows
  73. . . imported "SYS"."DP$TSDP_SOURCE[        DISCUZ_CODE_4        ]quot;                         0 KB       0 rows
  74. . . imported "SYS"."DP$TSDP_SUBPOL[        DISCUZ_CODE_4        ]quot;                     6.328 KB       1 rows
  75. . . imported "SYSTEM"."REDO_DB_TMP"                      25.59 KB       1 rows
  76. . . imported "SYSTEM"."REDO_LOG_TMP"                         0 KB       0 rows
  77. . . imported "WMSYS"."E$BATCH_COMPRESSIBLE_TABLES[        DISCUZ_CODE_4        ]quot;          0 KB       0 rows
  78. . . imported "WMSYS"."E$CONS_COLUMNS[        DISCUZ_CODE_4        ]quot;                       0 KB       0 rows
  79. . . imported "WMSYS"."E$ENV_VARS[        DISCUZ_CODE_4        ]quot;                       6.015 KB       3 rows
  80. . . imported "WMSYS"."E$EVENTS_INFO[        DISCUZ_CODE_4        ]quot;                    5.812 KB      12 rows
  81. . . imported "WMSYS"."E$HINT_TABLE[        DISCUZ_CODE_4        ]quot;                     9.453 KB      75 rows
  82. . . imported "WMSYS"."E$MODIFIED_TABLES[        DISCUZ_CODE_4        ]quot;                    0 KB       0 rows
  83. . . imported "WMSYS"."E$MP_GRAPH_WORKSPACES_TABLE[        DISCUZ_CODE_4        ]quot;          0 KB       0 rows
  84. . . imported "WMSYS"."E$MP_PARENT_WORKSPACES_TABLE[        DISCUZ_CODE_4        ]quot;         0 KB       0 rows
  85. . . imported "WMSYS"."E$NESTED_COLUMNS_TABLE[        DISCUZ_CODE_4        ]quot;               0 KB       0 rows
  86. . . imported "WMSYS"."E$NEXTVER_TABLE[        DISCUZ_CODE_4        ]quot;                  6.375 KB       1 rows
  87. . . imported "WMSYS"."E$REMOVED_WORKSPACES_TABLE[        DISCUZ_CODE_4        ]quot;           0 KB       0 rows
  88. . . imported "WMSYS"."E$RESOLVE_WORKSPACES_TABLE[        DISCUZ_CODE_4        ]quot;           0 KB       0 rows
  89. . . imported "WMSYS"."E$RIC_LOCKING_TABLE[        DISCUZ_CODE_4        ]quot;                  0 KB       0 rows
  90. . . imported "WMSYS"."E$RIC_TABLE[        DISCUZ_CODE_4        ]quot;                          0 KB       0 rows
  91. . . imported "WMSYS"."E$RIC_TRIGGERS_TABLE[        DISCUZ_CODE_4        ]quot;                 0 KB       0 rows
  92. . . imported "WMSYS"."E$UDTRIG_DISPATCH_PROCS[        DISCUZ_CODE_4        ]quot;              0 KB       0 rows
  93. . . imported "WMSYS"."E$VERSION_HIERARCHY_TABLE[        DISCUZ_CODE_4        ]quot;        5.984 KB       1 rows
  94. . . imported "WMSYS"."E$VERSION_TABLE[        DISCUZ_CODE_4        ]quot;                      0 KB       0 rows
  95. . . imported "WMSYS"."E$VT_ERRORS_TABLE[        DISCUZ_CODE_4        ]quot;                    0 KB       0 rows
  96. . . imported "WMSYS"."E$WORKSPACES_TABLE[        DISCUZ_CODE_4        ]quot;               12.10 KB       1 rows
  97. . . imported "WMSYS"."E$WORKSPACE_PRIV_TABLE[        DISCUZ_CODE_4        ]quot;           7.054 KB      10 rows
  98. . . imported "WMSYS"."E$WORKSPACE_SAVEPOINTS_TABLE[        DISCUZ_CODE_4        ]quot;         0 KB       0 rows
  99. . . imported "LBACSYS"."OLS_DP$OLS$AUDIT"                    0 KB       0 rows
  100. . . imported "LBACSYS"."OLS_DP$OLS$COMPARTMENTS"             0 KB       0 rows
  101. . . imported "LBACSYS"."OLS_DP$OLS$GROUPS"                   0 KB       0 rows
  102. . . imported "LBACSYS"."OLS_DP$OLS$LAB"                      0 KB       0 rows
  103. . . imported "LBACSYS"."OLS_DP$OLS$LEVELS"                   0 KB       0 rows
  104. . . imported "LBACSYS"."OLS_DP$OLS$POL"                      0 KB       0 rows
  105. . . imported "LBACSYS"."OLS_DP$OLS$POLS"                     0 KB       0 rows
  106. . . imported "LBACSYS"."OLS_DP$OLS$POLT"                     0 KB       0 rows
  107. . . imported "LBACSYS"."OLS_DP$OLS$PROFILE"                  0 KB       0 rows
  108. . . imported "LBACSYS"."OLS_DP$OLS$PROG"                     0 KB       0 rows
  109. . . imported "LBACSYS"."OLS_DP$OLS$USER"                     0 KB       0 rows
  110. Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
  111. Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
  112. . . imported "SYS"."AMGT$DP$FGA_LOG$FOR_EXPORT"              0 KB       0 rows
  113. . . imported "SYSTEM"."SCHEDULER_JOB_ARGS_TMP"               0 KB       0 rows
  114. . . imported "SYSTEM"."SCHEDULER_PROGRAM_ARGS_TMP"       9.515 KB      12 rows
  115. . . imported "SYS"."AMGT$DP$AUDTAB$TBS$FOR_EXPORT"       5.953 KB       2 rows
  116. . . imported "SYS"."DP$DBA_SENSITIVE_DATA"                   0 KB       0 rows
  117. . . imported "SYS"."DP$DBA_TSDP_POLICY_PROTECTION"           0 KB       0 rows
  118. . . imported "SYS"."NACL$_ACE_IMP"                       9.929 KB       1 rows
  119. . . imported "SYS"."NACL$_HOST_IMP"                      6.914 KB       1 rows
  120. . . imported "SYS"."NACL$_WALLET_IMP"                        0 KB       0 rows
  121. . . imported "WMSYS"."E$EXP_MAP"                         7.718 KB       3 rows
  122. Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MARKER
  123. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PROCACT_INSTANCE
  124. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
  125. ORA-39360: Table "OE"."ORDERS" was skipped due to transportable import and TSLTZ issues resulting from time zone mismatch.
  126. ORA-39151: Table "OE"."PURCHASEORDER" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
  127. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
  128. ORA-39112: Dependent object type OBJECT_GRANT:"OE" skipped, base object type TABLE:"OE"."ORDERS" creation failed
  129. ORA-39112: Dependent object type OBJECT_GRANT:"OE" skipped, base object type TABLE:"OE"."ORDERS" creation failed
  130. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
  131. ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
  132. ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
  133. ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
  134. ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
  135. ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
  136. ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
  137. ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
  138. ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
  139. Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
  140. Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
  141. Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
  142. Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
  143. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
  144. ORA-39112: Dependent object type INDEX:"OE"."ORDER_PK" skipped, base object type TABLE:"OE"."ORDERS" creation failed
  145. ORA-39112: Dependent object type INDEX:"OE"."ORD_SALES_REP_IX" skipped, base object type TABLE:"OE"."ORDERS" creation failed
  146. ORA-39112: Dependent object type INDEX:"OE"."ORD_CUSTOMER_IX" skipped, base object type TABLE:"OE"."ORDERS" creation failed
  147. ORA-39112: Dependent object type INDEX:"OE"."ORD_ORDER_DATE_IX" skipped, base object type TABLE:"OE"."ORDERS" creation failed
  148. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
  149. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
  150. ORA-39112: Dependent object type CONSTRAINT:"OE"."ORDER_MODE_LOV" skipped, base object type TABLE:"OE"."ORDERS" creation failed
  151. ORA-39112: Dependent object type CONSTRAINT:"OE"."ORDER_TOTAL_MIN" skipped, base object type TABLE:"OE"."ORDERS" creation failed
  152. ORA-39112: Dependent object type CONSTRAINT:"OE"."ORDER_PK" skipped, base object type TABLE:"OE"."ORDERS" creation failed
  153. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
  154. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
  155. Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
  156. Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
  157. Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
  158. Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODY
  159. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
  160. ORA-39083: Object type REF_CONSTRAINT:"OE"."ORDER_ITEMS_ORDER_ID_FK" failed to create with error:
  161. ORA-00942: table or view does not exist
  162. Failing sql is:
  163. ALTER TABLE "OE"."ORDER_ITEMS" ADD CONSTRAINT "ORDER_ITEMS_ORDER_ID_FK" FOREIGN KEY ("ORDER_ID") REFERENCES "OE"."ORDERS" ("ORDER_ID") ON DELETE CASCADE ENABLE NOVALIDATE
  164. ORA-39112: Dependent object type REF_CONSTRAINT:"OE"."ORDERS_SALES_REP_FK" skipped, base object type TABLE:"OE"."ORDERS" creation failed
  165. ORA-39112: Dependent object type REF_CONSTRAINT:"OE"."ORDERS_CUSTOMER_ID_FK" skipped, base object type TABLE:"OE"."ORDERS" creation failed
  166. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/BITMAP_INDEX/INDEX
  167. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
  168. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
  169. Processing object type DATABASE_EXPORT/STATISTICS/MARKER
  170. OE.ACTION_TABLE_MEMBERS : sqlerrm = ORA-20000: Unable to set values for index ACTION_TABLE_MEMBERS: does not exist or insufficient privileges
  171. OE.LINEITEM_TABLE_MEMBERS : sqlerrm = ORA-20000: Unable to set values for index LINEITEM_TABLE_MEMBERS: does not exist or insufficient privileges
  172. OE.SYS_C0010299 : sqlerrm = ORA-20000: Unable to set values for index SYS_C0010299: does not exist or insufficient privileges
  173. OE.SYS_C0010300 : sqlerrm = ORA-20000: Unable to set values for index SYS_C0010300: does not exist or insufficient privileges
  174. Importing statistics failed for 4 object(s);
  175. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/SECONDARY_TABLE/TABLE
  176. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/SECONDARY_TABLE/INDEX/INDEX
  177. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/SECONDARY_TABLE/CONSTRAINT
  178. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX
  179. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
  180. Processing object type DATABASE_EXPORT/SCHEMA/VIEW/TRIGGER
  181. ORA-39083: Object type TRIGGER:"OE"."ORDERS_ITEMS_TRG" failed to create with error:
  182. ORA-00904: "ORDER_ITEM_LIST": invalid identifier
  183. Failing sql is:
  184. CREATE EDITIONABLE TRIGGER orders_items_trg INSTEAD OF INSERT ON NESTED
  185. TABLE order_item_list OF oc_orders FOR EACH ROW
  186. DECLARE
  187.     prod  product_information_typ;
  188. BEGIN
  189.     SELECT DEREF(:NEW.product_ref) INTO prod FROM DUAL;
  190.     INSERT INTO order_items VALUES (prod.product_id, :NEW.order_id,
  191.                                     :NEW.line_item_id, :NEW.unit_pric
  192. Processing object type DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW
  193. Processing object type DATABASE_EXPORT/SCHEMA/DIMENSION
  194. Processing object type DATABASE_EXPORT/END_PLUGTS_BLK
  195. Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER
  196. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE
  197. Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
  198. Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
  199. ORA-39083: Object type PROCOBJ:"APEX_040200"."ORACLE_APEX_PURGE_SESSIONS" failed to create with error:
  200. ORA-27477: "APEX_040200"."ORACLE_APEX_PURGE_SESSIONS" already exists
  201. Failing sql is:
  202. BEGIN
  203. dbms_scheduler.create_job('"ORACLE_APEX_PURGE_SESSIONS"',
  204. job_type=>'STORED_PROCEDURE', job_action=>
  205. 'WWV_FLOW_CACHE.PURGE_SESSIONS'
  206. , number_of_arguments=>0,
  207. start_date=>TO_TIMESTAMP_TZ('07-JUL-2014 06.29.54.833453000 AM -07:00','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_interval=>
  208. 'FREQ
  209. ORA-39083: Object type PROCOBJ:"APEX_040200"."ORACLE_APEX_MAIL_QUEUE" failed to create with error:
  210. ORA-27477: "APEX_040200"."ORACLE_APEX_MAIL_QUEUE" already exists
  211. Failing sql is:
  212. BEGIN
  213. dbms_scheduler.create_job('"ORACLE_APEX_MAIL_QUEUE"',
  214. job_type=>'STORED_PROCEDURE', job_action=>
  215. 'WWV_FLOW_MAIL.PUSH_QUEUE_IMMEDIATE'
  216. , number_of_arguments=>0,
  217. start_date=>TO_TIMESTAMP_TZ('07-JUL-2014 06.29.55.278873000 AM -07:00','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_interval=>
  218. 'FREQ=MINUTE
  219. ORA-39083: Object type PROCOBJ:"APEX_040200"."ORACLE_APEX_WS_NOTIFICATIONS" failed to create with error:
  220. ORA-27477: "APEX_040200"."ORACLE_APEX_WS_NOTIFICATIONS" already exists
  221. Failing sql is:
  222. BEGIN
  223. dbms_scheduler.create_job('"ORACLE_APEX_WS_NOTIFICATIONS"',
  224. job_type=>'STORED_PROCEDURE', job_action=>
  225. 'WWV_FLOW_WORKSHEET_API.DO_NOTIFY'
  226. , number_of_arguments=>0,
  227. start_date=>TO_TIMESTAMP_TZ('07-JUL-2014 06.29.55.281735000 AM -07:00','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_interval
  228. ORA-39083: Object type PROCOBJ:"APEX_040200"."ORACLE_APEX_DAILY_MAINTENANCE" failed to create with error:
  229. ORA-27477: "APEX_040200"."ORACLE_APEX_DAILY_MAINTENANCE" already exists
  230. Failing sql is:
  231. BEGIN
  232. dbms_scheduler.create_job('"ORACLE_APEX_DAILY_MAINTENANCE"',
  233. job_type=>'STORED_PROCEDURE', job_action=>
  234. 'WWV_FLOW_MAINT.DAILY_MAINTENANCE'
  235. , number_of_arguments=>0,
  236. start_date=>TO_TIMESTAMP_TZ('07-JUL-2014 06.29.55.284760000 AM -07:00','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_inter
  237. Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
  238. Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE
  239. Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
  240. ORA-39082: Object type VIEW:"OE"."ORDERS_VIEW" created with compilation warnings
  241. ORA-39082: Object type VIEW:"OE"."OC_CUSTOMERS" created with compilation warnings
  242. ORA-39082: Object type VIEW:"OE"."OC_CORPORATE_CUSTOMERS" created with compilation warnings
  243. ORA-39082: Object type VIEW:"OE"."OC_ORDERS" created with compilation warnings
  244. ORA-39082: Object type TRIGGER:"OE"."ORDERS_TRG" created with compilation warnings
  245. Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 40 error(s) at Sat Jul 14 15:47:48 2018 elapsed 0 00:02:20

  246. [oracle@station90 bin]$ sqlplus /nolog

  247. SQL*Plus: Release 12.1.0.2.0 Production on Sat Jul 14 15:48:19 2018

  248. Copyright (c) 1982, 2014, Oracle.  All rights reserved.

  249. SQL> conn sys/oracle_4U@pdb_orcl as sysdba
  250. Connected.
  251. SQL> select tablespace_name , status from cdb_tablespaces;

  252. TABLESPACE_NAME                STATUS
  253. ------------------------------ ---------
  254. SYSTEM                               ONLINE
  255. SYSAUX                               ONLINE
  256. TEMP                               ONLINE
  257. EXAMPLE                        ONLINE
  258. USERS                               ONLINE

  259. SQL> select  count(*) from hr.employees;

  260.   COUNT(*)
  261. ----------
  262.        107

  263. SQL>
复制代码


回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Botang唐波's Oracle Station   

GMT+8, 2018-12-19 11:19 , Processed in 0.188454 second(s), 27 queries .

快速回复 返回顶部 返回列表