| Business Objects Repository TableSpace issue [message #185207] |
Mon, 31 July 2006 09:02  |
mglynn
Messages: 4
Registered: July 2006
Location: London UK
|
Junior Member |
|
|
Hi , bit new to this place but wondered if anyone had any ideas on the following.
Using oracle 9i as the Business Objects Repository, the disk space usage was getting rather high (14 Gig). The exports of the database were 14 gig at this point.
The BO Admin then removed about 50% of the reports and the export went down to 7gig and about 50% of the rows were removed from the documents table in the schema.
Here comes the problem, the tablespace for the Repository hasn't shrunk , even though the reports are gone and that the export file has shrunk.
Its as though the reports are orphaned off someone else (somewhere secret perhaps ) in the tablespace.
|
|
|
|
| Re: Business Objects Repository TableSpace issue [message #185209 is a reply to message #185207] |
Mon, 31 July 2006 09:37  |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
use alter table to move the obj_m_documents table. this will release the space used and allow you to resize the datafile using the alter database command.
Not, you will have to rebuild the indexes on the obj_m_documents table.
Jim
|
|
|
|
| Re: Business Objects Repository TableSpace issue [message #185211 is a reply to message #185207] |
Mon, 31 July 2006 10:04 |
mglynn
Messages: 4
Registered: July 2006
Location: London UK
|
Junior Member |
|
|
I believe its the obj_x_table, still I've reindexed the indexes on both the _m_ and the _x_ , no improvement.
so moving the table will release space used ?
I didn't know that I will give it a try.
is this a known issue with BO ?
|
|
|
|
| Re: Business Objects Repository TableSpace issue [message #185212 is a reply to message #185211] |
Mon, 31 July 2006 10:06 |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
This has absolutely nothing to do with BO. and it's not an issue. This is how Oracle works. BO simply happens to be the application that is performing DML on the Oracle tables.
Jim
PS, when you export a document to corporate docs, the doc is stored in OBJ_M_DOCUMENTS AS WELL AS obj_x_DOCUMENT, YOU'LL NEED TO MOVE BOTH. Reindexing will do very little for you, untill you perform a Move.
[Updated on: Mon, 31 July 2006 10:11] Report message to a moderator |
|
|
|
| Re: Business Objects Repository TableSpace issue [message #185216 is a reply to message #185207] |
Mon, 31 July 2006 10:26 |
mglynn
Messages: 4
Registered: July 2006
Location: London UK
|
Junior Member |
|
|
think I being a bit stupid here ,didnt explain myself properly excuse me please,
what I mean is that the used space in the tablespace hasn't shrunk, I dont expect the actual tablespace space size to shrink , but after removing 50% of the reports I would expect the used size to decrease. that is my issue.
or would the used space not decrease until I move the table
does that change anything ?
sorry
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
