Category Archives: ORA Database Error Messages

ORA-33315: (XSDELDENTANON) You cannot delete workspace object while looping over unnamed composite workspace object

oracle

ORA-33315: (XSDELDENTANON) You cannot delete workspace object while looping over unnamed composite workspace object
Cause: While looping over the named anonymous composite, an attempt was made to delete an object which is dimensioned by it
Action: Delete the object outside of a loop over the dimension

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33313: (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable

oracle

ORA-33313: (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable
Cause: User attempted to delete a variable, but some partitioned variable was defined to use that variable as the target of one of its external partitions
Action: DELETE the partitioned variable or CHGDFN DROP PARTITION the the external partition from the partitioned variable, then delete the target variable

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33309: (DBVALID05) SEVERE ERROR: Record number used but not allocated (PS number)

oracle

ORA-33309: (DBVALID05) SEVERE ERROR: Record number used but not allocated (PS number)
Cause: The AW VALIDATE command has detected a problem that will result in corruption of the analytic workspace. There is no corruption yet
Action: Export and recreate the analytic workspace

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33308: (DBVALID04) SEVERE ERROR: Record number used but not allocated

oracle

ORA-33308: (DBVALID04) SEVERE ERROR: Record number used but not allocated
Cause: The AW VALIDATE command has detected a problem that will result in corruption of the analytic workspace. There is no corruption yet
Action: Export and recreate the analytic workspace

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33306: (DBVALID03) The AW VALIDATE command cannot be used with read-only analytic workspace string

oracle

ORA-33306: (DBVALID03) The AW VALIDATE command cannot be used with read-only analytic workspace string
Cause: The AW VALIDATE command does not support read-only access
Action: Attach the analytic workspace read/write and try again

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33305: (DBVALID06) Note: Record number was allocated but not used. This can result in wasted space. (PS number)

oracle

ORA-33305: (DBVALID06) Note: Record number was allocated but not used. This can result in wasted space. (PS number)
Cause: This is a benign message. The AW VALIDATE command found an analytic workspace has some inaccessible space
Action: Either nothing, or export and recreate the analytic workspace

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33304: (DBVALID02) Note: Record number was allocated but not used. This can result in wasted space

oracle

ORA-33304: (DBVALID02) Note: Record number was allocated but not used. This can result in wasted space
Cause: This is a benign message. The AW VALIDATE command found an analytic workspace has some inaccessible space
Action: Either nothing, or export and recreate the analytic workspace

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33302: (DBVALID01) SEVERE ERROR: Record number multiply used

oracle

ORA-33302: (DBVALID01) SEVERE ERROR: Record number multiply used
Cause: The AW VALIDATE command has detected an error in the structure of the analytic workspace. This error will result in the corruption of one or more objects
Action: Export what you can of the analytic workspace

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33300: (DBERR22) %a string string Analytic workspace %p cannot be opened because it was last modified by an incompatible version of %p

oracle

ORA-33300: (DBERR22) %a string string Analytic workspace %p cannot be opened because it was last modified by an incompatible version of %p
Cause: The user attempted to attach an old OLAP Services analytic workspace that cannot be converted by this version of OLAP Services
Action: Either create a new analytic workspace or try using a version of OLAP Services compatible with the one that created this analytic workspace

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33298: (AWUPG01) Analytic Workspace string is already in the newest format allowed by the current compatibility setting

oracle

ORA-33298: (AWUPG01) Analytic Workspace string is already in the newest format allowed by the current compatibility setting
Cause: User ran the DBMS_AW.CONVERT procedure on an Analytic Workspace that was created in or previously upgraded to the current compatibility mode
Action: If upgrading the Analytic Workspace is necessary, upgrade the database instance and then re-run DBMS_AW.CONVERT. If the new features offered by upgrading the Analytic Workspace are not required, then no action is needed

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/