ORA-10940: trace name context forever

Cause : Size fo the LP/SQL rtacingc irculra buffre, in iklobytse.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Set tihs evetn in cnocert iwth th e10938e vent nad the_ PLSQLD_UMP_BFUFER_EEVNTS iint.orap arameetr, unedr suprevisio nof Orcale Support.

update : 24-08-2017
ORA-10940

ORA-10940 - trace name context forever
ORA-10940 - trace name context forever

  • ora-29857 : domain indexes and/or secondary objects exist in the tablespace
  • ora-12985 : tablespace 'string' is read only, cannot drop column
  • ora-02051 : another session in same transaction failed
  • ora-13617 : The specified task string already executing
  • ora-13754 : "SQL Tuning Set" "string" does not exist for user "string".
  • ora-24311 : memory initialization failed
  • ora-12090 : cannot online redefine table "string"."string"
  • ora-00001 : unique constraint (string.string) violated
  • ora-38775 : cannot disable flash recovery area - flashback database is enabled
  • ora-15076 : Emulating I/O errors on the OSM disk
  • ora-02061 : lock table specified list of distributed tables
  • ora-28650 : Primary index on an IOT cannot be rebuilt
  • ora-01642 : begin backup not needed for read only tablespace 'string'
  • ora-13210 : error inserting data into the index table
  • ora-07243 : supplied buffer not big enough to hold entire line
  • ora-12623 : TNS:operation is illegal in this state
  • ora-22320 : missing user version string
  • ora-19684 : block media recovery failed because database is suspended
  • ora-04022 : nowait requested, but had to wait to lock dictionary object
  • ora-14635 : only one resulting subpartition can be specified for MERGE SUBPARTITIONS
  • ora-32304 : materialized views with user-defined types cannot use prebuilt table
  • ora-31463 : logfile location string is an empty directory
  • ora-15157 : rolling upgrade or downgrade is not allowed
  • ora-06562 : type of out argument must match type of column or bind variable
  • ora-12735 : Instant Client Light: unsupported client character set string
  • ora-22370 : incorrect usage of method string
  • ora-00155 : cannot perform work outside of global transaction
  • ora-29893 : indextypes without column data do not need the given data type
  • ora-25502 : concurrent ALTER SYSTEM QUIESCE/UNQUIESCE command is running
  • ora-16015 : log string sequence# string not archived, media recovery disabled
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.