USER_ASTATUS_MAP, How and Why
SYS.USER_ASTATUS_MAP provides a list of account status bit and their definitions. Let's see its content. In which, ASTATUS stands for "Account STATUS". SQL> show user… Read More »USER_ASTATUS_MAP, How and Why
USER_USERS
How to Resolve ORA-01950: no privileges on tablespace 'USERS'
ORA-01950 In this post, we introduce some error patterns of ORA-01950 as below: CREATE TABLE INSERT INTO ALTER TABLE CREATE TABLE Tried to create a… Read More »How to Resolve ORA-01950: no privileges on tablespace 'USERS'
Oracle Who am I
Sometimes, you switched the connection to another schema for more operations and forgot where you are. Here are some ways to know who am I… Read More »Oracle Who am I