Home » RDBMS Server » Server Administration » shrink tablespace (oracle10g, linux)
shrink tablespace [message #418216] Thu, 13 August 2009 08:25 Go to next message
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 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: copying oracle binaries to another machine
Next Topic: Where can I find a sample of dbca.rsp file?
Goto Forum:
  


Current Time: Sun Dec 04 10:22:10 CST 2016

Total time taken to generate the page: 0.27808 seconds