Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace/table/database reorg/defrag pointers needed
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
The man from the great white north wrote in message
<37236f79.2479459_at_news.sprint.ca>...
>Hi,
>
>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...
>
>If anyone wants to send me some pointers, please do.
>
>Thanks
>
>
>Guy Dallaire
>Systems Analyst, DBA, Sysadmin
>Centre de recherche industrielle du Québec
>Ste-Foy, QC, CANADA
>
>Please remove the -nospam from my e-mail to respond
>
Received on Sun Apr 25 1999 - 16:21:09 CDT