Home » RDBMS Server » Server Administration » tablespace defrag
tablespace defrag [message #208973] Tue, 12 December 2006 15:30 Go to next message
rdonakanti
Messages: 1
Registered: December 2006
Location: USA
Junior Member
I have some large tablespaces about 20 GB with just two tables about 10GB each. how can I defrag this tablespace ? export/importing these tables takes a long time ( > 24hrs ) which is unpracticle in our environment. Any ideas on how I can do this in less time.
thanks for any help.

Ram
Re: tablespace defrag [message #208975 is a reply to message #208973] Tue, 12 December 2006 15:35 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://www.oracle.com/technology/deploy/availability/pdf/defrag.pdf
Re: tablespace defrag [message #208976 is a reply to message #208973] Tue, 12 December 2006 15:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Oracle Version?
In Most cases, you do not need to worry about fragmentation with a proper tablespace design.
10gb tables are kinda 'small'.
You can do online table redifinition.
if you can afford offline , this is much simple.
sql> alter table table_name move tablespace_name;

Please search the forum for FRAGMENTATION.
You might find lots of interesting details.

Edit:
And Andrew was faster Smile

[Updated on: Tue, 12 December 2006 15:40]

Report message to a moderator

Re: tablespace defrag [message #209070 is a reply to message #208973] Wed, 13 December 2006 03:36 Go to previous message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
Moving is the way ... move the 2 table to a new tablespace , drop the old tablespace => rebuild indexes => Done !

Previous Topic: ORA-04052: error occurred when looking up remote object REPADMIN.SYS@DB
Next Topic: Temporary tablespace VS Temporary datafile question
Goto Forum:
  


Current Time: Fri Dec 09 05:47:50 CST 2016

Total time taken to generate the page: 0.16934 seconds