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
"Greatest Rewards come only with Greatest Commitments!"