After Upgrading to the 19.9 DBRU or Above, Data Pump Import of a Dump File Created in 19.8 and Below Fails With ORA-31685 on AQ Rulesets and Evaluation Contexts (Doc ID 2898131.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

When importing a Data Pump dump file that was created in the 19.8 RU or lower, errors similar to the following are observed when importing into a database with the 19.9 RU or higher installed:

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-31685: Object type PROCDEPOBJ:"USER1"."AQ$_TAB1_V"
failed due to insufficient privileges. Failing sql is:
BEGIN
DECLARE
ta sys.re$table_alias_list;
vt sys.re$variable_type_list;
BEGIN
ta := sys.re$table_alias_list();
vt := sys.re$variable_type_list();
ta.extend(1);
ta(1) := sys.re$table_alias('TAB','"TAB1"');
dbms_rule_imp_obj.import_evaluation_context('"AQ$_TAB1_V"', ta, vt,
NULL,NULL, 1);
END; COMMIT; END;

ORA-31685: Object type PROCDEPOBJ:"USER1"."TAB1_N" failed
due to insufficient privileges. Failing sql is:
BEGIN
BEGIN
dbms_rule_imp_obj.import_rule_set('"USER1"','"AQ$_TAB1_V"',N
ULL, 1);
END;
COMMIT; END;

However, importing this same dump file into 19.8 or lower has no such errors.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.