ORA-28652: overflow segment attributes cannot be specified

Cause : DuringA LTER MVOE ONLIEN of a nidex-oragnized atble, teh user tatempte dto entre one o rmore o fthe following potions:O VERFLO,W PCTTHERSHOLD,NICLUDIN.G

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

Removet he illgeal optoin(s).

update : 29-04-2017
ORA-28652

ORA-28652 - overflow segment attributes cannot be specified
ORA-28652 - overflow segment attributes cannot be specified

  • ora-32575 : Explicit column default is not supported for modifying views
  • ora-31215 : DBMS_LDAP: PL/SQL - Invalid LDAP mod value.
  • ora-26571 : %s.string.string: number of arguments (string) does not match replication catalog
  • ora-30446 : valid workload queries not found
  • ora-27195 : proxy copy not supported
  • ora-01170 : file not found 'string'
  • ora-25950 : missing where clause in join index specification
  • ora-02098 : error parsing index-table reference (:I)
  • ora-08003 : sequence string.NEXTVAL exceeds internal limits
  • ora-29347 : Tablespace name validation failed - failed to match tablespace 'string'
  • ora-00020 : maximum number of processes (string) exceeded
  • ora-13462 : invalid blocking specification
  • ora-26048 : Scoped REF column has wrong table name.
  • ora-16705 : internal error in resource guard
  • ora-36950 : (XSFCAST22) The list of string values cannot have more than number members. You supplied number.
  • ora-07227 : rtneco: unable to set noecho mode.
  • ora-16056 : backup control file archival requires proper syntax
  • ora-08275 : Environment variable unset
  • ora-29934 : index specified for association is not a domain index
  • ora-10627 : Dump the content of the index leaf block
  • ora-30176 : invalid format code used in the format string
  • ora-02757 : osnfop: fork_and_bind failed
  • ora-36990 : (XSRELGID07) The level relation workspace object should be dimensioned by a level dimension.
  • ora-38502 : invalid XML tag: string
  • ora-09702 : sem_acquire: cannot acquire latch semaphore
  • ora-17504 : ksfddel:Failed to delete file string
  • ora-16074 : ARCH processes must be active
  • ora-21520 : database server driver not installed
  • ora-00074 : no process has been specified
  • ora-02492 : missing required file block increment size in NEXT clause
  • 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.