7 Replies Latest reply: Jan 17, 2013 1:03 PM by Javier RSS

    OMF enabled but still receiving ORA-02199: missing DATAFILE/TEMPFILE clause

    Javier
      Any Ideas?

      SQL> show parameter DB_CREATE

      NAME TYPE VALUE
      ------------------------------------ ----------- ------------------------------
      db_create_file_dest string /path/to/datafiles
      db_create_online_log_dest_1 string /path/to/redo

      SQL> create tablespace test;
      create tablespace test
      *
      ERROR at line 1:
      ORA-02199: missing DATAFILE/TEMPFILE clause


      Note this normally works but I ran into a problem with a script and pinpointed it to a problem with the system not recognizing that it should use OMF.

      - There is plenty of space on the filesystems