<div>
Mattia,<br />
<br />
I use Oracle 8.0.6. &nbsp;Alter table sys.aud$ move tablespace &lt;new tablespace name&gt; is not a valid command. &nbsp;Can you check it for me?<br />
<br />
Thanks.<br />
<br />
DBFan<br />
<br />

</div>


Mattia,

I use Oracle 8.0.6.  Alter table sys.aud$ move tablespace <new tablespace name> is not a valid command.  Can you check it for me?

Thanks.

DBFan



<div>
Since you are using 8.0.6, you have to use the second option I mentioned above.<br />
<br />
Moving tables between table spaces is supported in Oracle 8i (8.1.5 and later) only.<br />
<br />
Hope this helps,<br />
--M.A<br />

</div>


Since you are using 8.0.6, you have to use the second option I mentioned above.

Moving tables between table spaces is supported in Oracle 8i (8.1.5 and later) only.

Hope this helps,
--M.A


<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
I plan to use Oracle Audit function to monitor the tables being updated or deleted. (Set Audit_trail=DB in initialaztion file).<br />
<br />
Since the Aud$ table is stored in system tablespace, frequently truncating &nbsp;the Aud$ table will cause system tablespace fragmentation and performance degrade. <br />
<br />
Can anyone tell me how to &nbsp;prevent this problem?<br />
<br />
Thanks.
</div>
</div>


Hi All,

I plan to use Oracle Audit function to monitor the tables being updated or deleted. (Set Audit_trail=DB in initialaztion file).

Since the Aud$ table is stored in system tablespace, frequently truncating  the Aud$ table will cause system tablespace fragmentation and performance degrade. 

Can anyone tell me how to  prevent this problem?

Thanks.

How to prevent system tablespace fragmentation when using Oracle Audit?

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.