i have data about 3 gb but my files in
has grown to 16 gb
1)my e: drive has less space ,pls tel how can i fee some space and give it back to OS
2)is there any other place where i can free up some space from oracle and give it back to OS.
Oracle Database 11g Express Edition Release 18.104.22.168.0 - Production
PL/SQL Release 22.214.171.124.0 - Production
"CORE 126.96.36.199.0 Production"
TNS for 32-bit Windows: Version 188.8.131.52.0 - Production (2008)
NLSRTL Version 184.108.40.206.0 - Production
1)size of datafiles is 16 gb which exist in XE folder including controlfile.
2)i have an old backup of 10 gb , but this is an old bakup after that i have reduced some space around 3 gb . so next bakup will be of less size. but there is few mb space available on my e: drive to take backup.
Hope you have gone through the links i had posted.
If you have only 3gb data from the 16gb you can reclaim unused space, see this link also http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:54178027703899
if you want to just free up some space on e drive move your back up to a different drive.