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 : 25-06-2017
ORA-14459

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

  • ora-24300 : bad value for mode
  • ora-15027 : active use of diskgroup "string" precludes its dismount
  • ora-01555 : snapshot too old: rollback segment number string with name "string" too small
  • ora-02876 : smpini: Unable to attach to shared memory for PGA
  • ora-25108 : standby lock name space exceeds size limit of string characters
  • ora-15054 : disk "string" does not exist in diskgroup "string"
  • ora-24391 : invalid fetch operation
  • ora-14327 : Some index [sub]partitions could not be rebuilt
  • ora-31071 : Invalid database username or GUID string
  • ora-19638 : file string is not current enough to apply this incremental backup
  • ora-14192 : cannot modify physical index attributes of a Hash index partition
  • ora-15058 : disk 'string' belongs to an incompatible diskgroup
  • ora-38718 : Invalid thread number specified in the DUMP FLASHBACK command.
  • ora-38432 : EVALUATE operator only allowed on an expression column
  • ora-39311 : call to DBMS_SCHEMA_COPY.CLONE_RECOVERY is not legal
  • ora-29503 : SCHEMA keyword not valid with NAMED keyword
  • ora-12597 : TNS:connect descriptor already in use
  • ora-24094 : invalid transformation, target type does not match that of the queue
  • ora-38470 : cannot revoke a privilege that was not granted.
  • ora-00335 : online log string: No log with this number, log does not exist
  • ora-02700 : osnoraenv: error translating ORACLE_SID
  • ora-13281 : failure in execution of SQL statement to retrieve WKT
  • ora-24375 : Cannot use V6 syntax when talking to a V8 server
  • ora-08314 : sllfcf: Error closing file
  • ora-27039 : create file failed, file size limit reached
  • ora-16003 : standby database is restricted to read-only access
  • ora-24027 : AQ HTTP propagation encountered error, status-code string, string
  • ora-36700 : (XSRELTBL04) Dimension workspace object cannot be qualified more than once.
  • ora-38859 : instance string (thread string) is not ready to be disabled
  • ora-40291 : model cost not available
  • 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.