<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I don't understand why this error is returned, I have checked the syntax on the oracle site :<br />
<br />
SQL&gt; ALTER TABLESPACE EXAMPLE SHRINK SPACE keep 20M;<br />
ALTER TABLESPACE EXAMPLE SHRINK SPACE keep 20M<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;*<br />
ORA-02142: missing or invalid ALTER TABLESPACE option<br />
<br />
Thanks<br />
<br />
Regards<br />
<br />
bibi
</div>
</div>


Hello,

I don't understand why this error is returned, I have checked the syntax on the oracle site :

SQL> ALTER TABLESPACE EXAMPLE SHRINK SPACE keep 20M;
ALTER TABLESPACE EXAMPLE SHRINK SPACE keep 20M
                         *
ORA-02142: missing or invalid ALTER TABLESPACE option

Thanks

Regards

bibi

shrink tbs

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.