Oracle Change User Passwordby Ed ChenNovember 28, 2022December 1, 2022Change 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
How to Resolve ORA-01536: space quota exceeded for tablespaceby Ed ChenNovember 10, 2022October 17, 2022ORA-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 optionby Ed ChenNovember 9, 2022October 17, 2022ORA-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 Examplesby Ed ChenAugust 29, 2022September 12, 2022Default 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 Examplesby Ed ChenAugust 26, 2022September 12, 2022Default 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 Userby Ed ChenJuly 10, 2022October 2, 2022Revoke 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 Userby Ed ChenJuly 10, 2022December 30, 2022Grant 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 Privilegesby Ed ChenJune 24, 2020December 9, 20221 CommentORA-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 daysby Ed ChenFebruary 1, 2020January 9, 20232 CommentsORA-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