ORA-01237: cannot extend datafile

[sandycrab]

Hi Friends...
I,m facing a problem which is very new to me.
I'm trying to join one table with some 1 million records with 4 master tables. Master table 1 and 2 having 150 records, master table 3 having 30 records and 4th one has 4 records.
When I execute the query I get following set of errors...

ORA-01237: cannot extend datafile 4
ORA-01110: data file 4: '/data/oracle/dbfiles/oradata/SCB/temp01.dbf'
ORA-19502: write error on file "/data/oracle/dbfiles/oradata/SCB/temp01.dbf", blockno 207841 (blocksize=8192)
ORA-27072: skgfdisp: I/O error
SVR4 Error: 25: Inappropriate ioctl for device
Additional information: 207841

I'm on Oracle 8.1.6 on Sun SPARC with Solaris 7.0...
Please help me on this front...

Thanks in advance
Sandy

[ggnanaraj]

Hi

You have to add another datafile for this temporary tablespace on a file system where you have space.

Cheers.

[sandycrab]

I tried to add one more datafile in temporary tablespace using-
alter tablespace temp add datafile 'DF_Name'
But it throws following error...

ORA-19502: write error on file "/data/oracle/dbfiles/oradata/SCB/temp02.dbf", blockno 1 (blocksize=8192)
ORA-27072: skgfdisp: I/O error
SVR4 Error: 25: Inappropriate ioctl for device
Additional information: 1

I'm not getting what is the problem...Any idea??

[ggnanaraj]

Did you check /var/adm/messages for OS level errors.

You have created the additional datafile in the same file system. Does that file system have sufficient space ?

[sandycrab]

oops...you are right...there is no space in my drive...
Thanks a lot...I'll fix it now...