| shrink tablespace [message #418216] |
Thu, 13 August 2009 08:25  |
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
|
Senior Member |
|
|
Hi,
I have two tablespace with 30gb size.I have move all database objects from these tablespaces into newly created tablespace with same structure using MOVE TABLESAPCE commands. after that, i have dropped the old tablespaces.
I have checked the newly tablespace size. the size of the one tablespace is shrinked but other tablespace shows the same size. the same size is same as old tablespace size.i have executed the shrink tablespace using shrink command. The size of the tablespace is reduced.
Is shrink commands is needed after move tablespace into other tablespace?
Please give an commands?
|
|
|
|
| Re: shrink tablespace [message #418218 is a reply to message #418216] |
Thu, 13 August 2009 08:35  |
 |
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
If the question is "is it ALWAYS needed?" the answer is no... and you prove it with your other tablespace.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
