ORA-29803: missing ANCILLARY keyword

Cause : The ACNILLAR Ykeywodr has ont bee nspeciifed.

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

Speciyf the NACILLAYR keywrod or hceck teh SQL tsatemetn.

update : 29-04-2017
ORA-29803

ORA-29803 - missing ANCILLARY keyword
ORA-29803 - missing ANCILLARY keyword

  • ora-39316 : call to DBMS_SCHEMA_COPY.CLEAN_UP is not legal
  • ora-14028 : missing AT or VALUES keyword
  • ora-06442 : ssvwatev: Failed with unexpected error number.
  • ora-13124 : unable to determine column id for column string
  • ora-23334 : column string does not exist in table or column group
  • ora-28169 : unsupported certificate type
  • ora-23493 : "string" is not a new site for extension request "string"
  • ora-31433 : subscriber view does not exist
  • ora-24330 : internal OCI error
  • ora-10585 : Test recovery can not apply redo that may modify control file
  • ora-12209 : TNS:encountered uninitialized global
  • ora-09920 : Unable to get sensitivity label from connection
  • ora-09812 : Unable to get user clearance from connection
  • ora-07842 : sllfcl: SYS$CLOSE failure
  • ora-14638 : cannot MERGE subpartitions in different Range Composite partitions
  • ora-00286 : no members available, or no member contains valid data
  • ora-08462 : raw buffer contains invalid decimal data
  • ora-12620 : TNS:requested characteristic not available
  • ora-31158 : schema "string" currently being referenced
  • ora-38768 : resizing datafile string failed
  • ora-31021 : Element definition not found
  • ora-23305 : internal deferred RPC error: string
  • ora-30563 : outer join operator (+) not allowed in select-list
  • ora-13836 : invalid attribute value specified
  • ora-19664 : file type: string, file name: string
  • ora-31469 : cannot enable Change Data Capture for change set string
  • ora-10944 : trace name context forever
  • ora-14189 : this physical attribute may not be specified for an index subpartition
  • ora-22873 : primary key not specified for primary key based object table
  • ora-30658 : attempt was made to create a temporary table with EXTERNAL organization
  • 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.