<div>
Here is a more complete statement:<br />
<br />
CREATE TABLESPACE manualsegs DATAFILE '/u02/oracle/data/lmtbsb01<wbr />.dbf' SIZE 50M<br />
&nbsp; &nbsp; EXTENT MANAGEMENT LOCAL <br />
&nbsp; &nbsp; SEGMENT SPACE MANAGEMENT AUTO;<br />
<br />
<br />
Here is the link for more information:<br />
<br />
<a href="http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/tspaces002.htm" rel="ugc">http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/tspaces002.htm</a>
</div>


<div>
<div class="content wysiwyg-content">
SQL&gt; create tablespace manualsegs segment space management manual;<br />
create tablespace manualsegs segment space management manual<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;*<br />
ERROR at line 1:<br />
ORA-02199: missing DATAFILE/TEMPFILE clause 
</div>
</div>


SQL> create tablespace manualsegs segment space management manual;
create tablespace manualsegs segment space management manual
                                                           *
ERROR at line 1:
ORA-02199: missing DATAFILE/TEMPFILE clause 

Here is a more complete statement:

CREATE TABLESPACE manualsegs DATAFILE &amp;#39;/u02/oracle/data/lmtbsb01.dbf&amp;#39; SIZE 50M
    EXTENT MANAGEMENT LOCAL 
    SEGMENT SPACE MANAGEMENT AUTO;


Here is the link for more information:

http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/tspaces002.htm

ora-error-02199

SQL&amp;gt; create tablespace manualsegs segment space management manual;
create tablespace manualsegs segment space management manual
                                                           *
ERROR at line 1:
ORA-02199: missing DATAFILE/TEMPFILE clause 

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.