19c CDB架构下使用具有SYSBACKUP权限用户执行DataPump-expdp报ORA-01045和ORA-39406
适用范围
Oracle Database 19c
问题概述
19c CDB架构中使用具有sysbackup权限的用户或者sysbackup角色用户执行expdp报以下错误
ORA-01045: user C##BACKUPUSER lacks CREATE SESSION privilege; logon denied
ORA-39406: Job mode SCHEMA is not permitted when running as SYSBACKUP.
ORA-39406: Job mode SCHEMA is not permitted when running as SYSBACKUP.
问题原因
1、创建的公共用户权限不足；
2、sysbackup角色登录执行expdp时对FUUL，SCHEMA的两种模式有限制。
解决方案
1、创建一个具有 SYSBACKUP 权限的公共用户，不撤sysbackup管理权限的任何权限，并将 DATAPUMP_EXP_FULL_DATABASE/DATAPUMP_IMP_FULL_DATABASE 角色分配给执行expdp的用户；
2、执行expdp的全库级FULL=Y和SCHEMA级不以sysbackup身份执行。
<1>在 CDB 级别创建公共用户并授予备份与 DataPump 权限
— 登录到CDB
SQL>CREATE USER C##BACKUPUSER IDENTIFIED BY “” CONTAINER=ALL;
SQL>GRANT SYSBACKUP TO C##BACKUPUSER CONTAINER=ALL;
SQL>GRANT DATAPUMP_EXP_FULL_DATABASE, DATAPUMP_IMP_FULL_DATABASE TO C##BACKUPUSER CONTAINER=ALL;
<2>在目标 PDB 中授予基础会话权限及表空间配额
— 切换到对应的 PDB（如 HRPDB）
SQL>ALTER SESSION SET CONTAINER=hrpdb;
SQL>GRANT CREATE SESSION TO C##BACKUPUSER;
SQL>ALTER USER C##BACKUPUSER QUOTA UNLIMITED ON USERS; — 用于创建 DataPump 主表
<3>使用常规身份（不带 as sysbackup）执行导出
expdp C##BACKUPUSER/@hrpdb directory=IMP_DIR dumpfile=hrpdb_full_%U.dmp full=y logfile=hrpdb_full.log logtime=all
分析过程
1、创建具有SYSBACKUP权限的用户并授权
--登录CDB
[oracle@19cdb01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 06 19:45:40 2026
Version 19.27.0.0.0
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.27.0.0.0
Hello
------------------------------------------------
Welcome! you are connected to CDB19C database
CONNAME
--------------------------------------------------------------------------------
CDB$ROOT
--创建备份用户C##BACKUPUSER并授予sysbackup管理权限
SYS@cdb19c(CDB$ROOT)> create user C##BACKUPUSER identified by <your_password> container=all;
User created.
SYS@cdb19c(CDB$ROOT)> grant sysbackup to C##BACKUPUSER container=all;
Grant succeeded.
SYS@cdb19c(CDB$ROOT)>2、检查SYSBACKUP和C##BACKUPUSER用户对密码文件的权限
SYS@cdb19c(CDB$ROOT)> select USERNAME,SYSDBA,SYSBACKUP,ACCOUNT_STATUS,COMMON,CON_ID from v$pwfile_users;
USERNAME SYSDB SYSBA ACCOUNT_STATUS COM CON_ID
-------------------- ----- ----- ------------------------------ --- ----------
SYS TRUE FALSE OPEN YES 0
C##BACKUPUSER FALSE TRUE OPEN YES 0
SYSBACKUP FALSE TRUE OPEN YES 0
SYS@cdb19c(CDB$ROOT)>3、使用C##BACKUPUSER用户在PDB中执行expdp
[oracle@19cdb01 ~]$ expdp C##BACKUPUSER/<your_password>@hrpdb directory=IMP_DIR dumpfile=hrpdb_full_20260706.dmp full=y logfile=hrpdb_full_log_20260706.log logtime=all
Export: Release 19.0.0.0.0 - Production on Mon Jul 06 17:56:23 2026
Version 19.27.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
UDE-01045: operation generated ORACLE error 1045
ORA-01045: user C##BACKUPUSER lacks CREATE SESSION privilege; logon deniedORA-01045 C##BACKUPUSER用户缺少 CREATE SESSION权限，expdp执行失败。
4、验证C##BACKUPUSER用户登录
--通过sqlplus工具用户C##BACKUPUSER用户以常规身份连接数据库
[oracle@19cdb01 ~]$ sqlplus C##BACKUPUSER/<your_password>@hrpdb
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 06 17:58:12 2026
Version 19.27.0.0.0
Copyright (c) 1982, 2024, Oracle. All rights reserved.
ERROR:
ORA-01045: user C##BACKUPUSER lacks CREATE SESSION privilege; logon denied使用sqplus工具用户C##BACKUPUSER连接数据库报ORA-01045: user C##BACKUPUSER lacks CREATE SESSION privilege，该用户没有CREATE SESSION权限。
----通过sqlplus工具用户C##BACKUPUSER用户以SYSBACKUP身份连接数据库
[oracle@19cdb01 ~]$ sqlplus C##BACKUPUSER/<your_password>@hrpdb as sysbackup
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 06 17:59:22 2026
Version 19.27.0.0.0
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.27.0.0.0
Hello
------------------------------------------------
Welcome! you are connected to CDB19C database
CONNAME
--------------------------------------------------------------------------------
HRPDB通过sqlplus工具用户C##BACKUPUSER用户以SYSBACKUP身份连接数据库可以正常连接。
5、C##BACKUPUSER用户以SYSBACKUP执行expdp
--FULL=Y 全库级导出
[oracle@19cdb01 ~]$ expdp '"C##BACKUPUSER/<your_password>@hrpdb as sysbackup"' directory=IMP_DIR dumpfile=hrpdb_full_20260706.dmp full=y logfile=hrpdb_full_log_20260706.log logtime=all
Export: Release 19.0.0.0.0 - Production on Mon Jul 06 18:14:03 2026
Version 19.27.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-39002: invalid operation
ORA-39406: Job mode FULL is not permitted when running as SYSBACKUP.--方案级导出
[oracle@19cdb01 ~]$ expdp '"C##BACKUPUSER/<your_password>@hrpdb as sysbackup"' directory=IMP_DIR dumpfile=hrpdb_hr_20260706.dmp schemas=hr logfile=hrpdb_hr_log_20260706.log logtime=all
Export: Release 19.0.0.0.0 - Production on Mon Jul 06 18:14:57 2026
Version 19.27.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-39002: invalid operation
ORA-39406: Job mode SCHEMA is not permitted when running as SYSBACKUP.--table表级导出
[oracle@19cdb01 ~]$ expdp '"C##BACKUPUSER/<your_password>@hrpdb as sysbackup"' directory=IMP_DIR dumpfile=hrpdb_full_20260706.dmp tables=hr.emp2 logfile=hrpdb_full_log_20260706.log logtime=all
Export: Release 19.0.0.0.0 - Production on Mon Jul 06 18:15:20 2026
Version 19.27.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
06-JUL-26 18:15:22.289: Starting "SYSBACKUP"."SYS_EXPORT_TABLE_01": "C##BACKUPUSER/********@hrpdb" directory=IMP_DIR dumpfile=hrpdb_full_20260706.dmp tables=hr.emp2 logfile=hrpdb_full_log_20260706.log logtime=all
06-JUL-26 18:15:24.679: Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
06-JUL-26 18:15:25.237: Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
06-JUL-26 18:15:30.607: Processing object type TABLE_EXPORT/TABLE/TABLE
06-JUL-26 18:15:33.135: . . exported "HR"."EMP2" 16.57 KB 107 rows
06-JUL-26 18:15:33.925: Master table "SYSBACKUP"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
06-JUL-26 18:15:33.960: ******************************************************************************
06-JUL-26 18:15:33.961: Dump file set for SYSBACKUP.SYS_EXPORT_TABLE_01 is:
06-JUL-26 18:15:33.965: /home/oracle/hrpdb_full_20260706.dmp
06-JUL-26 18:15:33.987: Job "SYSBACKUP"."SYS_EXPORT_TABLE_01" successfully completed at Mon Jul 06 18:15:33 2026 elapsed 0 00:00:13
[oracle@19cdb01 ~]$FULL=Y全库级，方案schema级导出不能以SYSBACKUP身份进行，table表级的导出以SYSBACKUP身份可以正常执行。
6、给用户授权C##BACKUPUSER
SYS@cdb19c(CDB$ROOT)> grant DATAPUMP_EXP_FULL_DATABASE, DATAPUMP_IMP_FULL_DATABASE to C##BACKUPUSER container=all;
Grant succeeded.
SYS@cdb19c(CDB$ROOT)>将将 DATAPUMP_EXP_FULL_DATABASE/DATAPUMP_IMP_FULL_DATABASE 角色分配执行DataPump(expdp/impdp)用户C##BACKUPUSER 。
7、再次用户C##BACKUPUSER在pdb hrpdb上执行expdp
[oracle@19cdb01 ~]$ expdp C##BACKUPUSER/<your_password>@hrpdb directory=IMP_DIR dumpfile=hrpdb_full_20260706.dmp full=y logfile=hrpdb_full_log_20260706.log logtime=all
Export: Release 19.0.0.0.0 - Production on Mon Jul 06 18:03:50 2026
Version 19.27.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-31626: job does not exist
ORA-31633: unable to create master table "C##BACKUPUSER.SYS_EXPORT_FULL_01"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1163
ORA-01950: no privileges on tablespace 'USERS'
ORA-06512: at "SYS.KUPV$FT", line 1056
ORA-06512: at "SYS.KUPV$FT", line 1044
[oracle@19cdb01 ~]$ORA-31633: unable to create master table “C##BACKUPUSER.SYS_EXPORT_FULL_01” C##BACKUPUSER用户创建SYS_EXPORT_FULL_01状态表失败
ORA-01950: no privileges on tablespace ‘USERS’ 用户C##BACKUPUSER对HRPDB中USERS表空间缺少配额。
–在HRPDB中修改用户C##BACKUPUSER的表空间配额
[oracle@19cdb01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 06 18:06:42 2026
Version 19.27.0.0.0
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.27.0.0.0
Hello
------------------------------------------------
Welcome! you are connected to CDB19C database
CONNAME
--------------------------------------------------------------------------------
CDB$ROOT
SYS@cdb19c(CDB$ROOT)> alter session set container=hrpdb;
Session altered.
SYS@cdb19c(CDB$ROOT)> ALTER USER C##BACKUPUSER QUOTA unlimited ON users;
User altered.
SYS@cdb19c(CDB$ROOT)>再次执行expdp
FULL=Y
[oracle@19cdb01 ~]$ expdp 'C##BACKUPUSER/<your_password>@hrpdb' directory=IMP_DIR dumpfile=hrpdb_full_20260706.dmp full=y logfile=hrpdb_full_log_20260706.log logtime=all
Export: Release 19.0.0.0.0 - Production on Mon Jul 06 18:08:40 2026
Version 19.27.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
06-JUL-26 18:08:45.659: Starting "C##BACKUPUSER"."SYS_EXPORT_FULL_01": C##BACKUPUSER/********@hrpdb directory=IMP_DIR dumpfile=hrpdb_full_20260706.dmp full=y logfile=hrpdb_full_log_20260706.log logtime=all
06-JUL-26 18:08:51.565: Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
06-JUL-26 18:08:52.837: Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
06-JUL-26 18:08:53.860: Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
06-JUL-26 18:08:55.125: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
06-JUL-26 18:08:55.435: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
06-JUL-26 18:08:55.631: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
06-JUL-26 18:08:55.775: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
06-JUL-26 18:08:55.927: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
06-JUL-26 18:09:01.318: Processing object type DATABASE_EXPORT/STATISTICS/MARKER
06-JUL-26 18:09:01.972: Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
06-JUL-26 18:09:02.078: Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
06-JUL-26 18:09:02.378: Processing object type DATABASE_EXPORT/TABLESPACE
06-JUL-26 18:09:02.662: Processing object type DATABASE_EXPORT/PROFILE
06-JUL-26 18:09:02.844: Processing object type DATABASE_EXPORT/SCHEMA/USER
06-JUL-26 18:09:03.271: Processing object type DATABASE_EXPORT/ROLE
06-JUL-26 18:09:03.480: Processing object type DATABASE_EXPORT/RADM_FPTM
06-JUL-26 18:09:04.301: Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
06-JUL-26 18:09:04.503: Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
06-JUL-26 18:09:04.657: Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
06-JUL-26 18:09:04.812: Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
06-JUL-26 18:09:04.934: Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT
06-JUL-26 18:09:05.139: Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
06-JUL-26 18:09:05.231: Processing object type DATABASE_EXPORT/RESOURCE_COST
06-JUL-26 18:09:05.591: Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
06-JUL-26 18:09:05.754: Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
06-JUL-26 18:09:07.579: Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
06-JUL-26 18:09:08.192: Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
06-JUL-26 18:09:09.477: Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
06-JUL-26 18:09:09.676: Processing object type DATABASE_EXPORT/SCHEMA/TYPE/INC_TYPE
06-JUL-26 18:09:10.572: Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
06-JUL-26 18:09:11.106: Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
06-JUL-26 18:09:11.999: Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
06-JUL-26 18:09:12.360: Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
06-JUL-26 18:09:28.548: Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
06-JUL-26 18:09:28.716: Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
06-JUL-26 18:09:36.740: Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
06-JUL-26 18:09:36.815: Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER
06-JUL-26 18:09:37.444: Processing object type DATABASE_EXPORT/SCHEMA/XMLSCHEMA/XMLSCHEMA
06-JUL-26 18:09:53.050: Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
06-JUL-26 18:10:20.106: Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
06-JUL-26 18:10:35.976: Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER
06-JUL-26 18:10:38.397: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
06-JUL-26 18:11:08.472: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
06-JUL-26 18:11:09.430: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
06-JUL-26 18:11:10.757: Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
06-JUL-26 18:11:12.336: Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
06-JUL-26 18:11:14.019: Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
06-JUL-26 18:11:14.124: Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
06-JUL-26 18:11:16.102: Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
06-JUL-26 18:11:16.715: Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
06-JUL-26 18:11:17.519: Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
06-JUL-26 18:11:17.928: Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODY
06-JUL-26 18:11:19.103: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
06-JUL-26 18:11:19.876: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
06-JUL-26 18:11:21.694: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
06-JUL-26 18:11:24.905: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
06-JUL-26 18:11:25.468: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/BITMAP_INDEX/INDEX
06-JUL-26 18:11:27.480: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX
06-JUL-26 18:11:27.696: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
06-JUL-26 18:11:27.789: Processing object type DATABASE_EXPORT/SCHEMA/VIEW/TRIGGER
06-JUL-26 18:11:49.986: Processing object type DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW
06-JUL-26 18:12:09.300: Processing object type DATABASE_EXPORT/SCHEMA/DIMENSION
06-JUL-26 18:12:10.148: Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER
06-JUL-26 18:12:10.334: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE
06-JUL-26 18:12:10.616: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
06-JUL-26 18:12:11.108: Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
06-JUL-26 18:12:11.748: Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
06-JUL-26 18:12:17.120: Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE
06-JUL-26 18:12:17.376: Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
06-JUL-26 18:12:18.245: . . exported "SYS"."KU$_USER_MAPPING_VIEW" 6.226 KB 49 rows
06-JUL-26 18:12:18.617: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P221" 14.89 MB 7085 rows
06-JUL-26 18:12:18.669: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P508" 160.7 KB 132 rows
06-JUL-26 18:12:18.742: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P401" 85.50 KB 62 rows
06-JUL-26 18:12:18.802: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P768" 68.09 KB 27 rows
06-JUL-26 18:12:18.848: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P588" 67.69 KB 33 rows
06-JUL-26 18:12:18.890: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P728" 58.75 KB 12 rows
06-JUL-26 18:12:18.934: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P708" 56.49 KB 15 rows
06-JUL-26 18:12:18.980: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P441" 52.66 KB 1 rows
06-JUL-26 18:12:19.026: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P381" 51.32 KB 1 rows
06-JUL-26 18:12:19.069: . . exported "SYSTEM"."REDO_DB" 25.59 KB 1 rows
06-JUL-26 18:12:19.104: . . exported "SYS"."AUD$" 24.10 KB 5 rows
06-JUL-26 18:12:19.153: . . exported "WMSYS"."WM$WORKSPACES_TABLE$" 12.10 KB 1 rows
06-JUL-26 18:12:19.187: . . exported "WMSYS"."WM$HINT_TABLE$" 9.984 KB 97 rows
06-JUL-26 18:12:19.237: . . exported "LBACSYS"."OLS$INSTALLATIONS" 6.960 KB 2 rows
06-JUL-26 18:12:19.272: . . exported "WMSYS"."WM$WORKSPACE_PRIV_TABLE$" 7.078 KB 11 rows
06-JUL-26 18:12:19.299: . . exported "SYS"."DAM_CONFIG_PARAM$" 6.531 KB 14 rows
06-JUL-26 18:12:19.331: . . exported "SYS"."TSDP_SUBPOL$" 6.328 KB 1 rows
06-JUL-26 18:12:19.383: . . exported "WMSYS"."WM$NEXTVER_TABLE$" 6.375 KB 1 rows
06-JUL-26 18:12:19.417: . . exported "LBACSYS"."OLS$PROPS" 6.234 KB 5 rows
06-JUL-26 18:12:19.450: . . exported "WMSYS"."WM$ENV_VARS$" 6.015 KB 3 rows
06-JUL-26 18:12:19.481: . . exported "SYS"."TSDP_PARAMETER$" 5.953 KB 1 rows
06-JUL-26 18:12:19.523: . . exported "SYS"."TSDP_POLICY$" 5.921 KB 1 rows
06-JUL-26 18:12:19.561: . . exported "WMSYS"."WM$VERSION_HIERARCHY_TABLE$" 5.984 KB 1 rows
06-JUL-26 18:12:19.589: . . exported "WMSYS"."WM$EVENTS_INFO$" 5.812 KB 12 rows
06-JUL-26 18:12:19.621: . . exported "LBACSYS"."OLS$AUDIT_ACTIONS" 5.757 KB 8 rows
06-JUL-26 18:12:19.650: . . exported "LBACSYS"."OLS$DIP_EVENTS" 5.539 KB 2 rows
06-JUL-26 18:12:19.690: . . exported "AUDSYS"."AUD$UNIFIED":"AUD_UNIFIED_P0" 50.95 KB 0 rows
06-JUL-26 18:12:19.732: . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P828" 57.49 KB 19 rows
06-JUL-26 18:12:19.739: . . exported "LBACSYS"."OLS$AUDIT" 0 KB 0 rows
06-JUL-26 18:12:19.746: . . exported "LBACSYS"."OLS$COMPARTMENTS" 0 KB 0 rows
06-JUL-26 18:12:19.753: . . exported "LBACSYS"."OLS$DIP_DEBUG" 0 KB 0 rows
06-JUL-26 18:12:19.761: . . exported "LBACSYS"."OLS$GROUPS" 0 KB 0 rows
06-JUL-26 18:12:19.769: . . exported "LBACSYS"."OLS$LAB" 0 KB 0 rows
06-JUL-26 18:12:19.776: . . exported "LBACSYS"."OLS$LEVELS" 0 KB 0 rows
06-JUL-26 18:12:19.781: . . exported "LBACSYS"."OLS$POL" 0 KB 0 rows
06-JUL-26 18:12:19.787: . . exported "LBACSYS"."OLS$POLICY_ADMIN" 0 KB 0 rows
06-JUL-26 18:12:19.794: . . exported "LBACSYS"."OLS$POLS" 0 KB 0 rows
06-JUL-26 18:12:19.802: . . exported "LBACSYS"."OLS$POLT" 0 KB 0 rows
06-JUL-26 18:12:19.809: . . exported "LBACSYS"."OLS$PROFILE" 0 KB 0 rows
06-JUL-26 18:12:19.817: . . exported "LBACSYS"."OLS$PROFILES" 0 KB 0 rows
06-JUL-26 18:12:19.822: . . exported "LBACSYS"."OLS$PROG" 0 KB 0 rows
06-JUL-26 18:12:19.834: . . exported "LBACSYS"."OLS$SESSINFO" 0 KB 0 rows
06-JUL-26 18:12:19.841: . . exported "LBACSYS"."OLS$USER" 0 KB 0 rows
06-JUL-26 18:12:19.848: . . exported "LBACSYS"."OLS$USER_COMPARTMENTS" 0 KB 0 rows
06-JUL-26 18:12:19.854: . . exported "LBACSYS"."OLS$USER_GROUPS" 0 KB 0 rows
06-JUL-26 18:12:19.858: . . exported "LBACSYS"."OLS$USER_LEVELS" 0 KB 0 rows
06-JUL-26 18:12:19.888: . . exported "SYS"."DAM_CLEANUP_EVENTS$" 7.187 KB 0 rows
06-JUL-26 18:12:19.933: . . exported "SYS"."DAM_CLEANUP_JOBS$" 7.171 KB 0 rows
06-JUL-26 18:12:19.941: . . exported "SYS"."TSDP_ASSOCIATION$" 0 KB 0 rows
06-JUL-26 18:12:19.948: . . exported "SYS"."TSDP_CONDITION$" 0 KB 0 rows
06-JUL-26 18:12:19.954: . . exported "SYS"."TSDP_FEATURE_POLICY$" 0 KB 0 rows
06-JUL-26 18:12:19.964: . . exported "SYS"."TSDP_PROTECTION$" 0 KB 0 rows
06-JUL-26 18:12:19.975: . . exported "SYS"."TSDP_SENSITIVE_DATA$" 0 KB 0 rows
06-JUL-26 18:12:19.990: . . exported "SYS"."TSDP_SENSITIVE_TYPE$" 0 KB 0 rows
06-JUL-26 18:12:19.997: . . exported "SYS"."TSDP_SOURCE$" 0 KB 0 rows
06-JUL-26 18:12:20.005: . . exported "SYSTEM"."REDO_LOG" 0 KB 0 rows
06-JUL-26 18:12:20.013: . . exported "WMSYS"."WM$BATCH_COMPRESSIBLE_TABLES$" 0 KB 0 rows
06-JUL-26 18:12:20.022: . . exported "WMSYS"."WM$CONSTRAINTS_TABLE$" 0 KB 0 rows
06-JUL-26 18:12:20.030: . . exported "WMSYS"."WM$CONS_COLUMNS$" 0 KB 0 rows
06-JUL-26 18:12:20.035: . . exported "WMSYS"."WM$LOCKROWS_INFO$" 0 KB 0 rows
06-JUL-26 18:12:20.043: . . exported "WMSYS"."WM$MODIFIED_TABLES$" 0 KB 0 rows
06-JUL-26 18:12:20.050: . . exported "WMSYS"."WM$MP_GRAPH_WORKSPACES_TABLE$" 0 KB 0 rows
06-JUL-26 18:12:20.057: . . exported "WMSYS"."WM$MP_PARENT_WORKSPACES_TABLE$" 0 KB 0 rows
06-JUL-26 18:12:20.064: . . exported "WMSYS"."WM$NESTED_COLUMNS_TABLE$" 0 KB 0 rows
06-JUL-26 18:12:20.070: . . exported "WMSYS"."WM$RESOLVE_WORKSPACES_TABLE$" 0 KB 0 rows
06-JUL-26 18:12:20.077: . . exported "WMSYS"."WM$RIC_LOCKING_TABLE$" 0 KB 0 rows
06-JUL-26 18:12:20.085: . . exported "WMSYS"."WM$RIC_TABLE$" 0 KB 0 rows
06-JUL-26 18:12:20.092: . . exported "WMSYS"."WM$RIC_TRIGGERS_TABLE$" 0 KB 0 rows
06-JUL-26 18:12:20.098: . . exported "WMSYS"."WM$UDTRIG_DISPATCH_PROCS$" 0 KB 0 rows
06-JUL-26 18:12:20.106: . . exported "WMSYS"."WM$UDTRIG_INFO$" 0 KB 0 rows
06-JUL-26 18:12:20.117: . . exported "WMSYS"."WM$VERSION_TABLE$" 0 KB 0 rows
06-JUL-26 18:12:20.130: . . exported "WMSYS"."WM$VT_ERRORS_TABLE$" 0 KB 0 rows
06-JUL-26 18:12:20.142: . . exported "WMSYS"."WM$WORKSPACE_SAVEPOINTS_TABLE$" 0 KB 0 rows
06-JUL-26 18:12:20.291: . . exported "MDSYS"."RDF_PARAM$" 6.515 KB 3 rows
06-JUL-26 18:12:20.531: . . exported "SYS"."AUDTAB$TBS$FOR_EXPORT" 5.960 KB 2 rows
06-JUL-26 18:12:20.546: . . exported "SYS"."DBA_SENSITIVE_DATA" 0 KB 0 rows
06-JUL-26 18:12:20.557: . . exported "SYS"."DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows
06-JUL-26 18:12:20.565: . . exported "SYS"."FGA_LOG$FOR_EXPORT" 0 KB 0 rows
06-JUL-26 18:12:20.621: . . exported "SYS"."NACL$_ACE_EXP" 0 KB 0 rows
06-JUL-26 18:12:20.765: . . exported "SYS"."NACL$_HOST_EXP" 6.914 KB 1 rows
06-JUL-26 18:12:20.773: . . exported "SYS"."NACL$_WALLET_EXP" 0 KB 0 rows
06-JUL-26 18:12:20.782: . . exported "SYS"."SQL$TEXT_DATAPUMP" 0 KB 0 rows
06-JUL-26 18:12:20.790: . . exported "SYS"."SQL$_DATAPUMP" 0 KB 0 rows
06-JUL-26 18:12:20.799: . . exported "SYS"."SQLOBJ$AUXDATA_DATAPUMP" 0 KB 0 rows
06-JUL-26 18:12:20.807: . . exported "SYS"."SQLOBJ$DATA_DATAPUMP" 0 KB 0 rows
06-JUL-26 18:12:20.815: . . exported "SYS"."SQLOBJ$PLAN_DATAPUMP" 0 KB 0 rows
06-JUL-26 18:12:20.824: . . exported "SYS"."SQLOBJ$_DATAPUMP" 0 KB 0 rows
06-JUL-26 18:12:20.886: . . exported "SYSTEM"."SCHEDULER_JOB_ARGS" 0 KB 0 rows
06-JUL-26 18:12:20.916: . . exported "SYSTEM"."SCHEDULER_PROGRAM_ARGS" 0 KB 0 rows
06-JUL-26 18:12:23.991: . . exported "WMSYS"."WM$EXP_MAP" 7.718 KB 3 rows
06-JUL-26 18:12:25.923: . . exported "WMSYS"."WM$METADATA_MAP" 0 KB 0 rows
06-JUL-26 18:12:26.022: . . exported "HFXF"."BAK_TMP_HIST_SESS" 10.66 MB 25488 rows
06-JUL-26 18:12:26.137: . . exported "SH"."CUSTOMERS" 10.27 MB 55500 rows
06-JUL-26 18:12:26.244: . . exported "OE"."PRODUCT_DESCRIPTIONS" 2.379 MB 8640 rows
06-JUL-26 18:12:26.360: . . exported "SH"."SALES":"SALES_Q4_2001" 2.257 MB 69749 rows
06-JUL-26 18:12:26.436: . . exported "SH"."SALES":"SALES_Q3_1999" 2.166 MB 67138 rows
06-JUL-26 18:12:26.504: . . exported "SH"."SALES":"SALES_Q3_2001" 2.130 MB 65769 rows
06-JUL-26 18:12:26.571: . . exported "SH"."SALES":"SALES_Q2_2001" 2.051 MB 63292 rows
06-JUL-26 18:12:26.684: . . exported "SH"."SALES":"SALES_Q1_1999" 2.071 MB 64186 rows
06-JUL-26 18:12:26.774: . . exported "SH"."SALES":"SALES_Q1_2001" 1.965 MB 60608 rows
06-JUL-26 18:12:26.844: . . exported "SH"."SALES":"SALES_Q4_1999" 2.014 MB 62388 rows
06-JUL-26 18:12:26.931: . . exported "SH"."SALES":"SALES_Q1_2000" 2.012 MB 62197 rows
06-JUL-26 18:12:27.002: . . exported "SH"."SALES":"SALES_Q3_2000" 1.910 MB 58950 rows
06-JUL-26 18:12:27.130: . . exported "SH"."SALES":"SALES_Q4_2000" 1.814 MB 55984 rows
06-JUL-26 18:12:27.215: . . exported "SH"."SALES":"SALES_Q2_2000" 1.802 MB 55515 rows
06-JUL-26 18:12:27.297: . . exported "SH"."SALES":"SALES_Q2_1999" 1.754 MB 54233 rows
06-JUL-26 18:12:27.359: . . exported "SH"."SALES":"SALES_Q3_1998" 1.634 MB 50515 rows
06-JUL-26 18:12:27.411: . . exported "SH"."SALES":"SALES_Q4_1998" 1.581 MB 48874 rows
06-JUL-26 18:12:27.459: . . exported "SH"."SALES":"SALES_Q1_1998" 1.413 MB 43687 rows
06-JUL-26 18:12:27.505: . . exported "SH"."SALES":"SALES_Q2_1998" 1.160 MB 35758 rows
06-JUL-26 18:12:27.593: . . exported "SH"."SUPPLEMENTARY_DEMOGRAPHICS" 697.6 KB 4500 rows
06-JUL-26 18:12:27.679: . . exported "SH"."TIMES" 381.7 KB 1826 rows
06-JUL-26 18:12:27.725: . . exported "SH"."FWEEK_PSCAT_SALES_MV" 419.9 KB 11266 rows
06-JUL-26 18:12:27.768: . . exported "SH"."COSTS":"COSTS_Q4_2001" 278.5 KB 9011 rows
06-JUL-26 18:12:27.825: . . exported "SH"."COSTS":"COSTS_Q3_2001" 234.6 KB 7545 rows
06-JUL-26 18:12:27.880: . . exported "SH"."COSTS":"COSTS_Q1_2001" 228.0 KB 7328 rows
06-JUL-26 18:12:27.926: . . exported "SH"."COSTS":"COSTS_Q2_2001" 184.7 KB 5882 rows
06-JUL-26 18:12:27.971: . . exported "SH"."COSTS":"COSTS_Q1_1999" 183.7 KB 5884 rows
06-JUL-26 18:12:28.014: . . exported "SH"."COSTS":"COSTS_Q4_2000" 160.4 KB 5088 rows
06-JUL-26 18:12:28.052: . . exported "SH"."COSTS":"COSTS_Q4_1999" 159.2 KB 5060 rows
06-JUL-26 18:12:28.096: . . exported "SH"."COSTS":"COSTS_Q3_2000" 151.6 KB 4798 rows
06-JUL-26 18:12:28.160: . . exported "SH"."COSTS":"COSTS_Q4_1998" 144.8 KB 4577 rows
06-JUL-26 18:12:28.206: . . exported "SH"."COSTS":"COSTS_Q1_1998" 139.6 KB 4411 rows
06-JUL-26 18:12:28.250: . . exported "SH"."COSTS":"COSTS_Q3_1999" 137.5 KB 4336 rows
06-JUL-26 18:12:28.285: . . exported "SH"."COSTS":"COSTS_Q2_1999" 132.7 KB 4179 rows
06-JUL-26 18:12:28.336: . . exported "SH"."COSTS":"COSTS_Q3_1998" 131.3 KB 4129 rows
06-JUL-26 18:12:28.387: . . exported "SH"."COSTS":"COSTS_Q2_2000" 119.1 KB 3715 rows
06-JUL-26 18:12:28.432: . . exported "SH"."COSTS":"COSTS_Q1_2000" 120.7 KB 3772 rows
06-JUL-26 18:12:28.581: ORA-39181: Only partial table data may be exported due to fine grain access control on "OE"."PURCHASEORDER"
06-JUL-26 18:12:28.601: . . exported "OE"."PURCHASEORDER" 0 KB 0 rows
06-JUL-26 18:12:28.659: . . exported "OE"."PRODUCT_INFORMATION" 73.05 KB 288 rows
06-JUL-26 18:12:28.690: . . exported "SH"."COSTS":"COSTS_Q2_1998" 79.68 KB 2397 rows
06-JUL-26 18:12:28.738: . . exported "OE"."CUSTOMERS" 81.17 KB 319 rows
06-JUL-26 18:12:28.780: . . exported "SH"."PROMOTIONS" 59.17 KB 503 rows
06-JUL-26 18:12:28.817: . . exported "SH"."PRODUCTS" 26.71 KB 72 rows
06-JUL-26 18:12:28.861: . . exported "HR"."PLAN_TABLE" 25.99 KB 8 rows
06-JUL-26 18:12:29.064: . . exported "PM"."PRINT_MEDIA" 190.6 KB 4 rows
06-JUL-26 18:12:29.143: . . exported "OE"."ORDER_ITEMS" 21.01 KB 665 rows
06-JUL-26 18:12:29.194: . . exported "OE"."INVENTORIES" 21.76 KB 1112 rows
06-JUL-26 18:12:29.227: . . exported "HR"."EMP3" 17.08 KB 107 rows
06-JUL-26 18:12:29.268: . . exported "HR"."EMPLOYEES" 17.08 KB 107 rows
06-JUL-26 18:12:29.503: . . exported "HR"."EMP2" 16.57 KB 107 rows
06-JUL-26 18:12:29.592: . . exported "PM"."TEXTDOCS_NESTEDTAB" 87.85 KB 12 rows
06-JUL-26 18:12:29.620: . . exported "OE"."PRODUCT_REF_LIST_NESTEDTAB" 12.57 KB 288 rows
06-JUL-26 18:12:29.650: . . exported "OE"."ORDERS" 12.59 KB 105 rows
06-JUL-26 18:12:29.679: . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_S" 11.57 KB 1 rows
06-JUL-26 18:12:29.708: . . exported "IX"."AQ$_ORDERS_QUEUETABLE_S" 11.30 KB 4 rows
06-JUL-26 18:12:29.739: . . exported "SH"."COUNTRIES" 10.46 KB 23 rows
06-JUL-26 18:12:29.776: . . exported "IX"."AQ$_ORDERS_QUEUETABLE_H" 0 KB 0 rows
06-JUL-26 18:12:29.783: . . exported "IX"."AQ$_ORDERS_QUEUETABLE_I" 0 KB 0 rows
06-JUL-26 18:12:29.846: . . exported "OE"."CATEGORIES_TAB" 14.43 KB 22 rows
06-JUL-26 18:12:29.880: . . exported "HR"."LOCATIONS" 8.437 KB 23 rows
06-JUL-26 18:12:30.065: . . exported "OE"."WAREHOUSES" 12.73 KB 9 rows
06-JUL-26 18:12:30.125: . . exported "SH"."CHANNELS" 7.414 KB 5 rows
06-JUL-26 18:12:30.154: . . exported "HR"."JOB_HISTORY" 7.195 KB 10 rows
06-JUL-26 18:12:30.193: . . exported "HR"."JOBS" 7.109 KB 19 rows
06-JUL-26 18:12:30.223: . . exported "HR"."DEPARTMENTS" 7.125 KB 27 rows
06-JUL-26 18:12:30.265: . . exported "OE"."SUBCATEGORY_REF_LIST_NESTEDTAB" 6.656 KB 21 rows
06-JUL-26 18:12:30.471: . . exported "HR"."COUNTRIES" 6.367 KB 25 rows
06-JUL-26 18:12:30.569: . . exported "SH"."CAL_MONTH_SALES_MV" 6.382 KB 48 rows
06-JUL-26 18:12:30.631: . . exported "HR"."REGIONS" 5.546 KB 4 rows
06-JUL-26 18:12:30.678: . . exported "OE"."PROMOTIONS" 5.570 KB 2 rows
06-JUL-26 18:12:30.738: . . exported "EXPOER"."SYS_EXPORT_FULL_01" 660.4 KB 3591 rows
06-JUL-26 18:12:30.790: . . exported "IX"."AQ$_ORDERS_QUEUETABLE_G" 0 KB 0 rows
06-JUL-26 18:12:30.828: . . exported "IX"."AQ$_ORDERS_QUEUETABLE_L" 0 KB 0 rows
06-JUL-26 18:12:30.867: . . exported "IX"."AQ$_ORDERS_QUEUETABLE_T" 0 KB 0 rows
06-JUL-26 18:12:30.878: . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_C" 0 KB 0 rows
06-JUL-26 18:12:30.889: . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_G" 0 KB 0 rows
06-JUL-26 18:12:30.896: . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_H" 0 KB 0 rows
06-JUL-26 18:12:30.901: . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_I" 0 KB 0 rows
06-JUL-26 18:12:30.948: . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_L" 0 KB 0 rows
06-JUL-26 18:12:31.010: . . exported "IX"."AQ$_STREAMS_QUEUE_TABLE_T" 0 KB 0 rows
06-JUL-26 18:12:31.019: . . exported "IX"."ORDERS_QUEUETABLE" 0 KB 0 rows
06-JUL-26 18:12:31.026: . . exported "IX"."STREAMS_QUEUE_TABLE" 0 KB 0 rows
06-JUL-26 18:12:31.089: . . exported "PM"."ONLINE_MEDIA" 0 KB 0 rows
06-JUL-26 18:12:31.098: . . exported "SH"."COSTS":"COSTS_1995" 0 KB 0 rows
06-JUL-26 18:12:31.104: . . exported "SH"."COSTS":"COSTS_1996" 0 KB 0 rows
06-JUL-26 18:12:31.109: . . exported "SH"."COSTS":"COSTS_H1_1997" 0 KB 0 rows
06-JUL-26 18:12:31.114: . . exported "SH"."COSTS":"COSTS_H2_1997" 0 KB 0 rows
06-JUL-26 18:12:31.119: . . exported "SH"."COSTS":"COSTS_Q1_2002" 0 KB 0 rows
06-JUL-26 18:12:31.125: . . exported "SH"."COSTS":"COSTS_Q1_2003" 0 KB 0 rows
06-JUL-26 18:12:31.131: . . exported "SH"."COSTS":"COSTS_Q2_2002" 0 KB 0 rows
06-JUL-26 18:12:31.136: . . exported "SH"."COSTS":"COSTS_Q2_2003" 0 KB 0 rows
06-JUL-26 18:12:31.142: . . exported "SH"."COSTS":"COSTS_Q3_2002" 0 KB 0 rows
06-JUL-26 18:12:31.146: . . exported "SH"."COSTS":"COSTS_Q3_2003" 0 KB 0 rows
06-JUL-26 18:12:31.151: . . exported "SH"."COSTS":"COSTS_Q4_2002" 0 KB 0 rows
06-JUL-26 18:12:31.156: . . exported "SH"."COSTS":"COSTS_Q4_2003" 0 KB 0 rows
06-JUL-26 18:12:31.162: . . exported "SH"."SALES":"SALES_1995" 0 KB 0 rows
06-JUL-26 18:12:31.173: . . exported "SH"."SALES":"SALES_1996" 0 KB 0 rows
06-JUL-26 18:12:31.183: . . exported "SH"."SALES":"SALES_H1_1997" 0 KB 0 rows
06-JUL-26 18:12:31.191: . . exported "SH"."SALES":"SALES_H2_1997" 0 KB 0 rows
06-JUL-26 18:12:31.197: . . exported "SH"."SALES":"SALES_Q1_2002" 0 KB 0 rows
06-JUL-26 18:12:31.206: . . exported "SH"."SALES":"SALES_Q1_2003" 0 KB 0 rows
06-JUL-26 18:12:31.213: . . exported "SH"."SALES":"SALES_Q2_2002" 0 KB 0 rows
06-JUL-26 18:12:31.220: . . exported "SH"."SALES":"SALES_Q2_2003" 0 KB 0 rows
06-JUL-26 18:12:31.225: . . exported "SH"."SALES":"SALES_Q3_2002" 0 KB 0 rows
06-JUL-26 18:12:31.231: . . exported "SH"."SALES":"SALES_Q3_2003" 0 KB 0 rows
06-JUL-26 18:12:31.237: . . exported "SH"."SALES":"SALES_Q4_2002" 0 KB 0 rows
06-JUL-26 18:12:31.242: . . exported "SH"."SALES":"SALES_Q4_2003" 0 KB 0 rows
06-JUL-26 18:12:33.550: Master table "C##BACKUPUSER"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
06-JUL-26 18:12:33.583: ******************************************************************************
06-JUL-26 18:12:33.583: Dump file set for C##BACKUPUSER.SYS_EXPORT_FULL_01 is:
06-JUL-26 18:12:33.588: /home/oracle/hrpdb_full_20260706.dmp
06-JUL-26 18:12:33.630: Job "C##BACKUPUSER"."SYS_EXPORT_FULL_01" completed with 1 error(s) at Mon Jul 06 18:12:33 2026 elapsed 0 00:03:52
[oracle@19cdb01 ~]$FULL=Y全库级导出可以正常执行。
““sql
[oracle@19cdb01 ~]$ expdp C##BACKUPUSER/@hrpdb directory=IMP_DIR dumpfile=hrpdb_hr_20260706.dmp schemas=hr logfile=hrpdb_hr_log_20260706.log logtime=all
Export: Release 19.0.0.0.0 – Production on Mon Jul 06 20:04:02 2026
Version 19.27.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
18-JUN-26 20:04:06.679: Starting “C##BACKUPUSER”.”SYS_EXPORT_SCHEMA_01″: C##BACKUPUSER/@hrpdb directory=IMP_DIR dumpfile=hrpdb_hr_20260706.dmp schemas=hr logfile=hrpdb_hr_log_20260706.log logtime=all
18-JUN-26 20:04:10.421: Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
18-JUN-26 20:04:10.699: Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
18-JUN-26 20:04:11.034: Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
18-JUN-26 20:04:15.198: Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
18-JUN-26 20:04:15.462: Processing object type SCHEMA_EXPORT/USER
18-JUN-26 20:04:15.540: Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
18-JUN-26 20:04:15.598: Processing object type SCHEMA_EXPORT/ROLE_GRANT
18-JUN-26 20:04:15.663: Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
18-JUN-26 20:04:15.789: Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
18-JUN-26 20:04:16.099: Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
18-JUN-26 20:04:17.080: Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
18-JUN-26 20:04:37.596: Processing object type SCHEMA_EXPORT/TABLE/TABLE
18-JUN-26 20:04:53.194: Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
18-JUN-26 20:04:53.508: Processing object type SCHEMA_EXPORT/TABLE/COMMENT
18-JUN-26 20:04:55.299: Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
18-JUN-26 20:04:56.031: Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
18-JUN-26 20:04:58.365: Processing object type SCHEMA_EXPORT/VIEW/VIEW
18-JUN-26 20:04:59.808: Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
18-JUN-26 20:05:00.837: Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
18-JUN-26 20:05:02.318: Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
18-JUN-26 20:05:02.484: Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
18-JUN-26 20:05:05.397: . . exported “HR”.”PLAN_TABLE” 25.99 KB 8 rows
18-JUN-26 20:05:05.431: . . exported “HR”.”EMP3″ 17.08 KB 107 rows
18-JUN-26 20:05:05.467: . . exported “HR”.”EMPLOYEES” 17.08 KB 107 rows
18-JUN-26 20:05:06.043: . . exported “HR”.”EMP2″ 16.57 KB 107 rows
18-JUN-26 20:05:06.120: . . exported “HR”.”LOCATIONS” 8.437 KB 23 rows
18-JUN-26 20:05:06.156: . . exported “HR”.”JOB_HISTORY” 7.195 KB 10 rows
18-JUN-26 20:05:06.194: . . exported “HR”.”JOBS” 7.109 KB 19 rows
18-JUN-26 20:05:06.225: . . exported “HR”.”DEPARTMENTS” 7.125 KB 27 rows
18-JUN-26 20:05:06.379: . . exported “HR”.”COUNTRIES” 6.367 KB 25 rows
18-JUN-26 20:05:06.438: . . exported “HR”.”REGIONS” 5.546 KB 4 rows
18-JUN-26 20:05:07.954: Master table “C##BACKUPUSER”.”SYS_EXPORT_SCHEMA_01″ successfully loaded/unloaded
18-JUN-26 20:05:07.992:
18-JUN-26 20:05:07.993: Dump file set for C##BACKUPUSER.SYS_EXPORT_SCHEMA_01 is:
18-JUN-26 20:05:07.998: /home/oracle/hrpdb_hr_20260706.dmp
18-JUN-26 20:05:08.062: Job “C##BACKUPUSER”.”SYS_EXPORT_SCHEMA_01″ successfully completed at Mon Jul 06 20:05:08 2026 elapsed 0 00:01:04
[oracle@19cdb01 ~]$
“`
方案schema级导出可以正常执行。
【小结】在 Oracle 19c 中sysbackup 是一个具有备份管理权限的数据库角色，我们可以使用该用户或具有该角色的用户进行rman的备份和恢复，如果使用该用户进行DataPump(expdp/impdp)时需要授予 DATAPUMP_EXP_FULL_DATABASE/DATAPUMP_IMP_FULL_DATABASE 角色。生产环境建议管理用户分离，不混用数据库用户，满足监管和审计要求。
-the end-
笔者文章集合详见：
https://www.myhfxf.com
https://www.xiaofeihuangfu.com
CSDN:https://blog.csdn.net/xfhuangfu
ITPUB:https://blog.itpub.net/28373936/
微信公众号：xfhuangfu