ALTER USER

How to Resolve ORA-02155: invalid DEFAULT tablespace identifier

by Ed Chen
May 3, 2023March 25, 2023

ORA-02155 Tried to set the default permanent tablespace for an user, but it failed with ORA-02155. SQL> alter user hr default tablespace; alter user hr… Read More »

How to Resolve ORA-01918: user does not exist

by Ed Chen
April 11, 2023March 3, 2023

ORA-01918 Tried to change an user's attribute, but it failed with ORA-01918. SQL> alter user ht account unlock; alter user ht account unlock … Read More »

Force User to Change Password at First Login

by Ed Chen
April 3, 2023May 31, 2023

We take the following steps to make a new user change his password at the first time logon to the database. Create User We set… Read More »

Oracle Change User Password

by Ed Chen
November 28, 2022February 21, 2023

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 »

How to Resolve ORA-01536: space quota exceeded for tablespace

by Ed Chen
November 10, 2022June 6, 2023

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-00922: missing or invalid option

by Ed Chen
November 9, 2022March 24, 2023

ORA-00922 ORA-00922 means that SQL parser found an invalid option where should be empty or one of other valid options it expects. Since it's a… Read More »

Alter User Default Temporary Tablespace Examples

by Ed Chen
August 29, 2022September 12, 2022

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 Tablespace Examples

by Ed Chen
August 26, 2022September 12, 2022

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 »

Revoke Quota Unlimited on Tablespace from User

by Ed Chen
July 10, 2022April 24, 2023

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 »

Grant Quota Unlimited on Tablespace to User

by Ed Chen
July 10, 2022June 6, 2023

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 »

JavaScript is not enabled. Please enable it and reload the page.