Originally posted by secureall
my problem is ..drive where ora 10g was installed is full now
Have you looked at you bdump and udump directories? How big is you r alert log. You can always rename then compress your alert log. Perhaps even move it to another volume. If it is large you should also see if there are messages that are filling up the file and address whatever condition that those are telling you about.

Do you keep your data on the same volume as the Oracle software? If so you may want to move it to a separate volume or several volumes depending on your hardware and you needs.