Oracle - Errores y soluciones
Error ORA-14508
- Jueves, 04 Abril 2013
ORA-14508: specified VALIDATE INTO table not found
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
- Lunes, 27 Agosto 2012
ORA-01084: invalid argument in OCI call
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
- Lunes, 27 Agosto 2012
ORA-01082: 'row_locking = always' requires the transaction processing option
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
- Lunes, 27 Agosto 2012
ORA-01083: value of parameter "string" is inconsistent with that of other instances
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
- Lunes, 27 Agosto 2012
ORA-01182: cannot create database file string - file is in use or recovery
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
- Martes, 21 Agosto 2012
ORA-01488: invalid nibble or byte in the input data
Cause: An impossible request for decimal to oracle number conversion was made.
Action: This conversion cannot be performed.
Error ORA-01181
- Viernes, 27 Julio 2012
ORA-01181: file string created before last known RESETLOGS, cannot recreate
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.
Más artículos...
Últimas Descargas
Artículos Relacionados
Últimos Contenidos
Office Hogar y Estudiantes 2007 descargar gratis.
Descargar gratis XAMPP para Windows
Descargar gratis XAMPP para Linux
Descarga WampServer todo en uno, PHP, Apache y MyS ...
Descargar gratis XAMPP 1.8.1 Portable para Windows
Descargar gratis Windows 7 Professional 32 bits en ...
Descargar gratis Windows 7 Professional 64 bits en ...
Descargar gratis gadget AddGadget All CPU Meter pa ...
Descargar Ares Gratis en español
Descargar gratis Windows Server 2008 32 bits en es ...
Descargar gratis WampServer 2.2D Windows 64 bit



