Oracle/PLSQL: ORA-00903 Learn the cause and how to resolve the ORA-00903 error message in Oracle. Description When you encounter an ORA-00903 error, the following error message will appear: ORA-00903: invalid table name Cause You tried to execute a SQL statement that included an invalid table name or the table name does not exist. Resolution The […]
Category: Software
ORA-00902: invalid datatype
Oracle/PLSQL: ORA-00902 Learn the cause and how to resolve the ORA-00902 error message in Oracle. Description When you encounter an ORA-00902 error, the following error message will appear: ORA-00902: invalid datatype Cause You tried to execute a CREATE TABLE or ALTER TABLE statement that contained an invalid datatype. Resolution The option(s) to resolve this Oracle […]
ORA-00900: invalid SQL statement
Oracle/PLSQL: ORA-00900 Learn the cause and how to resolve the ORA-00900 error message in Oracle. Description When you encounter an ORA-00900 error, the following error message will appear: ORA-00900: invalid SQL statement Cause The statement that you’ve tried to execute is not a valid SQL statement. Resolution The option(s) to resolve this Oracle error are: […]
ORA-00401: the value for parameter name is not supported by this release
Oracle/PLSQL: ORA-00401 Learn the cause and how to resolve the ORA-00401 error message in Oracle. Description When you encounter this error, the following error message will appear: ORA-00401: the value for parameter name is not supported by this release Cause You tried to specify a value in the initialization file that is not supported by […]
ORA-00361: cannot remove last log member name group num
Oracle/PLSQL: ORA-00361 Learn the cause and how to resolve the ORA-00361 error message in Oracle. Description When you encounter an ORA-00361 error, the following error message will appear: ORA-00361: cannot remove last log member name group num Cause You tried to remove the last member of a redo log group. Resolution The option(s) to resolve […]
ORA-01722: invalid number
Oracle/PLSQL: ORA-01722 Learn the cause and how to resolve the ORA-01722 error message in Oracle. Description When you encounter an error, the following error message will appear: ORA-01722: invalid number Cause You executed a SQL statement that tried to convert a string to a number, but it was unsuccessful. Resolution The option(s) to resolve this […]
ORA-00304: requested INSTANCE_NUMBER is busy
Oracle/PLSQL: ORA-00304 Learn the cause and how to resolve the ORA-00304 error message in Oracle. Description When you encounter an ORA-00304 error, the following error message will appear: ORA-00304: requested INSTANCE_NUMBER is busy Cause You tried to start an Oracle instance by using an INSTANCE_NUMBER parameter value that is already in use. Resolution The option(s) […]
ORA-00301: error in adding log file – file cannot be created
Oracle/PLSQL: ORA-00301 Learn the cause and how to resolve the ORA-00301 error message in Oracle. Description When you encounter an error, the following error message will appear: ORA-00301: error in adding log file <name> – file cannot be created Cause You tried to create a redo log file, but the creation failed. Resolution The option(s) […]
ORA-00257: archiver is stuck. CONNECT INTERNAL only, until freed
Oracle/PLSQL: ORA-00257 Learn the cause and how to resolve the ORA-00257 error message in Oracle. Description When you encounter an ORA-00257 error, the following error message will appear: ORA-00257: archiver is stuck. CONNECT INTERNAL only, until freed Cause While trying to archive a redo log file, the ARCH process encountered an error. Resolution The option(s) […]
ORA-00201: control file version num incompatible with Oracle version num
Oracle/PLSQL: ORA-00201 Learn the cause and how to resolve the ORA-00201 error message in Oracle. Description When you encounter an error, the following error message will appear: ORA-00201: control file version num incompatible with Oracle version num Cause The control file was created by a version of Oracle that is different than the version of […]
