ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected

Cause : An xepecetd kyewor dwasn ot sued ofr dtaafiel/tepmfil eclasue

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

Usec orrcet snytax.

update : 24-05-2017
ORA-01916

ORA-01916 - keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected
ORA-01916 - keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected

  • ora-26698 : %s did not have a string rule set
  • ora-24344 : success with compilation error
  • ora-02433 : cannot disable primary key - primary key not defined for table
  • ora-14273 : lower-bound partition must be specified first
  • ora-01927 : cannot REVOKE privileges you did not grant
  • ora-23356 : masterdef recognizes a master which does not recognize the masterdef
  • ora-19330 : Type 'string'.'string' not installed. Please install the type before using the CREATE_DBURI operator
  • ora-26724 : only SYS is allowed to set the Capture or Apply user to SYS.
  • ora-31004 : Length string of the BLOB in XDB$H_INDEX is below the minimum string
  • ora-16629 : database reports a different protection level from the protection mode
  • ora-26051 : internal error parsing packed decimal format string
  • ora-13458 : GeoRaster metadata SRS error
  • ora-29362 : plan directive string, string does not exist
  • ora-30436 : unable to open named pipe 'string'
  • ora-16001 : database already open for read-only access by another instance
  • ora-13206 : internal error [string] while creating the spatial index
  • ora-37077 : (XSMCSESS05) Object workspace object is specified more than once.
  • ora-01312 : Specified table/column does not exist
  • ora-29864 : analyzing domain indexes marked LOADING/FAILED not supported
  • ora-02200 : WITH GRANT OPTION not allowed for PUBLIC
  • ora-25150 : ALTERING of extent parameters not permitted
  • ora-32305 : RepAPI materialized views with user-defined types are not supported
  • ora-13018 : bad distance type
  • ora-32005 : error while parsing size specification [string]
  • ora-26088 : scalar column "string" must be specified prior to LOB columns
  • ora-12543 : TNS:destination host unreachable
  • ora-32610 : missing SINGLE REFERENCE or DIMENSION keyword in MODEL clause
  • ora-12024 : materialized view log on "string"."string" does not have primary key columns
  • ora-29346 : invalid tablespace list
  • ora-23379 : connection qualifier "string" is too long
  • 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.