2 Replies Latest reply on Sep 23, 2008 11:13 AM by Pavan Kumar

    ORA-01119: error in creating database file

    Kashif Manzoor
      Hi,

      I am trying to run scripts adcrtbsp.sql but it is giving following error.

      adcrtbsp.sql script contains:

      --------------------------
      CREATE TABLESPACE
      APPS_TS_TX_DATA
      DATAFILE '?/dbf/transaction_table.dbf'
      SIZE 1000 M REUSE
      EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128 K
      SEGMENT SPACE MANAGEMENT AUTO ;

      ALTER TABLESPACE
      APPS_TS_TX_DATA
      add DATAFILE
      '?/dbf/transaction_table_2.dbf'
      SIZE 1000 M;

      ALTER TABLESPACE
      APPS_TS_TX_DATA
      add DATAFILE
      '?/dbf/transaction_table_3.dbf'
      SIZE 1000 M;

      CREATE TABLESPACE
      APPS_TS_TX_IDX
      DATAFILE '?/dbf/transaction_index.dbf'
      SIZE 1000 M REUSE
      EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128 K
      SEGMENT SPACE MANAGEMENT AUTO ;

      ALTER TABLESPACE
      APPS_TS_TX_IDX
      add DATAFILE
      '?/dbf/transaction_index_2.dbf'
      SIZE 1000 M;
      ------------------------------

      sqlplus system/pwd @adcrtbsp.sql

      --------------------------------------------------------------------------------
      CREATE TABLESPACE
      *
      ERROR at line 1:
      ORA-01119: error in creating database file 'f:/oracle/dbf/transaction_table.dbf'
      ORA-27040: skgfrcre: create error, unable to create file
      OSD-04002: unable to open file
      O/S-Error: (OS 3) The system cannot find the path specified.
      --------------------------------------------------------------------------------
      Anybody can guide ??