Hi,
It is new created db on 12.1.0.2.
Why the SYSTEM schema has nothing been bumped?
Export: Release 12.1.0.2.0 - Production on Wed Jun 12 14:47:05 2019
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, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
Starting "EXPUSER"."SYS_EXPORT_SCHEMA_01": expuser/******** directory=DATA_PUMP_DIR schemas=system,scott dumpfile=expdp_tst1218_system_20190612_144705.dump logfile=expdp_tst1218_system_20190612_144705.log compression=all
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 192 KB
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/PRE_SCHEMA/PROCACT_SCHEMA
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/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
. . exported "SCOTT"."DEPT" 5.007 KB 4 rows
. . exported "SCOTT"."EMP" 5.640 KB 14 rows
. . exported "SCOTT"."SALGRADE" 4.921 KB 5 rows
. . exported "SCOTT"."BONUS" 0 KB 0 rows
Master table "EXPUSER"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for EXPUSER.SYS_EXPORT_SCHEMA_01 is:
/u80/exp_daily/tst1218/expdp_tst1218_system_20190612_144705.dump
Job "EXPUSER"."SYS_EXPORT_SCHEMA_01" successfully completed at Wed Jun 12 14:47:29 2019 elapsed 0 00:00:23
On the SCHEMAS parameter, I put SYSTEM,SCOTT but only export SCOTT, the SYSTEM has nothing being exported. The system has objects obviously.
SQL> connect / as sysdba;
Connected.
SQL> set line 300
SQL> col object_type format a30
SQL> select object_type, count(1) from dba_objects where owner='SYSTEM' group by object_type;
OBJECT_TYPE COUNT(1)
------------------------------ ----------
INDEX PARTITION 68
SEQUENCE 22
TABLE PARTITION 46
QUEUE 4
PROCEDURE 1
LOB 23
PACKAGE 1
PACKAGE BODY 1
TRIGGER 2
TABLE 178
INDEX 260
SYNONYM 8
VIEW 14
FUNCTION 4
TYPE 9
15 rows selected.
The expuser has all needed roles (DATAPUMP_EXP_FULL_DATABASE, EXP_FULL_DATABASE)
I cannot see anything wrong. I am almost mad.
Please help.
Thanks
Xiaogang