[20260514]21c expdp使用报错(UDE-31623 operation generated ORACLE error 31623).txt
--//测试环境使用expdp报错.
1.环境：
SYS@book> @ ver2
==============================
PORT_STRING : x86_64/Linux 2.4.xx
VERSION : 21.0.0.0.0
BANNER : Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
BANNER_FULL : Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
BANNER_LEGACY : Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
CON_ID : 0
PL/SQL procedure successfully completed.
2.问题：
$ expdp scott/book@book01p DUMPFILE=scott.dp
Export: Release 21.0.0.0.0 - Production on Wed May 13 16:52:14 2026
Version 21.3.0.0.0
Copyright (c) 1982, 2021, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4747
ORA-06512: at "SYS.KUPV$FT_INT", line 2330
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2245
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2263
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4496
ORA-06512: at "SYS.DBMS_DATAPUMP", line 6127
ORA-06512: at line 1
$ oerrz 31623
31623, 00000, "a job is not attached to this session via the specified handle"
// *Cause: An attempt to reference a job using a handle which is invalid or
// no longer valid for the current session.
// *Action: Select a handle corresponding to a valid active job or start a
// new job.
3.分析:
--//仔细查看alert日志，发现如下内容:
2026-05-13T17:00:41.574664+08:00
Errors in file /u01/app/oracle/diag/rdbms/book/book/trace/book_ora_7382.trc (incident=4418184) (PDBNAME=BOOK01P):
ORA-04031: unable to allocate 56 bytes of shared memory ("streams pool","unknown object","streams pool","fixed allocation callback")
BOOK01P(3):Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
SYS@book> show parameter stream
PARAMETER_NAME TYPE VALUE
------------------ ----------- -------
streams_pool_size big integer 0
--//上网查询可以找到许多类似链接,提示streams_pool_size设置太小.实际上主要原因是无法扩展.我的测试环境为了避免
--//shared_pool_size,db_cache_size变化频繁.我设置最小值,这样导致streams_pool_size无法扩展.
SYS@book> @ pvz ^shared_pool_size|^db_cache_size
INST_ID NUM N_HEX NAME DESCRIPTION SESSION_VALUE SYSTEM_VALUE DEFAULT_VALUE ISDEFAULT ISSES_MOD ISSYS_MOD ISPDB_MOD ISINSTANCE_MODIFIABLE ISMODIFIED ISDEPRECATED CON_ID
------- ----- ----- ---------------- ------------------------------------------------------------ ------------- ------------ ------------- --------- --------- --------- --------- --------------------- ---------- ------------ ------
1 294 126 shared_pool_size size in bytes of shared pool 503316480 503316480 134217728 FALSE FALSE IMMEDIATE TRUE TRUE FALSE FALSE 0
1 294 126 shared_pool_size size in bytes of shared pool 503316480 0 134217728 FALSE FALSE IMMEDIATE TRUE TRUE FALSE FALSE 2
1 294 126 shared_pool_size size in bytes of shared pool 503316480 0 134217728 FALSE FALSE IMMEDIATE TRUE TRUE FALSE FALSE 3
1 1876 754 db_cache_size Size of DEFAULT buffer pool for standard block size buffers 436207616 436207616 0 FALSE FALSE IMMEDIATE TRUE TRUE FALSE FALSE 0
1 1876 754 db_cache_size Size of DEFAULT buffer pool for standard block size buffers 436207616 0 0 FALSE FALSE IMMEDIATE TRUE TRUE FALSE FALSE 2
1 1876 754 db_cache_size Size of DEFAULT buffer pool for standard block size buffers 436207616 0 0 FALSE FALSE IMMEDIATE TRUE TRUE FALSE FALSE 3
6 rows selected.
--//增加sga_target=1088m，原来1072M。
$ grep -v "^#" initbook.ora
SPFILE='/u01/app/oracle/dbs/spfilebook.ora'
sga_target=1088m
sga_max_size=1088m
# sysctl -w vm.nr_hugepages=546
vm.nr_hugepages = 546
--//使用参数文件重启数据库看看。
$ expdp scott/book@book01p DUMPFILE=scott.dp
Export: Release 21.0.0.0.0 - Production on Thu May 14 09:28:21 2026
Version 21.3.0.0.0
Copyright (c) 1982, 2021, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
FLASHBACK automatically enabled to preserve database integrity.
--//原来没有注意这行内容，oracle自动保持数据的完整性。看来如果expdp时间太长，会报ora-01555错误.
--//注：我看了19c的expdp导出，发现没有这行。估计21c改进增加expdp。
Starting "SCOTT"."SYS_EXPORT_SCHEMA_01": scott/a******@book01p DUMPFILE=scott.dp
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ORACLE_OBJECT_GRANT/OBJECT_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/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
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/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-39127: unexpected error from call to BEGIN :1 := SYS.DBMS_JAVA.START_EXPORT(:2, :3, :4, :5, :6, :7, :8, :9 ,:10); END;
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","java/lang/Byte","JOXLE^c5d80c10",":SGAClass")
ORA-06512: at "SYS.DBMS_JAVA", line 520
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_JAVA", line 520
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 11908
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-39127: unexpected error from call to BEGIN :1 := SYS.DBMS_JAVA.START_EXPORT(:2, :3, :4, :5, :6, :7, :8, :9 ,:10); END;
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","java/lang/Byte","JOXLE^c5d80c10",":SGAClass")
ORA-06512: at "SYS.DBMS_JAVA", line 520
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_JAVA", line 520
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 11908
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-39127: unexpected error from call to BEGIN :1 := SYS.DBMS_JAVA.START_EXPORT(:2, :3, :4, :5, :6, :7, :8, :9 ,:10); END;
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","java/lang/Byte","JOXLE^c5d80c10",":SGAClass")
ORA-06512: at "SYS.DBMS_JAVA", line 520
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_JAVA", line 520
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 11908
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
Processing object type SCHEMA_EXPORT/JAVA_SOURCE/JAVA_SOURCE
ORA-39127: unexpected error from call to BEGIN :1 := SYS.DBMS_JAVA.START_EXPORT(:2, :3, :4, :5, :6, :7, :8, :9 ,:10); END;
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","java/lang/Byte","JOXLE^c5d80c10",":SGAClass")
ORA-06512: at "SYS.DBMS_JAVA", line 520
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_JAVA", line 520
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 11908
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-39127: unexpected error from call to BEGIN :1 := SYS.DBMS_JAVA.START_EXPORT(:2, :3, :4, :5, :6, :7, :8, :9 ,:10); END;
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","java/lang/Byte","JOXLE^c5d80c10",":SGAClass")
ORA-06512: at "SYS.DBMS_JAVA", line 520
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_JAVA", line 520
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 11908
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-39127: unexpected error from call to BEGIN :1 := SYS.DBMS_JAVA.START_EXPORT(:2, :3, :4, :5, :6, :7, :8, :9 ,:10); END;
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","java/lang/Byte","JOXLE^c5d80c10",":SGAClass")
ORA-06512: at "SYS.DBMS_JAVA", line 520
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_JAVA", line 520
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 11908
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
Processing object type SCHEMA_EXPORT/JAVA_CLASS/JAVA_CLASS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "SCOTT"."EMP" 8.773 KB 14 rows
. . exported "SCOTT"."DEPT" 6.023 KB 4 rows
. . exported "SCOTT"."SALGRADE" 5.953 KB 5 rows
. . exported "SCOTT"."BONUS" 0 KB 0 rows
. . exported "SCOTT"."JOB_TIMES" 9.078 KB 30 rows
. . exported "SCOTT"."TEST" 6.078 KB 5 rows
Master table "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_SCHEMA_01 is:
/u01/app/oracle/admin/book/dpdump/1F36F47256D41C08E0636538A8C03260/scott.dp
Job "SCOTT"."SYS_EXPORT_SCHEMA_01" completed with 6 error(s) at Thu May 14 09:33:10 2026 elapsed 0 00:01:37
$ ls -l /u01/app/oracle/admin/book/dpdump/1F36F47256D41C08E0636538A8C03260/scott.dp
-rw-r-----. 1 oracle oinstall 630784 2026-05-14 09:33:10 /u01/app/oracle/admin/book/dpdump/1F36F47256D41C08E0636538A8C03260/scott.dp
--//可以看出java pool设置太小。
$ ls -l /dev/shm/
total 3328
-rwxrwx---. 1 oracle oinstall 2097152 2026-05-14 09:32:33 JOEZSHM_book_1_1_0_0_0_18446744071606740893
-rwxrwx---. 1 oracle oinstall 1310720 2026-05-14 09:32:33 JOEZSHM_book_1_1073777561_0_0_0_18446744071606740893
drwxr-x---. 2 oracle oinstall 40 2026-05-14 09:19:03 orahpatch_book
--//Sum = 3407872
--//3407872/1024/1024 = 3.25
4.重新调整相关参数:
SYS@book> alter system set streams_pool_size=32m scope=spfile;
System altered.
SYS@book> alter system set java_pool_size=32M scope=spfile;
System altered.
SYS@book> startup pfile=/u01/app/oracle/dbs/initbook.ora
ORA-00821: Specified value of sga_target 1088M is too small, needs to be at least 1104M
ORA-01078: failure in processing system parameters
$ grep -v "^#" initbook.ora
SPFILE='/u01/app/oracle/dbs/spfilebook.ora'
sga_target=1104m
sga_max_size=1104m
# sysctl -w vm.nr_hugepages=600
vm.nr_hugepages = 600
SYS@book> startup
ORACLE instance started.
Total System Global Area 1157625848 bytes
Fixed Size 9684984 bytes
Variable Size 704643072 bytes
Database Buffers 436207616 bytes
Redo Buffers 7090176 bytes
Database mounted.
Database opened.
# grep -i hugepage /proc/meminfo
AnonHugePages: 118784 kB
HugePages_Total: 600
HugePages_Free: 53
HugePages_Rsvd: 7
HugePages_Surp: 0
Hugepagesize: 2048 kB
--// 600-53+7 = 554
--//设置vm.nr_hugepages=554
--//重新启动再次尝试，这回没有问题了。
$ expdp scott/book@book01p DUMPFILE=scott.dp1
Export: Release 21.0.0.0.0 - Production on Thu May 14 09:41:43 2026
Version 21.3.0.0.0
Copyright (c) 1982, 2021, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
FLASHBACK automatically enabled to preserve database integrity.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--//不知道是否与我测试环境没有打开归档相关。
--//注：打开归档测试，还是出现该提示，说明21c对expdp做了改进。
Starting "SCOTT"."SYS_EXPORT_SCHEMA_01": scott/a********@book01p DUMPFILE=scott.dp1
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ORACLE_OBJECT_GRANT/OBJECT_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/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
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/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/JAVA_SOURCE/JAVA_SOURCE
Processing object type SCHEMA_EXPORT/JAVA_CLASS/JAVA_CLASS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "SCOTT"."EMP" 8.773 KB 14 rows
. . exported "SCOTT"."DEPT" 6.023 KB 4 rows
. . exported "SCOTT"."SALGRADE" 5.953 KB 5 rows
. . exported "SCOTT"."BONUS" 0 KB 0 rows
. . exported "SCOTT"."JOB_TIMES" 9.078 KB 30 rows
. . exported "SCOTT"."TEST" 6.078 KB 5 rows
Master table "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_SCHEMA_01 is:
/u01/app/oracle/admin/book/dpdump/1F36F47256D41C08E0636538A8C03260/scott.dp1
Job "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully completed at Thu May 14 09:42:49 2026 elapsed 0 00:01:03
--//这次正常。
$ ls -l /dev/shm/
total 20736
-rwxrwx---. 1 oracle oinstall 2097152 2026-05-14 09:42:42 JOEZSHM_book_1_1_0_0_0_18446744071606741613
-rwxrwx---. 1 oracle oinstall 1048576 2026-05-14 09:42:43 JOEZSHM_book_1_1_0_1_0_18446744071606741613
-rwxrwx---. 1 oracle oinstall 1310720 2026-05-14 09:42:41 JOEZSHM_book_1_1073777561_0_0_0_18446744071606741613
-rwxrwx---. 1 oracle oinstall 16777216 2026-05-14 09:42:41 JOEZSHM_book_1_1073777561_0_1_0_18446744071606741613
drwxr-x---. 2 oracle oinstall 40 2026-05-14 09:19:03 orahpatch_book
SYS@book> @ pvz ^shared_pool_size|^db_cache_size|^stream|^java_pool
INST_ID NUM N_HEX NAME DESCRIPTION SESSION_VALUE SYSTEM_VALUE DEFAULT_VALUE ISDEFAULT ISSES_MOD ISSYS_MOD ISPDB_MOD ISINSTANCE_MODIFIABLE ISMODIFIED ISDEPRECATED CON_ID
------- ----- ----- ----------------- ------------------------------------------------------------ ------------- ------------ ------------- --------- --------- --------- --------- --------------------- ---------- ------------ ------
1 294 126 shared_pool_size size in bytes of shared pool 503316480 503316480 134217728 FALSE FALSE IMMEDIATE TRUE TRUE FALSE FALSE 0
1 294 126 shared_pool_size size in bytes of shared pool 503316480 0 134217728 FALSE FALSE IMMEDIATE TRUE TRUE FALSE FALSE 2
1 294 126 shared_pool_size size in bytes of shared pool 503316480 0 134217728 FALSE FALSE IMMEDIATE TRUE TRUE FALSE FALSE 3
1 298 12A java_pool_size size in bytes of java pool 33554432 33554432 25165824 FALSE FALSE IMMEDIATE FALSE TRUE FALSE FALSE 0
1 300 12C streams_pool_size size in bytes of the streams pool 33554432 33554432 0 FALSE FALSE IMMEDIATE FALSE TRUE FALSE FALSE 0
1 1876 754 db_cache_size Size of DEFAULT buffer pool for standard block size buffers 436207616 436207616 0 FALSE FALSE IMMEDIATE TRUE TRUE FALSE FALSE 0
1 1876 754 db_cache_size Size of DEFAULT buffer pool for standard block size buffers 436207616 0 0 FALSE FALSE IMMEDIATE TRUE TRUE FALSE FALSE 2
1 1876 754 db_cache_size Size of DEFAULT buffer pool for standard block size buffers 436207616 0 0 FALSE FALSE IMMEDIATE TRUE TRUE FALSE FALSE 3
8 rows selected.
5.顺便贴一个以前在19c的expdp操作：
$ expdp system directory=ORACLE_BASE dumpfile=aud.dump include=audit_trails full=yes
Export: Release 19.0.0.0.0 - Production on Fri May 16 16:44:16 2025
Version 19.24.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Warning: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.
Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/a***** directory=ORACLE_BASE dumpfile=aud.dump include=audit_trails full=yes
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
.. exported "SYS"."KU$_USER_MAPPING_VIEW" 6.101 KB 38 rows
.. exported "AUDSYS"."AUD$UNIFIED":"SYS_P181" 131.2 KB 167 rows
.. exported "AUDSYS"."AUD$UNIFIED":"SYS_P3321" 56.99 KB 17 rows
.. exported "AUDSYS"."AUD$UNIFIED":"SYS_P1901" 56.38 KB 19 rows
.. exported "AUDSYS"."AUD$UNIFIED":"SYS_P4621" 55.69 KB 11 rows
.. exported "SYS"."DAM_CONFIG_PARAM$" 6.531 KB 14 rows
.. exported "AUDSYS"."AUD$UNIFIED":"AUD_UNIFIED_P0" 0 KB 0 rows
.. exported "SYS"."AUD$" 0 KB 0 rows
.. exported "SYS"."DAM_CLEANUP_EVENTS$" 0 KB 0 rows
.. exported "SYS"."DAM_CLEANUP_JOBS$" 0 KB 0 rows
.. exported "SYS"."AUDTAB$TBS$FOR_EXPORT" 5.953 KB 2 rows
.. exported "SYS"."FGA_LOG$FOR_EXPORT" 0 KB 0 rows
Master table "SYSTEM"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_FULL_01 is:
/data/app/oracle/aud.dump
Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed at Fri May 16 16:45:39 2025 elapsed 0 00:01:06
--//实际上还导出相关的表，不仅仅包括AUDSYS.AUD$UNIFIED。
--//没有FLASHBACK automatically enabled to preserve database integrity.这行信息.
[20260514]21c expdp使用报错(UDE-31623 operation generated ORACLE error 31623)
-
lfree
2026-05-17 19:38:00 -
Oracle
- 原创