Home » RDBMS Server » Server Administration » Droping a datafile from UNDO Segment (10g/Unix)
Droping a datafile from UNDO Segment [message #309706] Fri, 28 March 2008 09:20 Go to next message
liamadherne
Messages: 40
Registered: March 2008
Location: Philadelphia
Member
I recently i faced a space crunch in UNDO tablespace due to the export and i had to add 12GB datafile to it.

now as i can see the undo tablespace normally remains 50% free as earlier, so i wanted to drop that recently added datafile from undo tablespce.

Scenario is like:

I cannot afford to restart the instance.
I don't have enough space left to create the new UNDO segment of the required size and then drop the current undo segment.

Is there any other way around to accomplish the task.

Any suggestion are much appreciated.

Thanks
AL
Re: Droping a datafile from UNDO Segment [message #309712 is a reply to message #309706] Fri, 28 March 2008 09:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there any other way around to accomplish the task.

No, noone I'm aware of.

Regards
Michel

[Updated on: Fri, 28 March 2008 09:36]

Report message to a moderator

Re: Droping a datafile from UNDO Segment [message #309715 is a reply to message #309706] Fri, 28 March 2008 09:43 Go to previous messageGo to next message
liamadherne
Messages: 40
Registered: March 2008
Location: Philadelphia
Member
Thanks Micheal,

But i didn't get your answer.

Thanks
AL
Re: Droping a datafile from UNDO Segment [message #309735 is a reply to message #309715] Fri, 28 March 2008 11:10 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no other way than those you posted.

Regards
Michel
Previous Topic: Do I need Enterprise Edition or will SE suffice?
Next Topic: standby database goes down.
Goto Forum:
  


Current Time: Thu Dec 08 02:28:47 CST 2016

Total time taken to generate the page: 0.07487 seconds