Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

audit tablespace

don123Dec 19 2018 — edited Dec 20 2018

I have created separate tablespace for audit with autoextend on.

But i get following error. When i truncate sys.aud$, it is resolved. Why tablespace is not auto extending ?

ORA-02002: error while writing to audit trail ORA-00604:

error occurred at recursive SQL level 1 ORA-01653:

unable to extend table SYS.AUD$ by 8192 in tablespace AUDSYS

I checked following.

select tablespace_name, autoextensible, maxbytes/1024/1024/1024 "maxbytes" from dba_data_files where tablespace_name='AUDSYS';

AUDSYS YES 31.9999847412109375

Will the data file does not extend after 32 GB ? Can i change this value ?

This post has been answered by John Thorton on Dec 19 2018

Jump to Answer

Added on Dec 19 2018

#general-database-discussions

11 comments

1,120 views