Replies to This Discussion

Permalink Reply by Emmy Heal on June 18, 2013 at 3:45pm

You probably can't. Your best chance is to move all non-sys objects out and truncate your sys.aud$ table, then query dba_extents to find the last used block, and resize the datafile down to that.
Otherwise, hire a decent consultant.

• ▶ Reply

Permalink Reply by Alysha Robinette on June 18, 2013 at 3:46pm

HI
ACTUALLY I ALREADY TRUNCATED MY SYS.AUD$ FILE. (TRUNCATED 4GB DATA (NEARLY 3 CRORES ) ) BUT STILL MY SYSTEM DBF FILE SHOWS 6GB CAN RESIZE WITH RESIZE COMMAND

• ▶ Reply

Permalink Reply by Emmy Heal on June 18, 2013 at 3:46pm

I already told you what to do. So I'll repeat it:
Query dba_extents to find the last used block, and resize the datafile down to that.

To make it more obvioius:
Look up the definition of the dba_extents view, and write a query against it to show the last used block in your system tablespace datafile(s). If the last used block is fairly close to the end of the datafile, you will not be able to resize the file much. In that case, you'll need to relocate the objects. You probably are not capable of doing that safely yourself, so you'll have to ask for professional help.

• ▶ Reply

▶ Reply to Discussion