This discussion is archived
3 Replies Latest reply: Apr 15, 2013 4:06 AM by yoonas RSS

how to reduce space of .dbf

947771 Newbie
Currently Being Moderated
Hi,

i have data about 3 gb but my files in
e:\oraclexe\app\oracle\oradata\XE
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.

-----------------------
windows (2008)

---
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
PL/SQL Release 11.2.0.2.0 - Production
"CORE     11.2.0.2.0     Production"
TNS for 32-bit Windows: Version 11.2.0.2.0 - Production (2008)
NLSRTL Version 11.2.0.2.0 - Production

yours sincerely

Edited by: 944768 on Apr 14, 2013 5:47 AM

Edited by: 944768 on Apr 14, 2013 5:48 AM

Edited by: 944768 on Apr 14, 2013 5:48 AM

Edited by: 944768 on Apr 14, 2013 5:53 AM
  • 1. Re: how to reduce space of .dbf
    yoonas Expert
    Currently Being Moderated
    Hi,

    http://docs.oracle.com/cd/E11882_01/server.112/e10595/schema003.htm

    http://www.oracle-base.com/articles/misc/reclaiming-unused-space.php

    What is the total size of your datafiles?

    do you have backup or anyother files on e drive?

    Regards
    Yoonas
  • 2. Re: how to reduce space of .dbf
    947771 Newbie
    Currently Being Moderated
    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.

    total space taken by oraclexe is 28 gb.

    yours sincerely

    Edited by: 944768 on Apr 15, 2013 3:09 AM
  • 3. Re: how to reduce space of .dbf
    yoonas Expert
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points