Oracle Change User Password
Change User Password Periodically, you may like to change your own password for more protection. In fact, there're many ways that can change user's password… Read More »Oracle Change User Password
ALTER USER
How to Resolve ORA-01536: space quota exceeded for tablespace
ORA-01536 Tried to use CTAS to make a table in a tablespace, but it failed with ORA-01536. SQL> create table t1 tablespace users as select… Read More »How to Resolve ORA-01536: space quota exceeded for tablespace
How to Resolve ORA-00922: missing or invalid option
ORA-00922 Tried to grant some quota on tablespace to an user, but it failed with ORA-00922. SQL> alter user hr quota 100g on tablespace users;… Read More »How to Resolve ORA-00922: missing or invalid option
Alter User Default Temporary Tablespace Examples
Default Temporary Tablespace Normally, all users in the database use the same default temporary tablespace except that we specifically set another one for them. In… Read More »Alter User Default Temporary Tablespace Examples
Alter User Default Tablespace Examples
Default Tablespace The default tablespace in the database for all users is USERS if you didn't specify the default one for the user. This can… Read More »Alter User Default Tablespace Examples
Revoke Quota Unlimited on Tablespace from User
Revoke Tablespace Quota In previous post, we have talked about how to set quota on tablespace for users. Now, let's see how to revert it.… Read More »Revoke Quota Unlimited on Tablespace from User
Grant Quota Unlimited on Tablespace to User
Grant Tablespace Quota Since quota usage limitation is not an object privilege, we can't grant it like this: SQL> grant quota 100g on erpapp_tbs_01 to… Read More »Grant Quota Unlimited on Tablespace to User
How to Resolve ORA-01031: Insufficient Privileges
ORA-01031 ORA-01031: Insufficient Privileges means that the current user did not use the right privilege to process the SQL statement. Since this error can be… Read More »How to Resolve ORA-01031: Insufficient Privileges
How to Resolve ORA-28002: the password will expire within 7 days
ORA-28002 ORA-28002 means that the password of the user will expire soon in N days, although the user is allowable to connect to the database.… Read More »How to Resolve ORA-28002: the password will expire within 7 days