Home » RDBMS Server » Server Administration » how will i know if a table data is fragmented or not
how will i know if a table data is fragmented or not [message #58650] Tue, 23 September 2003 14:24 Go to next message
Kapil
Messages: 145
Registered: May 2002
Senior Member
can any one tell me, is there anyway that i can say that table is Fragmented. if it is then how will i de-Fragmented the tables. and what does "deallocate unsed space" clause will do

Report message to a moderator

Re: how will i know if a table data is fragmented or not [message #58705 is a reply to message #58650] Fri, 26 September 2003 08:50 Go to previous message
Mohd Samiuddin
Messages: 2
Registered: January 2003
Junior Member
You can use Tablespace Map GUI utility supplied with Oracle8i rel 2 or Oracle9i. It will graphically show you whether the table is fragmented or not. You can ReOrg procedure to defragment a table.

Sami

Report message to a moderator

Previous Topic: Connecting Oracle to Oracle Forms
Next Topic: Two different instance can access one database in same machine
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:21:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.