ORA-01950 no privileges on tablespace USERS

ORA-01950: no privileges on tablespace USERS Oracle SQL Error: ORA-01950: no privileges on tablespace ‘USERS’ Cause: User does not have privileges to allocate an extent in the specified tablespace. Solution: Grant the user the appropriate system privileges or grant the user space resource on the tablespace. Example: Insert into DEPARTMENTS (DEP_ID,DEP_NAME) values (‘1′,’aaa’); Output: SQL…(Continue Reading)

ORA-01017: invalid username/password logon denied

ORA-01017: invalid username/password; logon denied Oracle SQL Error: ORA-01017: invalid username/password; logon denied Cause: An attempt was made to logon on database schema. Solution: Check if the username and password are correct. Check if the user has the right to create session. Example: CREATE USER test3 IDENTIFIED BY test_user3; GRANT create session TO test3; Output:…(Continue Reading)

ORA-65096 invalid common user or role name

ORA-65096 invalid common user or role name Oracle SQL Error: ORA-65096: invalid common user or role name Cause: An attempt was made to create a common user or role with a name that was not valid for common users or roles. Solution: Ask the database administrator to perform the operation or grant the required privileges…(Continue Reading)

PLS-00487 Invalid reference to variable

PLS-00487 Invalid reference to variable Oracle SQL Error: PLS-00487 Invalid reference to variable Cause: A variable was referenced in a way that is inconsistent with its datatype. Solution: Check the spelling of the variable name. Make sure the variable was declared properly and that the declaration and reference are consistent regarding datatype. Example: DECLARE CURSOR…(Continue Reading)