Database Software

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!

can I clear logfile ?

user6258915Sep 3 2012 — edited Sep 3 2012

In Timesten11g, I encoutered the following :

Command> truncate table TEST1;
778: Log write failed because filesystem is full
The command failed.

I know the disk is full :
[root@host1 ~]# df -k /timesten/
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda3 15304712 14515360 0 100% /

I only set path of DataStore, and not set LogDir in my DSN as following:
[ana_tt1122]
Driver=/timesten/TimesTen/tt1122/lib/libtten.so
DataStore=/timesten/TimesTen/tt1122/info/ana/ana
DatabaseCharacterSet=ZHS16GBK
ConnectionCharacterSet=ZHS16GBK

And my question is :1, How to find where the logfiles are ? 2, And how to clear them , can I remove them?
3, In using TT, I want to generate least amount of log size in logfile, can I do it ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 1 2012

Added on Sep 3 2012

#database-key-features, #timesten-in-memory-database

3 comments

261 views