Dear All, Today, i faced this error with one of our user, I searched and found out the OLAP tablespaces requires 70GB for creating a single dimension and eats up the spaces like anything.
ORA-37999: Serious OLAP error: UPDATE. Please contact Oracle Technical Support.
ORA-03238: unable to extend LOB segment MSD.SYS_LOB0002005474C00004$$ subpartition SYS_LOB_SUBP8245 by 16 in tablespace APPS_TS_TX_DATA
ORA-06512: at "SYS.DBMS_AW", line 109 ORA-06512: at "SYS.DBMS_AW", line 193 ORA-06512: at line 1
Solution: Metalink ID:418107.1
Cause: The issue occurs because the data tablespace APPS_TS_TX_DATA ran out of space.
Solution
1) Add more space to the APPS_TS_TX_DATA tablespace. Have at least 10 GB of free space.
2) Add more space to the TEMP tablesapce. Have at least 10 GB of free space to allow big analytical workspaces.
3) You may put "autoextend on" on both tablespaces or make sure that enough physical space is available for them
Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.
You are encouraged to leave a comment.
You are encouraged to leave a comment.
Monday, February 02, 2009
Subscribe to:
Post Comments (Atom)
Let us be Friends...
Popular Posts
-
1. Installation of the Demantra Base Application or Patches Create a C:/Tmp folder on the machine where the setup.exe will be executed pri...
-
The Following Error was detected while doing Cloning of DB Tier. The actual Fact was: The server was heavily loaded, so the control file cre...
-
In this Blog, I am going to explain you the way you can get the Translation Synchronization Patch for the Language you license thro OAM. T...
-
Hi, everybody should come across, while during a clone, you might have experienced very poor performance while running txkWfClone.sh profil...
-
Secure Sockets Layer (SSL) SSL is a technology that defines the essential functions of mutual authentication, data encryption, and data inte...
-
This blog describes the process of re-creating an existing Applications Release 12 database instance using the export and import utilities....
-
Symptom: A MultiException has 6 exceptions. They are: 1. java.lang.AssertionError: Cannot export non clusterable object with jndiName:weblo...
-
Happy and Prosperous New Year 2010!!! Today I need to discuss an issue while planning to upgrade my 12.1.1 instance to 12.1.2 using the patc...
-
Primary Node: Host name: genius.chainsys.com IP : 192.168.2.236 File locations: apps - /oracle/D1/apps (SHARED) db - /oracle/PROD/db inst - ...
-
To build XDO objects if you face table or view not found during patching and if worker fails with status Failed on XDOLoader.class on produc...
No comments:
Post a Comment