PL/SQL (MOSC)

MOSC Banner

What's the rule for having a combination of upper cases and lower cases in an user name? The same SQ

edited Jan 21, 2014 3:10PM in PL/SQL (MOSC) 3 commentsAnswered
Hi, I'm running a series of SQL statements in both Oracle DB 10.2 and 11gR2. The first a few could be executed successfully on both DBs, but the last one which sets the resource consumer group always failed on 10.2.

SQL executed on the two DBs and their results:
1.
CREATE USER "yfangAbcOracle" IDENTIFIED  BY "siZ3-jBj";
Result: success.

2.
ALTER USER "yfangAbcOracle" DEFAULT ROLE "DBA";
Result: success.

3.
ALTER USER "yfangAbcOracle1"   DEFAULT TABLESPACE "SYSTEM";
Result: success.

4.
BEGIN  dbms_resource_manager.set_initial_consumer_group(user => 'yfangAbcOracle' ,consumer_group => 'AUTO_TASK_CONSUMER_GROUP'); END;
Failed on both 11gR2 DB and 10.2DB. Error msg: ORA-29393: user YFANGABCORACLE does not exist or is not logged on.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center