Home » SQL & PL/SQL » SQL & PL/SQL » how to delete data (oracle 9.2i)
how to delete data [message #276400] Thu, 25 October 2007 01:54 Go to next message
uowzd01
Messages: 2
Registered: October 2007
Junior Member
Hi, I got a oracle database with a few big schemas(about 20 Gb), most of them are useless, to save space, I tried to delete some schemas by using--drop user username cascade; but after droping them my database is still the same size, can anyone teach me how to delete those datas? Thank you.
Re: how to delete data [message #276409 is a reply to message #276400] Thu, 25 October 2007 02:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Data are deleted but space does not go back to system.

Regards
Michel
Re: how to delete data [message #276441 is a reply to message #276400] Thu, 25 October 2007 03:01 Go to previous messageGo to next message
kashifchughtai
Messages: 113
Registered: October 2007
Senior Member
you need to resize the datafile/tablespace size to get the space back
Re: how to delete data [message #276654 is a reply to message #276441] Thu, 25 October 2007 18:41 Go to previous message
uowzd01
Messages: 2
Registered: October 2007
Junior Member
thank you for the advice, now i see what the reason is.
Previous Topic: SQL query
Next Topic: dbms_scheduler - procedure with parameters
Goto Forum:
  


Current Time: Fri Dec 02 22:44:57 CST 2016

Total time taken to generate the page: 0.10985 seconds