ORA-14459: missing GLOBAL keyword

Cause : keyword GLOBAL is missing while creating temporary table.

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

supply keyword.

update : 29-04-2017
ORA-14459

ORA-14459 - missing GLOBAL keyword
ORA-14459 - missing GLOBAL keyword

  • ora-26536 : refresh was aborted because of conflicts caused by deferred transactions
  • ora-12504 : TNS:listener was not given the SID in CONNECT_DATA
  • ora-22977 : missing or invalid attribute
  • ora-29663 : Unable to find a method that matches one or more of the functions
  • ora-00063 : maximum number of log files exceeded string
  • ora-00451 : foreground process died unexpectedly
  • ora-26034 : Column string does not exist in stream
  • ora-31204 : DBMS_LDAP: PL/SQL - Invalid LDAP Session.
  • ora-38907 : DML error logging is not supported for FILE column "string"
  • ora-02236 : invalid file name
  • ora-19205 : Attribute 'string' qualifies a non-scalar value in the select list
  • ora-06400 : NETCMN: No default host string specified
  • ora-26662 : unable to process STREAMS Data Dictonary information for object
  • ora-37121 : AW Spreadsheet invalidated
  • ora-14627 : Invalid operation was specified on a GLOBAL partitioned index
  • ora-04075 : invalid trigger action
  • ora-13603 : The specified parameter string cannot be fetched as a numeric value for task or object string.
  • ora-01783 : only one RECOVERABLE or UNRECOVERABLE clause may be specified
  • ora-28536 : error in processing Heterogeneous Services initialization parameters
  • ora-31651 : communication error with master process - detaching job
  • ora-09758 : osnipn: could not check port in name server.
  • ora-32621 : illegal aggregation in UNTIL iteration condition
  • ora-12735 : Instant Client Light: unsupported client character set string
  • ora-09751 : pw_attachPorts: server call pws_attach failed.
  • ora-12217 : TNS:could not contact PREFERRED_CMANAGERS in TNSNAV.ORA
  • ora-06564 : object string does not exist
  • ora-28132 : Merge into syntax does not support security policies.
  • ora-27502 : IPC error deleting OSD context
  • ora-02183 : valid options: ISOLATION_LEVEL { SERIALIZABLE | READ COMMITTED }
  • ora-35578 : (SQLOUT11) SQL cursor 'number' cannot be used with CURRENT OF syntax
  • 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.