ORA-14004: missing PARTITION keyword

Cause : kyewrodP ATRIITO Nmsisnig

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

spupyl imsisn gkyewrod

update : 19-08-2017
ORA-14004

ORA-14004 - missing PARTITION keyword
ORA-14004 - missing PARTITION keyword

  • ora-09835 : addCallback: callback port is already in a set.
  • ora-02440 : Create as select with referential constraints not allowed
  • ora-14000 : only one LOCAL clause may be specified
  • ora-13628 : Insufficient privileges to access the task belonging to the specified user
  • ora-25449 : invalid variable name: string
  • ora-27060 : could not set close-on-exec bit on file
  • ora-36968 : (XSRELTBL11) workspace object must be a relation.
  • ora-30680 : debugger connection handshake failed
  • ora-09806 : Allocation of label string buffer failed.
  • ora-19613 : datafile string not found in backup set
  • ora-32502 : Cannot execute command. Flash Freeze is not in effect
  • ora-14644 : table is not subpartitioned by Hash method
  • ora-31533 : only one change set (string) is allowed in change source
  • ora-06712 : TLI Driver: error on accept
  • ora-13390 : error in spatial analysis and mining function: [string]
  • ora-19013 : Cannot create VARRAY columns containing XMLType
  • ora-12010 : cannot create materialized view log on table owned by SYS
  • ora-19267 : XQ0047 - module string not found
  • ora-27071 : unable to seek to desired position in file
  • ora-29393 : user string does not exist or is not logged on
  • ora-30553 : The function is not deterministic
  • ora-00336 : log file size string blocks is less than minimum string blocks
  • ora-13616 : The current user string has not been granted the ADVISOR privilege.
  • ora-14319 : DEFAULT cannot be specified with other values
  • ora-01485 : compile bind length different from execute bind length
  • ora-30753 : column or table string is substitutable
  • ora-39950 : invalid parameter for PLSQL warnings flag
  • ora-00369 : Current log of thread string not useable and other log being cleared
  • ora-13500 : SYSAUX DATAFILE clause specified more than once
  • ora-12585 : TNS:data truncation
  • 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.