-
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
-
Hi
You have to add another datafile for this temporary tablespace on a file system where you have space.
Cheers.
-
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??
-
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 ?
-
oops...you are right...there is no space in my drive...
Thanks a lot...I'll fix it now...
