I am having this query that My db size is 20 GB & Undo tablespace size is 25 GB. and is getting full what will you do ?
Kindly share your views on it.
Thanks in advance.
No Comments Posted for this Article.
How much tablespace size and UNDO tablespace
Hi all, We have SAP ver 4.7 and Oracle 9.2.0 on Windows 2000. Recently we upgraded oracle version from 8.1.7 to 9.2.0 and we did database reorg also. While doing database reorg we...
How to Drop undo Tablespace
I create a new undo tablespace, then I want to drop the org undo ts and recreate is with a smaller size. However, after switching Ii am not always able to offline the org tablespace. I get an...