|
|
检查一下在根容器上有没有统一审计，并且打开新的统一审计：
- select * from audit_unified_enabled_policies;
- CREATE AUDIT POLICY audit_tablespace
- ACTIONS create tablespace;
- select * from audit_unified_enabled_policies;
- audit policy AUDIT_TABLESPACE;
- select * from audit_unified_enabled_policies;
- noaudit policy AUDIT_TABLESPACE;
- select * from audit_unified_enabled_policies;
- select * from audit_unified_policies order by 1;
统一审计轨迹（unified_audit_trail），每个插件数据库看自己的，根容器看全部的：
- SELECT dbusername, action_name, object_name
- 2 FROM unified_audit_trail
- 3 ;
- DBUSERNAME
- ------------------------------
- ACTION_NAME
- ----------------------------------------------------------------
- OBJECT_NAME
- --------------------------------------------------------------------------------
- SYS
- CREATE TABLESPACE
- TBS_ORCL
- SYS
- CREATE TABLESPACE
- TBS_ORCL
- DBUSERNAME
- ------------------------------
- ACTION_NAME
- ----------------------------------------------------------------
- OBJECT_NAME
- --------------------------------------------------------------------------------
- SYS
- COMMIT
- SYS
- COMMIT
- DBUSERNAME
- ------------------------------
- ACTION_NAME
- ----------------------------------------------------------------
- OBJECT_NAME
- --------------------------------------------------------------------------------
- SYS
- LOGON
- SQL> conn sys/oracle_4U@pdb2 as sysdba
- Connected.
- SELECT dbusername, action_name, object_name
- 2 FROM unified_audit_trail
- 3 ;
- DBUSERNAME
- ------------------------------
- ACTION_NAME
- ----------------------------------------------------------------
- OBJECT_NAME
- --------------------------------------------------------------------------------
- SYS
- DROP USER
- LU_PDB2
- SYS
- LOGON
- DBUSERNAME
- ------------------------------
- ACTION_NAME
- ----------------------------------------------------------------
- OBJECT_NAME
- --------------------------------------------------------------------------------
- SYS
- COMMIT
- SYS
- COMMIT
- DBUSERNAME
- ------------------------------
- ACTION_NAME
- ----------------------------------------------------------------
- OBJECT_NAME
- --------------------------------------------------------------------------------
- SYS
- DROP USER
- LU_PDB2
- SQL>
如果找不到审计轨迹，要么等待，要么执行DBMS_AUDIT_MGMT.FLUSH_UNIFIED_AUDIT_TRAIL， 然后再去看 unified_audit_trail。
最后需要区分一下cdb_unified_audit_trail和unidied_audit_trail：
-------------------------------------------------------------逻辑备份的FULL TRANSPORTABLE模式：
expdp help=y
找到TRANSPORTABLE
Specify whether transportable method can be used.
Valid keyword values are: ALWAYS and [NEVER].
采用“嫁接”和“生长”结合的方法移动数据：
/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
- [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
- pdb21/ pdb22/ pdb_orcl/ pdbseed/
- [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'
- Import: Release 12.1.0.2.0 - Production on Sat Jul 14 15:45:24 2018
- Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
- Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
- With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
- and Unified Auditing options
- Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
- Source time zone is +00:00 and target time zone is -07:00.
- 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
- Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
- Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
- Processing object type DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK
- Processing object type DATABASE_EXPORT/TABLESPACE
- ORA-39083: Object type TABLESPACE:"UNDOTBS1" failed to create with error:
- ORA-01516: nonexistent log file, data file, or temporary file "/u01/app/oracle/oradata/orcl/undotbs01.dbf"
- Failing sql is:
- ALTER DATABASE DATAFILE '/u01/app/oracle/oradata/orcl/undotbs01.dbf' RESIZE 157286400
- ORA-31684: Object type TABLESPACE:"TEMP" already exists
- 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/RADM_FPTM
- 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/ON_USER_GRANT
- Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
- Processing object type DATABASE_EXPORT/RESOURCE_COST
- Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
- Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
- Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
- Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
- Processing object type DATABASE_EXPORT/SCHEMA/TYPE/INC_TYPE
- 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
- ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
- ORA-65040: operation not allowed from within a pluggable database
- ORA-13900: missing or invalid parameter metric_id
- Failing sql is:
- BEGIN
- 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;
- Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
- Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
- Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
- . . imported "SYS"."KU$_EXPORT_USER_MAP" 6.140 KB 42 rows
- Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER
- Processing object type DATABASE_EXPORT/SCHEMA/XMLSCHEMA/XMLSCHEMA
- Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
- Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
- . . imported "ORDDATA"."ORDDCM_DOCS_TRANSIENT" 252.9 KB 9 rows
- . . imported "WMSYS"."E$CONSTRAINTS_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "SYS"."AMGT$DP$AUD[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "WMSYS"."E$LOCKROWS_INFO[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "WMSYS"."E$UDTRIG_INFO[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "SYS"."AMGT$DP$DAM_CLEANUP_EVENTS[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "SYS"."AMGT$DP$DAM_CLEANUP_JOBS[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "SYS"."AMGT$DP$DAM_CONFIG_PARAM[ DISCUZ_CODE_4 ]quot; 6.531 KB 14 rows
- . . imported "SYS"."DP$TSDP_ASSOCIATION[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "SYS"."DP$TSDP_CONDITION[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "SYS"."DP$TSDP_FEATURE_POLICY[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "SYS"."DP$TSDP_PARAMETER[ DISCUZ_CODE_4 ]quot; 5.953 KB 1 rows
- . . imported "SYS"."DP$TSDP_POLICY[ DISCUZ_CODE_4 ]quot; 5.921 KB 1 rows
- . . imported "SYS"."DP$TSDP_PROTECTION[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "SYS"."DP$TSDP_SENSITIVE_DATA[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "SYS"."DP$TSDP_SENSITIVE_TYPE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "SYS"."DP$TSDP_SOURCE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "SYS"."DP$TSDP_SUBPOL[ DISCUZ_CODE_4 ]quot; 6.328 KB 1 rows
- . . imported "SYSTEM"."REDO_DB_TMP" 25.59 KB 1 rows
- . . imported "SYSTEM"."REDO_LOG_TMP" 0 KB 0 rows
- . . imported "WMSYS"."E$BATCH_COMPRESSIBLE_TABLES[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "WMSYS"."E$CONS_COLUMNS[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "WMSYS"."E$ENV_VARS[ DISCUZ_CODE_4 ]quot; 6.015 KB 3 rows
- . . imported "WMSYS"."E$EVENTS_INFO[ DISCUZ_CODE_4 ]quot; 5.812 KB 12 rows
- . . imported "WMSYS"."E$HINT_TABLE[ DISCUZ_CODE_4 ]quot; 9.453 KB 75 rows
- . . imported "WMSYS"."E$MODIFIED_TABLES[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "WMSYS"."E$MP_GRAPH_WORKSPACES_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "WMSYS"."E$MP_PARENT_WORKSPACES_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "WMSYS"."E$NESTED_COLUMNS_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "WMSYS"."E$NEXTVER_TABLE[ DISCUZ_CODE_4 ]quot; 6.375 KB 1 rows
- . . imported "WMSYS"."E$REMOVED_WORKSPACES_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "WMSYS"."E$RESOLVE_WORKSPACES_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "WMSYS"."E$RIC_LOCKING_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "WMSYS"."E$RIC_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "WMSYS"."E$RIC_TRIGGERS_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "WMSYS"."E$UDTRIG_DISPATCH_PROCS[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "WMSYS"."E$VERSION_HIERARCHY_TABLE[ DISCUZ_CODE_4 ]quot; 5.984 KB 1 rows
- . . imported "WMSYS"."E$VERSION_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "WMSYS"."E$VT_ERRORS_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "WMSYS"."E$WORKSPACES_TABLE[ DISCUZ_CODE_4 ]quot; 12.10 KB 1 rows
- . . imported "WMSYS"."E$WORKSPACE_PRIV_TABLE[ DISCUZ_CODE_4 ]quot; 7.054 KB 10 rows
- . . imported "WMSYS"."E$WORKSPACE_SAVEPOINTS_TABLE[ DISCUZ_CODE_4 ]quot; 0 KB 0 rows
- . . imported "LBACSYS"."OLS_DP$OLS$AUDIT" 0 KB 0 rows
- . . imported "LBACSYS"."OLS_DP$OLS$COMPARTMENTS" 0 KB 0 rows
- . . imported "LBACSYS"."OLS_DP$OLS$GROUPS" 0 KB 0 rows
- . . imported "LBACSYS"."OLS_DP$OLS$LAB" 0 KB 0 rows
- . . imported "LBACSYS"."OLS_DP$OLS$LEVELS" 0 KB 0 rows
- . . imported "LBACSYS"."OLS_DP$OLS$POL" 0 KB 0 rows
- . . imported "LBACSYS"."OLS_DP$OLS$POLS" 0 KB 0 rows
- . . imported "LBACSYS"."OLS_DP$OLS$POLT" 0 KB 0 rows
- . . imported "LBACSYS"."OLS_DP$OLS$PROFILE" 0 KB 0 rows
- . . imported "LBACSYS"."OLS_DP$OLS$PROG" 0 KB 0 rows
- . . imported "LBACSYS"."OLS_DP$OLS$USER" 0 KB 0 rows
- Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
- Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
- . . imported "SYS"."AMGT$DP$FGA_LOG$FOR_EXPORT" 0 KB 0 rows
- . . imported "SYSTEM"."SCHEDULER_JOB_ARGS_TMP" 0 KB 0 rows
- . . imported "SYSTEM"."SCHEDULER_PROGRAM_ARGS_TMP" 9.515 KB 12 rows
- . . imported "SYS"."AMGT$DP$AUDTAB$TBS$FOR_EXPORT" 5.953 KB 2 rows
- . . imported "SYS"."DP$DBA_SENSITIVE_DATA" 0 KB 0 rows
- . . imported "SYS"."DP$DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows
- . . imported "SYS"."NACL$_ACE_IMP" 9.929 KB 1 rows
- . . imported "SYS"."NACL$_HOST_IMP" 6.914 KB 1 rows
- . . imported "SYS"."NACL$_WALLET_IMP" 0 KB 0 rows
- . . imported "WMSYS"."E$EXP_MAP" 7.718 KB 3 rows
- Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MARKER
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PROCACT_INSTANCE
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
- ORA-39360: Table "OE"."ORDERS" was skipped due to transportable import and TSLTZ issues resulting from time zone mismatch.
- ORA-39151: Table "OE"."PURCHASEORDER" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
- ORA-39112: Dependent object type OBJECT_GRANT:"OE" skipped, base object type TABLE:"OE"."ORDERS" creation failed
- ORA-39112: Dependent object type OBJECT_GRANT:"OE" skipped, base object type TABLE:"OE"."ORDERS" creation failed
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
- ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
- ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
- ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
- ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
- ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
- ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
- ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
- ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"OE"."ORDERS" creation failed
- Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
- Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
- Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
- Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
- ORA-39112: Dependent object type INDEX:"OE"."ORDER_PK" skipped, base object type TABLE:"OE"."ORDERS" creation failed
- ORA-39112: Dependent object type INDEX:"OE"."ORD_SALES_REP_IX" skipped, base object type TABLE:"OE"."ORDERS" creation failed
- ORA-39112: Dependent object type INDEX:"OE"."ORD_CUSTOMER_IX" skipped, base object type TABLE:"OE"."ORDERS" creation failed
- ORA-39112: Dependent object type INDEX:"OE"."ORD_ORDER_DATE_IX" skipped, base object type TABLE:"OE"."ORDERS" creation failed
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
- ORA-39112: Dependent object type CONSTRAINT:"OE"."ORDER_MODE_LOV" skipped, base object type TABLE:"OE"."ORDERS" creation failed
- ORA-39112: Dependent object type CONSTRAINT:"OE"."ORDER_TOTAL_MIN" skipped, base object type TABLE:"OE"."ORDERS" creation failed
- ORA-39112: Dependent object type CONSTRAINT:"OE"."ORDER_PK" skipped, base object type TABLE:"OE"."ORDERS" creation failed
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
- 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/TYPE/TYPE_BODY
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
- ORA-39083: Object type REF_CONSTRAINT:"OE"."ORDER_ITEMS_ORDER_ID_FK" failed to create with error:
- ORA-00942: table or view does not exist
- Failing sql is:
- 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
- ORA-39112: Dependent object type REF_CONSTRAINT:"OE"."ORDERS_SALES_REP_FK" skipped, base object type TABLE:"OE"."ORDERS" creation failed
- ORA-39112: Dependent object type REF_CONSTRAINT:"OE"."ORDERS_CUSTOMER_ID_FK" skipped, base object type TABLE:"OE"."ORDERS" creation failed
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/BITMAP_INDEX/INDEX
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
- Processing object type DATABASE_EXPORT/STATISTICS/MARKER
- OE.ACTION_TABLE_MEMBERS : sqlerrm = ORA-20000: Unable to set values for index ACTION_TABLE_MEMBERS: does not exist or insufficient privileges
- OE.LINEITEM_TABLE_MEMBERS : sqlerrm = ORA-20000: Unable to set values for index LINEITEM_TABLE_MEMBERS: does not exist or insufficient privileges
- OE.SYS_C0010299 : sqlerrm = ORA-20000: Unable to set values for index SYS_C0010299: does not exist or insufficient privileges
- OE.SYS_C0010300 : sqlerrm = ORA-20000: Unable to set values for index SYS_C0010300: does not exist or insufficient privileges
- Importing statistics failed for 4 object(s);
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/SECONDARY_TABLE/TABLE
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/SECONDARY_TABLE/INDEX/INDEX
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/SECONDARY_TABLE/CONSTRAINT
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
- Processing object type DATABASE_EXPORT/SCHEMA/VIEW/TRIGGER
- ORA-39083: Object type TRIGGER:"OE"."ORDERS_ITEMS_TRG" failed to create with error:
- ORA-00904: "ORDER_ITEM_LIST": invalid identifier
- Failing sql is:
- CREATE EDITIONABLE TRIGGER orders_items_trg INSTEAD OF INSERT ON NESTED
- TABLE order_item_list OF oc_orders FOR EACH ROW
- DECLARE
- prod product_information_typ;
- BEGIN
- SELECT DEREF(:NEW.product_ref) INTO prod FROM DUAL;
- INSERT INTO order_items VALUES (prod.product_id, :NEW.order_id,
- :NEW.line_item_id, :NEW.unit_pric
- Processing object type DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW
- Processing object type DATABASE_EXPORT/SCHEMA/DIMENSION
- Processing object type DATABASE_EXPORT/END_PLUGTS_BLK
- Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE
- Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
- Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
- ORA-39083: Object type PROCOBJ:"APEX_040200"."ORACLE_APEX_PURGE_SESSIONS" failed to create with error:
- ORA-27477: "APEX_040200"."ORACLE_APEX_PURGE_SESSIONS" already exists
- Failing sql is:
- BEGIN
- dbms_scheduler.create_job('"ORACLE_APEX_PURGE_SESSIONS"',
- job_type=>'STORED_PROCEDURE', job_action=>
- 'WWV_FLOW_CACHE.PURGE_SESSIONS'
- , number_of_arguments=>0,
- 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=>
- 'FREQ
- ORA-39083: Object type PROCOBJ:"APEX_040200"."ORACLE_APEX_MAIL_QUEUE" failed to create with error:
- ORA-27477: "APEX_040200"."ORACLE_APEX_MAIL_QUEUE" already exists
- Failing sql is:
- BEGIN
- dbms_scheduler.create_job('"ORACLE_APEX_MAIL_QUEUE"',
- job_type=>'STORED_PROCEDURE', job_action=>
- 'WWV_FLOW_MAIL.PUSH_QUEUE_IMMEDIATE'
- , number_of_arguments=>0,
- 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=>
- 'FREQ=MINUTE
- ORA-39083: Object type PROCOBJ:"APEX_040200"."ORACLE_APEX_WS_NOTIFICATIONS" failed to create with error:
- ORA-27477: "APEX_040200"."ORACLE_APEX_WS_NOTIFICATIONS" already exists
- Failing sql is:
- BEGIN
- dbms_scheduler.create_job('"ORACLE_APEX_WS_NOTIFICATIONS"',
- job_type=>'STORED_PROCEDURE', job_action=>
- 'WWV_FLOW_WORKSHEET_API.DO_NOTIFY'
- , number_of_arguments=>0,
- 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
- ORA-39083: Object type PROCOBJ:"APEX_040200"."ORACLE_APEX_DAILY_MAINTENANCE" failed to create with error:
- ORA-27477: "APEX_040200"."ORACLE_APEX_DAILY_MAINTENANCE" already exists
- Failing sql is:
- BEGIN
- dbms_scheduler.create_job('"ORACLE_APEX_DAILY_MAINTENANCE"',
- job_type=>'STORED_PROCEDURE', job_action=>
- 'WWV_FLOW_MAINT.DAILY_MAINTENANCE'
- , number_of_arguments=>0,
- 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
- Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
- Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE
- Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
- ORA-39082: Object type VIEW:"OE"."ORDERS_VIEW" created with compilation warnings
- ORA-39082: Object type VIEW:"OE"."OC_CUSTOMERS" created with compilation warnings
- ORA-39082: Object type VIEW:"OE"."OC_CORPORATE_CUSTOMERS" created with compilation warnings
- ORA-39082: Object type VIEW:"OE"."OC_ORDERS" created with compilation warnings
- ORA-39082: Object type TRIGGER:"OE"."ORDERS_TRG" created with compilation warnings
- Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 40 error(s) at Sat Jul 14 15:47:48 2018 elapsed 0 00:02:20
- [oracle@station90 bin]$ sqlplus /nolog
- SQL*Plus: Release 12.1.0.2.0 Production on Sat Jul 14 15:48:19 2018
- Copyright (c) 1982, 2014, Oracle. All rights reserved.
- SQL> conn sys/oracle_4U@pdb_orcl as sysdba
- Connected.
- SQL> select tablespace_name , status from cdb_tablespaces;
- TABLESPACE_NAME STATUS
- ------------------------------ ---------
- SYSTEM ONLINE
- SYSAUX ONLINE
- TEMP ONLINE
- EXAMPLE ONLINE
- USERS ONLINE
- SQL> select count(*) from hr.employees;
- COUNT(*)
- ----------
- 107
- SQL>
|
|
发表于 2018-7-14 14:47:14
