Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » URGENCY!!!!!!!!!Defragmentatation of a Oracle Tablespace
URGENCY!!!!!!!!!Defragmentatation of a Oracle Tablespace [message #76196] Wed, 03 October 2001 00:34 Go to next message
Lena Pilloni
Messages: 5
Registered: October 2001
Junior Member
Hi,
I'v encountered a problem : I need to defragment a Oracle tablespace, but the usual method to exporting the database and importing it does not have any result.The index of defragmentation is always the same !
I've execute this query to retrive the defragmentation index :
"select tablespace_name,
sqrt(max(blocks)/sum(blocks))*(100/sqrt(sqrt(count(blocks)))) Frammentazione
from dba_free_space
group by tablespace_name
order by 1".
The results has been :
_"TABLESPACE_NAME","FRAMMENTAZIONE"
"BENQUAL_IDX","35.3699869774981"
"BENQUAL_TAB","65.762521320816"
"IEFSENCY_IDX","78.5440222249267"
"IEFSENCY_ROLL","28.5639488447158"
"IEFSENCY_TAB","23.603774521512"
"IEFSENCY_TEMP","59.4603557501361"
"SYSTEM","100" _

I need urgently help .................!!!!!!!!!!!

----------------------------------------------------------------------
Re: URGENCY!!!!!!!!!Defragmentatation of a Oracle Tablespace [message #76204 is a reply to message #76196] Thu, 11 October 2001 14:05 Go to previous messageGo to next message
Chris Albright
Messages: 2
Registered: October 2001
Junior Member
I'm sorry to ask this, but you did drop and re-create the tables before re-importing them right?

----------------------------------------------------------------------
Re: URGENCY!!!!!!!!!Defragmentatation of a Oracle Tablespace [message #76206 is a reply to message #76204] Thu, 11 October 2001 23:57 Go to previous message
Lena Pilloni
Messages: 5
Registered: October 2001
Junior Member
No, I did not.
I will try to do this.
Thanks.

----------------------------------------------------------------------
Previous Topic: showing oracle messages in asp
Next Topic: urgent! how to chnage sys pswd during 9ias install?
Goto Forum:
  


Current Time: Fri Mar 29 06:27:50 CDT 2024