| tablespace defrag [message #208973] |
Tue, 12 December 2006 15:30  |
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 #208976 is a reply to message #208973] |
Tue, 12 December 2006 15:39  |
 |
Mahesh Rajendran
Messages: 10708
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 
[Updated on: Tue, 12 December 2006 15:40] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
