01237. 00000 - "cannot extend datafile %s"
*cause : An Operating system error occured during the resize.
*Action : Fix the cause of the operating system error and retry the command
The error is self-explanatory. Your disk containing datafile does not have space. You can add the datafile to another drive which has space.
For reducing the size:
- create a temporary tablespace
- move all objects from current tablespace to newly created tablespace
- drop existing tablespace
- move back all the objects
Alternatively, you can also create another tablespace and move objects there and drop the existing one. Done.
Question now moved from SQL and PL/SQL to the Datebase - General Questions forum space, as it has nothing to do with the SQL or PL/SQL languages.
You need to create more space by dropping redundant files, or shrinking files.
I tried the suggested, but I am not able to create temporary tablespace, giving OS error .. there is not enough space on the disk;
Check if you have any obsolete backups , archivelogs which you can clear.
This is just a space issue, make room by deleting some files and that should help you.