This discussion is archived
7 Replies Latest reply: Jan 17, 2013 11:03 AM by Javier RSS

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

Javier Newbie
Currently Being Moderated
Any Ideas?

SQL> show parameter DB_CREATE

------------------------------------ ----------- ------------------------------
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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points