Home » RDBMS Server » Server Administration » shrink tablespace (oracle10g, linux)
shrink tablespace [message #418216] Thu, 13 August 2009 08:25 Go to next message
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member

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 Go to previous message
Michel Cadot
Messages: 65135
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.

Previous Topic: copying oracle binaries to another machine
Next Topic: Where can I find a sample of dbca.rsp file?
Goto Forum:

Current Time: Wed Aug 16 23:06:27 CDT 2017

Total time taken to generate the page: 0.09297 seconds