What's the rule for having a combination of upper cases and lower cases in an user name? The same SQ
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.
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.
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.
0