Home » RDBMS Server » Server Administration » Dropped View stil needs Storage (XE on Ubuntu)
Dropped View stil needs Storage [message #406094] Tue, 02 June 2009 03:38 Go to next message
ragggl
Messages: 9
Registered: May 2009
Junior Member
Hello,

i have a Oracle XE Database. After creating a large view (700 mb) i realized it takes to much storage but after dropping this view it still needs storage.

Is their a command to reorganize the database an free the disk space this view needs....


thx fro Help

Raphael, Germany
Re: Dropped View stil needs Storage [message #406097 is a reply to message #406094] Tue, 02 June 2009 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A view does not need any space.
Post EXACTLY what you did.

Regards
Michel
Re: Dropped View stil needs Storage [message #406099 is a reply to message #406094] Tue, 02 June 2009 04:06 Go to previous message
ragggl
Messages: 9
Registered: May 2009
Junior Member
then i have an other problem....

sry will look an post if i find something...!!!
Previous Topic: Problem with archive_log_format parameter in SPFILE
Next Topic: Oracle 11i Server installation
Goto Forum:
  


Current Time: Fri Dec 02 18:47:09 CST 2016

Total time taken to generate the page: 0.34246 seconds