datapump能在数据库间传递用户的consumer group吗？
我创建了一个用户，并且给这个用户赋予了一个initial consumer group（consumer_group_1)，使用下面的语句
CREATE USER "USER_TEST4" PROFILE "DEFAULT" IDENTIFIED BY "*******" ACCOUNT UNLOCK
GRANT "CONNECT" TO "USER_TEST4"
BEGIN
dbms_resource_manager_privs.grant_switch_consumer_group(
grantee_name => 'USER_TEST4',
consumer_group => 'AUTO_TASK_CONSUMER_GROUP',
grant_option => FALSE
);
END;
BEGIN
dbms_resource_manager_privs.grant_switch_consumer_group(
grantee_name => 'USER_TEST4',
consumer_group => 'CONSUMER_GROUP_1',
grant_option => FALSE
);
END;
BEGIN
dbms_resource_manager_privs.grant_switch_consumer_group(
grantee_name => 'USER_TEST4',
consumer_group => 'DEFAULT_CONSUMER_GROUP',
grant_option => FALSE
);
END;
BEGIN
dbms_resource_manager_privs.grant_switch_consumer_group(
grantee_name => 'USER_TEST4',
consumer_group => 'LOW_GROUP',
grant_option => FALSE
);
END;
BEGIN
dbms_resource_manager_privs.grant_switch_consumer_group(
grantee_name => 'USER_TEST4',
consumer_group => 'SYS_GROUP',
grant_option => FALSE
);
END;
BEGIN
dbms_resource_manager.set_initial_consumer_group(
user => 'USER_TEST4',
consumer_group => 'CONSUMER_GROUP_1'
);
END;
然后我使用下面的expdp和impdp将这个用户导出导入了一遍(user_test5是由impdp来创建的），发现用户的consumer group信息丢失了，user_test5的consumer group在dba_users中查询成了default_consumer_group了，而不是期望的consumer_group_1了
expdp system/rmanrep@rmanrep directory=data_pump_dir1 dumpfile=user_test4.dmp schemas=user_test4
impdp system/rmanrep@rmanrep directory=data_pump_dir1 dumpfile=user_test4.dmp schemas=user_test4 remap_schema=(user_test4:user_test5) |
