ORA-25135: cannot use the SINGLE TABLE option

Cause : The SINGLE TABLE option is only valid for hash clusters.

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

Do not specify the SINGLE TABLE option.

update : 24-06-2017

ORA-25135 - cannot use the SINGLE TABLE option
ORA-25135 - cannot use the SINGLE TABLE option

  • ora-32820 : subscriber queue and exception queue must use same message system link
  • ora-30927 : Unable to complete execution due to failure in temporary table transformation
  • ora-00077 : dump string is not valid
  • ora-28100 : policy function schema string is invalid
  • ora-13050 : unable to construct spatial object
  • ora-02238 : filename lists have different numbers of files
  • ora-12412 : policy package string is not installed
  • ora-33024 : (XSAGDNGL11) AGGMAP workspace object contains duplicate information.
  • ora-15110 : no diskgroups mounted
  • ora-31056 : The document being inserted does not conform to string
  • ora-16755 : failed to set initialization parameter
  • ora-00405 : compatibility type "string"
  • ora-06024 : NETASY: VTM error
  • ora-16204 : DDL successfully applied
  • ora-00266 : name of archived log file needed
  • ora-13274 : operator invoked with non-compatible SRIDs
  • ora-12990 : duplicate option specified
  • ora-09932 : Close of ORACLE password file failed.
  • ora-19553 : device name string is invalid
  • ora-13611 : The command string is not a valid advisor command.
  • ora-01682 : read-only DB cannot allocate temporary space in tablespace string
  • ora-33003 : (XSAGDIMDROP) workspace object, to be transformed during data load, must be a base dimension and not otherwise referenced in the AGGMAP.
  • ora-01074 : cannot shut down ORACLE; inside a login session - log off first
  • ora-29541 : class string.string could not be resolved
  • ora-23316 : the masterdef is string
  • ora-28512 : cannot get data dictionary translations from string
  • ora-38775 : cannot disable flash recovery area - flashback database is enabled
  • ora-22835 : Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: string, maximum: string)
  • ora-39167 : Tablespace string was not found.
  • ora-26046 : REF column string expects scoped table name string; user passed in string.
  • 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.