| ALTER TABLE MOVE TABLESPACE [message #123822] |
Wed, 15 June 2005 00:45  |
IA
Messages: 91
Registered: March 2004
|
Member |
|
|
Hi Everyone,
Does the ALTER TABLE move TABLESPACE command reorganise (ie defragment) a table?
Is this the equivelant to exporting the data, truncating and importing the data?
Thanks in advance
IA
|
|
|
|
|
|
| Re: ALTER TABLE MOVE TABLESPACE [message #123894 is a reply to message #123822] |
Wed, 15 June 2005 08:24  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
|
And you don't actually have to move the table to another tablespace, can just keep it in the same tablespace with the alter table move. And can use the opportunity to compress it if you so desire.
|
|
|
|
|
|
| Re: ALTER TABLE MOVE TABLESPACE [message #125551 is a reply to message #125543] |
Mon, 27 June 2005 08:53 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
| everton wrote on Mon, 27 June 2005 06:39 |
But if you compress the table the alter table move will no longer be able to shuffle the rows to reorganise the table.
|
Why not?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
