ORA-01237: cannot extend datafile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-01237: cannot extend datafile

Hybrid View

  1. #1
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    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
    "Greatest Rewards come only with Greatest Commitments!"

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Hi

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

    Cheers.


  3. #3
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    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??
    "Greatest Rewards come only with Greatest Commitments!"

  4. #4
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    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 ?


  5. #5
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    oops...you are right...there is no space in my drive...
    Thanks a lot...I'll fix it now...
    "Greatest Rewards come only with Greatest Commitments!"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width