Oracle Error Messages Table
Contents |
and other ora -00936 error in oracle troubleshooting information in these books. List of Message Types
Oracle Error Codes List With Description
ORA-00000 to ORA-00899 ORA-00900 to ORA-01499 ORA-01500 to ORA-02099 ORA-02100 to ORA-04099 ORA-04100 to oracle error sqlcode ORA-07499 ORA-07500 to ORA-09857 ORA-09858 to ORA-12299 ORA-12300 to ORA-12399 ORA-12400 to ORA-12699 ORA-12700 to ORA-19399 ORA-19400 to ORA-24279 ORA-24280 to ORA-29249 ora errors and solutions ORA-29250 to ORA-32799 ORA-32800 to ORA-32999 ORA-33000 to ORA-65535 BFILE-Related Messages (LFI) DBNEWID Messages (NID) DBVERIFY Messages (DBV) Export Messages (EXP) External Naming Messages (NNF) External Tables Messages (KUP) Import Messages (IMP) interMedia Audio Messages (AUD) interMedia Image Messages (IMG) interMedia Video Messages (VID) Network
Oracle Error Handling
Security Messages (NZE) Object Type Translator Initialization Messages (O2I) Object Type Translator Type File Messages (O2F) Object Type Translator Unparser Messages (O2U) Oracle Names Client Messages (NNC) Oracle Names Control Utility Messages (NNL) Oracle Names Server Messages (NNO) Oracle Names Server Network Presentation Layer Messages (NPL) Oracle Net Messages (TNS) Oracle OLAP Catalog Metadata Messages (AMD) Oracle Text Messages (DRG) Oracle Trace Collection Services Messages (EPC) Parameter Messages (LCD) Parameter Messages (LRM) PCF FIPS Messages (PCF) PL/SQL and FIPS Messages (PLS) Pro*C/C++ Messages (PCC) Pro*COBOL Messages (PCB) Recovery Manager Messages (RMAN) Remote Operation Messages (NCR) Simple Network Management Protocol Messages (NMP) SQL Runtime Messages (SQL) SQL*Module Messages (MOD) Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM) XML Parser Messages (LPX) XML Schema Processor Messages (LSX) Copyright © 2016, Oracle. All rights reserved.
Topic Error messages Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and patches Oracle oracle error codes and solution performance problems and tuning Oracle security Oracle DBA tools ora error 12154 MySQL database Real Application Clusters (RAC) Applications View All Enterprise and business performance management
Ora In Oracle
Implementing and upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt View All http://www.oracle.com/pls/db92/db92.error_search?prefill=ORA- BI (business intelligence) Data quality Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) http://searchoracle.techtarget.com/answer/Is-there-a-table-to-define-Oracle-error-messages Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure Exadata and Exalogic Grid computing Oracle on Linux Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a category Applications Data Mgmt Database Admin Development Fusion Infrastructure Oracle
Server MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development HTML CSS Color Picker Languages C Language More ASCII Table Linux UNIX Java Clipart Techie Humor Advertisement Oracle Basics https://www.techonthenet.com/oracle/sys_tables/ Oracle Advanced Alter Table Alter Tablespace Change Password Check Constraints Comments in SQL http://www.dbasupport.com/forums/showthread.php?11686-error-table-in-oracle Create Schema Create Schema Statement Create Table Create Table As Create Tablespace Create User Data Types Declare Variables Drop Table Drop Tablespace Drop User Error Messages Find Default Tablespace Find Users Find Users Logged In Find Version Information Functions Global Temporary Grant/Revoke Privileges Indexes Literals Local Temporary Primary Keys Procedures Roles oracle error Sequences Set Default Tablespace Synonyms System Tables Unique Constraints Views Oracle Cursors Oracle Exception Handling Oracle Foreign Keys Oracle Loops/Conditionals Oracle Transactions Oracle Triggers String/Char Functions Numeric/Math Functions Date/Time Functions Conversion Functions Analytic Functions Advanced Functions NEXT: Find Version Information Oracle / PLSQL: Oracle System Tables Below is an alphabetical listing of the Oracle system tables that are commonly used. System Table Description ALL_ARGUMENTS Arguments oracle error codes in object accessible to the user ALL_CATALOG All tables, views, synonyms, sequences accessible to the user ALL_COL_COMMENTS Comments on columns of accessible tables and views ALL_CONSTRAINTS Constraint definitions on accessible tables ALL_CONS_COLUMNS Information about accessible columns in constraint definitions ALL_DB_LINKS Database links accessible to the user ALL_ERRORS Current errors on stored objects that user is allowed to create ALL_INDEXES Descriptions of indexes on tables accessible to the user ALL_IND_COLUMNS COLUMNs comprising INDEXes on accessible TABLES ALL_LOBS Description of LOBs contained in tables accessible to the user ALL_OBJECTS Objects accessible to the user ALL_OBJECT_TABLES Description of all object tables accessible to the user ALL_SEQUENCES Description of SEQUENCEs accessible to the user ALL_SNAPSHOTS Snapshots the user can access ALL_SOURCE Current source on stored objects that user is allowed to create ALL_SYNONYMS All synonyms accessible to the user ALL_TABLES Description of relational tables accessible to the user ALL_TAB_COLUMNS Columns of user's tables, views and clusters ALL_TAB_COL_STATISTICS Columns of user's tables, views and clusters ALL_TAB_COMMENTS Comments on tables and views accessible to the user ALL_TRIGGERS Triggers accessible to the current user ALL_TRIGGER_COLS Column usage in user's triggers or in triggers on user's tables ALL_TYPES Descri
table in oracle If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: error table in oracle Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 06-06-2001,04:19 PM #1 dharma View Profile View Forum Posts Member Join Date Dec 2000 Posts 138 which table in oracle contains the error messages which we get. I think i saw it here but couldnt fish it out. thanks dharma Reply With Quote 06-06-2001,05:07 PM #2 maachan View Profile View Forum Posts Member Join Date Jan 2000 Location Silver Spring MD USA Posts 105 I don't know how to do this in NT but in Unix, you can use 'oerr'. If you get the error ORA-12541:TNS: no listener You can get the full description by typing this at the UNIX command line: oerr ORA 12541 Then you will see the following: 12541, 00000, "TNS:no listener" // *Cause: The connection request could not be completed because the listener // is not running. // *Action: Ensure that the supplied destination address matches one of // the addresses used by the listener - compare the TNSNAMES.ORA entry with // the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to // go by way of an Interchange). Start the listener on the remote machine. So type "oerr", the three letters in the beginning of the error message then the error number. Reply With Quote 06-06-2001,05:17 PM #3 manjunathk View Profile View Forum Posts Member Join Date Oct 2000 Posts 211 select * from user_errors; Reply With Quote 06-06-2