Oracle - Errores y soluciones
Búsqueda personalizada

Oracle - Errores y soluciones

Error ORA-14508

ORA-14508: specified VALIDATE INTO table not foundbases_datos_2

 


 

Cause: The specified table either does not exist or user does not have the proper privleges.

 

Action: Specify the correct table to use.

 

Al usar la instrucción analyze table <table_name> validate structure cascade para validar tablas con particiones se puede obtener el siguiente error:

 

ORA-14508: specified VALIDATE INTO table not found

 

Esto se debe a que no existe la tabla invalid_rows

 

Solución:

 

Para crear la tabla invalid_rows debemos ejecutar el siguiente script sql, $ORACLE_HOME/rdbms/admin/utlvalid.sql

Error ORA-01084

ORA-01084: invalid argument in OCI callbases_datos_2

 


 

Cause: The failing OCI call contains an argument with an invalid value.

 

Action: Use valid argument values. For more information, see the Programmer's Guide to the Oracle Call Interfaces and the appropriate programming language supplement.

Error ORA-01082

ORA-01082: 'row_locking = always' requires the transaction processing optionbases_datos_2

 


 

Cause: "row_locking = always" is specified in INIT.ORA file. This feature is not supported by ORACLE without the transaction processing option.

 

Action: Remove it from INIT.ORA file or set it to "default" or "intent".

Error ORA-01083

ORA-01083: value of parameter "string" is inconsistent with that of other instancesbases_datos_2

 


 

Cause: The value of the given parameter is required to be the same for all instances in the cluster database configuration. ROW_LOCKING and SERIALIZABLE are 2 examples.

 

Action: Change the value of the parameter in INIT.ORA file to match that of other cluster database instances.

Error ORA-01182

ORA-01182: cannot create database file string - file is in use or recoverybases_datos_2

 


 

Cause: Attempted to use ALTER DATABASE CREATE DATAFILE to recreate a datafile that is online in an open instance or is being recovered.

 

Action: Close database in all instances and end all recovery sessions.

Error ORA-01488

ORA-01488: invalid nibble or byte in the input databases_datos_2

 


 

Cause: An impossible request for decimal to oracle number conversion was made.

 

Action: This conversion cannot be performed.

Error ORA-01181

ORA-01181: file string created before last known RESETLOGS, cannot recreatebases_datos_2

 


 

Cause: Attempted to use ALTER DATABASE CREATE DATAFILE to recreate a datafile that existed before the last known RESETLOGS.

 

Action: Find a backup of the file, and recover it. Do incomplete recovery to time before file was originally created.

Página 1 de 29