Change or switch undo tablespace in Oracle database

Originally posted on SunkupuliDBA:

Change or switch undo tablespace in Oracle database
How do I change the UNDO tablespace for my database and drop the old one? and the answer often is;  The complexity comes in if there were pending transactions in your old undo tablespace and you have already switched to the new one and when you try to drop the old one it says “Tablespace is in use”. It is not an easy task to drop the undo tablespace . Once I have to delete the undo tablespace due to some reason and i  find that it is not straight forward to delete the undo tablespace .
How to switch the database to a new UNDO tablespace and drop the old one
$ sqlplus / as sysdba
SQL> show parameter undo
NAME                                 TYPE…

View original 1,503 more words

libre office logo

Ubuntu 12.04 upgrade to libreoffice 4.1

Libreoffice is great open source authoring tool like MS-Office.

LibreOffice 4.1 comes with many changes, including Unity appmenu support, option to use Firefox Personas, better interoperability with DOCX and RTF documents, a new LibreOffice Impress Remote Android App and many other changes

LibreOffice can be installed in Ubuntu by using a a large archive of deb files that can be downloaded from, but the packages available in the PPA (or in the official repositories) come with some Ubuntu-specific tweaks – for instance, the LibreOffice debs downloaded from the LibreOffice website didn’t have built-in Ubuntu appmenu (global menu) support, at least in my test, while the packages in the PPA have this by default, even for Ubuntu 12.04. Another advantage of using a PPA is getting automatic updates / easier to upgrade to newer LibreOffice versions.

Upgrading Steps

sudo add-apt-repository ppa:libreoffice/libreoffice-4-1
sudo apt-get update
sudo apt-get upgrade
sudo apt-get dist-upgrade

Now  you have Libreoffice 4.1.

Hello World

Hello World!

As a developer I am starting my blog with “Hello World!” blog post.

In this blog you will find some of my knowledge tutorials tips and even my philosophy.

Thing related to computer and computers and software.

All of you are welcome to read comment conduct and share.