Change in 10g Create User with QUOTA on TEMP tablespace
550766Feb 12 2009 — edited Feb 12 2009I have found old code for Create User statement that allowed a QUOTA unlimited on TEMP tablespace.
We have recently been upgraded to 10g from a 9i instance and the code fails, which is how I found it.
SQL: create user testuser2 identified by password
default tablespace USERS
temporary tablespace TEMP
quota unlimited on USERS
quota unlimited on TEMP;
Did the statement just get ignored in 9i and now fails in 10g? Or was there a recent 10g Patch that
caught this statement? I am just trying to figure out how this code ran up until this week.