ORA-27490: cannot open disabled window "string.string"

Cause : The user tried to open a disabled window.

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

Enable the window and then try to open it again.

update : 26-09-2017
ORA-27490

ORA-27490 - cannot open disabled window "string.string"
ORA-27490 - cannot open disabled window "string.string"

  • ora-15056 : additional error message
  • ora-19751 : could not create the change tracking file
  • ora-39219 : directory object name is too long
  • ora-01089 : immediate shutdown in progress - no operations are permitted
  • ora-13750 : User "string" has not been granted the "ADMINISTER SQL TUNING SET" privilege.
  • ora-13911 : Threshold not found
  • ora-12536 : TNS:operation would block
  • ora-38756 : Flashback is already turned off for this tablespace.
  • ora-31065 : Cannot modify read-only property [string]
  • ora-39601 : Hash key is required.
  • ora-30112 : multiple values not allowed for parameter 'string'
  • ora-00470 : LGWR process terminated with error
  • ora-25296 : Queue Table string has a buffered queue string
  • ora-13339 : LRS polygon clipping across multiple rings
  • ora-04081 : trigger 'string' already exists
  • ora-13338 : failure in reversing LRS polygon/collection geometry
  • ora-14159 : duplicate subpartition name
  • ora-33066 : (XSAGDNGL32) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must be a hierarchy dimension of the relation.
  • ora-38305 : object not in RECYCLE BIN
  • ora-13340 : a point geometry has more than one coordinate
  • ora-19680 : some blocks not recovered. See trace file for details
  • ora-14021 : MAXVALUE must be specified for all columns
  • ora-39122 : Unprivileged users may not perform string remappings.
  • ora-24100 : error in ktz testing layer
  • ora-27435 : chain job terminated abnormally
  • ora-38468 : column "string" is not identified as a column storing expressions.
  • ora-32803 : value for string cannot be altered
  • ora-19373 : invalid staging table or tablespace
  • ora-09813 : Unable to get directory status
  • ora-12406 : unauthorized SQL statement for policy 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.