Hi
"ALTER USER user_name QUOTA number [K/M] ON tablespace name"
or run this:
"ALTER USER user_name QUOTA UNLIMITED ON tablespace name"
also, only the owner of the tablespace or a privileged user must grant additional resource quota on the tablespace to the user.
hope this helps




Reply With Quote