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

Report message to a moderator

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: 68665
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

Report message to a moderator

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...!!!

Report message to a moderator

Previous Topic: Problem with archive_log_format parameter in SPFILE
Next Topic: Oracle 11i Server installation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 06:42:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.