Author: Dev

PLS-00201 identifier must be declared Oracle SQL Error: PLS-00201 identifier must be declared Cause: An attempt was made to reference either an undeclared variable, exception, procedure, or other item, or an item to which no privilege was granted or an item to which privilege was granted only through a role. Solution: Check your spelling and…(Continue Reading)

ORA-01031 insufficient privileges Oracle SQL Error: ORA-01031 insufficient privileges Cause: An attempt was made to change the current username or password without the appropriate privilege. Solution: Ask the database administrator to perform the operation or grant the required privileges. Example: DELETE FROM SYS.ACCESS$; Output: SQL Error: ORA-01031: insufficient privileges

ORA-01033 ORACLE initialization or shutdown in progress Oracle SQL Error: ORA-01033 ORACLE initialization or shutdown in progress Cause: An attempt was made to log on while Oracle is being started or shut down. Solution: Wait a few minutes. Then retry the operation.

ORA-01017 invalid username/password; logon denied Oracle SQL Error: ORA-01017 invalid username/password; logon denied Cause: An invalid username or password was entered in an attempt to log on to Oracle. Solution: Enter a valid username and password combination in the correct format. Example:

ORA-00998: must name this expression with a column alias Oracle SQL Error: ORA-00998: must name this expression with a column alias Cause: An expression or function was used in a CREATE VIEW statement, but no corresponding column name was specified. Solution: Enter a column name for each column in the view in parentheses after the…(Continue Reading)