Home » RDBMS Server » Server Administration » finding and fixing fragmented tablespaces
finding and fixing fragmented tablespaces [message #59038] Fri, 24 October 2003 08:43 Go to next message
Joyce
Messages: 13
Registered: March 2000
Junior Member
Does anyone have a script for finding and fixing fragmented tablespaces for an Oracle 8.1.6 database using dictionary managed tablespaces?

Report message to a moderator

Re: finding and fixing fragmented tablespaces [message #59039 is a reply to message #59038] Fri, 24 October 2003 09:40 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
You could migrate to Locally Managed tablespace !

-Thiru

Report message to a moderator

Re: finding and fixing fragmented tablespaces [message #59042 is a reply to message #59038] Fri, 24 October 2003 14:30 Go to previous message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
Just coalesce the tablespace on a regular basis.

Report message to a moderator

Previous Topic: performance prob.
Next Topic: What is a NameSpace?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 07 13:49:05 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.