Home » RDBMS Server » Server Administration » Reorg table in 8.0.5
Reorg table in 8.0.5 [message #63977] Wed, 01 December 2004 11:00 Go to next message
Kevin Darden
Messages: 6
Registered: July 2004
Junior Member
What is the best way to reorganize a table in 8.0.5.? With ALTER TABLE MOVE not being available, what is the least painful way to consolidate those extents? Thanks in advance, Kevin.

Report message to a moderator

Re: Reorg table in 8.0.5 [message #63985 is a reply to message #63977] Wed, 01 December 2004 23:21 Go to previous message
dilip kumar
Messages: 111
Registered: December 2003
Senior Member
Hi

you can go export of that table the drop the table and import it again...

Regards

D.Dilip

Report message to a moderator

Previous Topic: ORA-00018:maximum number of sessions exceeded,ORACLE 9i
Next Topic: Database Not allowing further logins
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 10 01:29:17 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.