Use the following script to know the free space ... http://www.dbasupport.com/oracle/scr...iled/84.shtml.

Now, use ALTER DATABASE DATAFILE '...' RESIZE command to get some free space.

Originally posted by seshib
databse is noarchive log mode..
Well, you don't need to worry about archivelogs then!

Originally posted by seshib

Filesystem kbytes used avail capacity Mounted on
/dev/dsk/c0t0d0s0 4129290 1849798 2238200 46% /
/proc 0 0 0 0% /proc
fd 0 0 0 0% /dev/fd
mnttab 0 0 0 0% /etc/mnttab
swap 1136296 24 1136272 1% /var/run
swap 1283360 147088 1136272 12% /tmp
/dev/md/dsk/d6 70562950 42135811 27721510 61% /home
/dev/md/dsk/d1 34993271 34162496 480843 99% /oradata01
/dev/md/dsk/d2 8171922 2194639 5895564 28% /common
/dev/md/dsk/d5 35009161 19483415 15175655 57% /addappl
/dev/md/dsk/d4 35009161 34659071 0 100% /oradata02
/dev/md/dsk/d0 53566120 15810285 37220174 30% /home/dbdump

This is the position...i have to create space on this...
If you have root access on the unix box, then go ahead and do the needful using the volume manager.

HTH.