How to re-org the tablespace?(x8)

I'm trying to find some documents explaining exactly what is a
table/tablespace/databse reorg/defrag and how to actually do this in a
safe manner without losing any data, grants, foreign keys, etc...

For example, the document should answer questions like:

a) How to determine if one really needs to reorganize
b) How to do it whitout losing FK's, grants, etc...
c) Does one need to drop a table or simply truncate it before
reimporting it (truncating it would permit me to keep the grants, the
foreign keys, etc...)
d) How about moving tables around (changing tablespaces)
e) How to make sure that no one can access/modify the data during the
reorg ? Startup restrict ?
f) etc...

I'm sure there is some good papers about this evrywhere but I could
not find anything useful yet on the internet. I search IOUG, oracle
web site, technet, oramag, etc...


Ans:

Go to Platinum's web site (http://www.platinum.com) or Quest Software's web
site (http://www.quests.com). Platinum sells a tool called TsReorg and Quest
sells a tool called StorageManager. In addition (and more to the point of
answering your question), both vendors have available for download numerous
White Papers on various subjects (while promoting their tools), including
database/tablespace/table/index frag/defrag.

Allan Kelly
 
 

Hosted by www.Geocities.ws

1