my problem is ..drive where ora 10g was installed is full now
wot i can do to enable more space in the drive ...
how can i delete undotablespaces....its size has increased alarmingly or any other way to tackle it
delete files n tell me which ones otherwise
can i attach any other disk n how can i give path to tht drive...
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.