Home » RDBMS Server » Server Administration » need help to get space from tablespace (oracle 10.2.0.3)
need help to get space from tablespace [message #389575] Mon, 02 March 2009 12:52 Go to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
Experts,

i have dropped some partition on my production database. i am able to get space back at tablespace level. when i am trying to resize the datafile. oracle not able to resize the files and showing some errors.


i believe this is due to high water mark.
can any one help to find where is the problem. now i am not providing any information in this site. please ask me any information if you required then i will be happy to provide that information.
Re: need help to get space from tablespace [message #389576 is a reply to message #389575] Mon, 02 March 2009 12:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you SEARCH before posting?
Do you think you are the first one to have this problem?

Can you also read OraFAQ Forum Guide and follow it?

Regards
Michel
Re: need help to get space from tablespace [message #389723 is a reply to message #389575] Tue, 03 March 2009 06:55 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Does it occur to you that it might be useful to supply us with the command that you executed, and the error that you got.

You believe that the problem is to do with the high watermark, but without the error, we have no way of knowing, do we?
Re: need help to get space from tablespace [message #391049 is a reply to message #389575] Tue, 10 March 2009 15:52 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

Can you provide which error are you getting please?
Re: need help to get space from tablespace [message #391570 is a reply to message #389575] Thu, 12 March 2009 10:46 Go to previous messageGo to next message
dba-assist
Messages: 3
Registered: November 2008
Junior Member
[deleted] will show you tablespace allocation per partition and used and free space

[Updated on: Thu, 12 March 2009 13:00] by Moderator

Report message to a moderator

Re: need help to get space from tablespace [message #391573 is a reply to message #391570] Thu, 12 March 2009 10:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
So will a simple sql Wink
Re: need help to get space from tablespace [message #391586 is a reply to message #391570] Thu, 12 March 2009 11:33 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
STOP SPAMMING ALL TOPICS WITH YOUR USELESS TOOL.

Regards
Michel

[Updated on: Thu, 12 March 2009 11:34]

Report message to a moderator

Previous Topic: Table statistic
Next Topic: User Role
Goto Forum:
  


Current Time: Thu Dec 08 10:13:08 CST 2016

Total time taken to generate the page: 0.14146 seconds