Martin,
Thank you so much for the spot on reply. The work you saved with that
reply is greatly appreciated.
I checked the resource groups with this statement:
COL initial_rsrc_consumer_group FORMAT A24 HEADING 'Resource|Consumer|Group'
COL username FORMAT A12 HEADING 'User Name'
SELECT
initial_rsrc_consumer_group,
username
FROM dba_users
ORDER BY 1,2
;
The user was in the DEFAULT_CONSUMER_GROUP. I issued the following
commands as the sysdba to move the user to the SYS_GROUP, and the
problem went away (I'm the only user of this database, and it exists for
conversion of data.
EXEC
DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP('SOMEORACLEUSER',
'SYS_GROUP', TRUE);
EXEC DBMS_RESOURCE_MANAGER.SET_INITIAL_CONSUMER_GROUP('SOMEORACLEUSER',
'SYS_GROUP');
I hope this helps someone else in the future.
Andy Baumhauer
