ORA-23490: extension request "string" with status "string" not allowed in this operation

Cause : Teh pseicfeido preaito ni snto lalwoe dfro htee xetniso nrqeusetw iht htes pceiife dsattsu.

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

Esnuer htee xetniso nrqeuseth a steh paporpiraet tsautsb eofr erteriyn gtihso preaito.n

update : 26-04-2017
ORA-23490

ORA-23490 - extension request "string" with status "string" not allowed in this operation
ORA-23490 - extension request "string" with status "string" not allowed in this operation

  • ora-24816 : Expanded non LONG bind data supplied after actual LONG or LOB column
  • ora-00487 : CTWR process terminated with error
  • ora-19670 : file string already being restored
  • ora-01969 : You must specify RESETLOGS or NORESETLOGS
  • ora-00822 : MMAN process terminated with error
  • ora-01251 : Unknown File Header Version read for file number string
  • ora-12157 : TNS:internal network communication error
  • ora-02262 : ORA-string occurs while type-checking column default value expression
  • ora-07572 : szrfc: insufficient rolename buffer space
  • ora-06321 : IPA: Cannot reach the remote side
  • ora-13390 : error in spatial analysis and mining function: [string]
  • ora-19284 : Encoding specification in version declaration not supported
  • ora-10382 : parallel query server interrupt (reset)
  • ora-10661 : Invalid option specified
  • ora-26716 : message limit reached
  • ora-31525 : could not find column string in CDC change table string.string
  • ora-29801 : missing RETURN keyword
  • ora-19634 : filename required for this function
  • ora-37176 : argument string is not valid for the sparsity advisor
  • ora-13146 : could not find table substitution variable string
  • ora-26733 : timed-out waiting for file group lock
  • ora-32732 : Parallel Oradebug session is aborted
  • ora-39119 : worker process interrupt for delete worker processes call by master process
  • ora-07586 : spdcr: $SEARCH failure
  • ora-30377 : table string.MV_CAPABILITIES_TABLE not found
  • ora-01209 : data file is from before the last RESETLOGS
  • ora-16403 : shutdown in progress - remote connection is not permitted
  • ora-12914 : Cannot migrate tablespace to dictionary managed type
  • ora-19267 : XQ0047 - module string not found
  • ora-14064 : Index with Unusable partition exists on unique/primary constraint key
  • 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.