oracle to number invalid number

Ora-01722: Invalid Number, ora-01722 Invalid Number One of the reasons for this error: The types of fields associated with table A and table B are inconsistent, for example: The aid in Table A is the primary key, the bid in Table B is the aid

Oracle basic concepts and comparison with informix I. ConceptsUser: informix directly uses the user management system of the operating system. Generally, root and informix are used as super operators to manage other users. Oracle has its own user

ORA-00001: violation of unique constraints (.) ORA-00017: Request session to set trace event ORA-00018: exceeds Max sessions ORA-00019: exceeds Max session licenses ORA-00020: exceeds Max processes () ORA-00021: Session is attached to some other

The racle database system is a complex software system. Without understanding its internal structure principles and relationships, it is impossible to design and Compile High-Quality application software systems or manage a complex application

Article turned from: 68490265Oracle Stitching Strings concat Small things to be aware ofIn the SSM framework when writing code, because the database replaced by Oracle, when the fuzzy query data suddenly found an errorSELECT * from Sys_menu where

EXP-00008: encountered Oracle error 904 ORA-00904: "maxsize": Invalid identifier Cause: the Oracle version is different. Run C:/> exp PLX/PLX @ orcl file = C:/PLX. dmp tables = (S, SC, c) Result Error Export: Release 11.1.0.6.0-production on Sunday

Created: Article attributes: original Article submission: T_Torchidy (jnchaha_at_163.com) Oracle web Environment Injection Technology## BY Jianxin# Http://www.loveshell.net/# Preface I am not a professional database administrator, nor a researcher

When migrating data using the Impdp/imp tool, warnings for invalid objects are often prompted and need to be handled as follows.1. Querying invalid objects for a specified userSu–oracleSqlplus/as SYSDBASql> Select Owner,object_name,replace

There are a number of bizarre error cases encountered in the use of Oracle data pumps, which summarize some of the problems and solutions that you have encountered while using the data pump. Are the problems encountered in the use of the process,

1. How does the invalid object come?The Oracle database would invalidate objects if a dependent object is changed. If I rebuild A table, the indexes on that table would become invalid because they use the table ' srowids and Rebuil Ding the table