2 Replies Latest reply: Jun 21, 2011 10:22 AM by Alain RSS

    bug?

    Alain
      SQL> create table superuser.ow tablespace abiec as select id from borabiec.abiec_history_owner pp where not exists(select id from borabiec.abiec_history where id=pp.id);

      Table created.

      SQL> create table superuser.do tablespace abiec as select id from borabiec.abiec_history_dog pp where not exists(select id from borabiec.abiec_history where id=pp.id);
      create table superuser.do tablespace abiec as select id from borabiec.abiec_history_dog pp where not exists(select id from borabiec.abiec_history where id=pp.id)
      *
      ERROR at line 1:
      ORA-01114: IO error writing block to file (block # )
      ORA-01114: IO error writing block to file 201 (block # 182846)
      ORA-27072: File I/O error
      Additional information: 4
      Additional information: 182846
      Additional information: 233472


      Can this be caused by exceeding allowed database size?
      My 11g xe database has 9 datafiles, where id is from 1 to 9.
      Can it be that file#201 is file# of the db from which I imported the table?

      Edited by: Alain on 21-juin-2011 7:47
        • 1. Re: bug?
          Udo
          Alain,

          could it be your disk is full?
          Otherwhise, you can check which file it is and if it is "full" by executing the following query:
          select file_name, tablespace_name, bytes, maxbytes
            from dba_data_files
           where file_id=201;
          I don't think it has something to do with your import. If you've hit the database size limit I'd expect a different error message, but we'll know more when you have the results of that query.

          -Udo
          • 2. Re: bug?
            Alain
            pls ignore thread the disk is full.