I was deleting a table and got log segment full error. I know how to add new log segment and did it before. But is there any other way to solve the problem? Can I use dump tran to release the space?
Here is my operation.
1> use isi_tst_db
1> delete from Trade_Hist
Space available in the log segment has fallen critically low in database
'isi_tst_db'. All future modifications to this database will be suspended until
the log is successfully dumped and space becomes available.
The transaction log in database isi_tst_db is almost full. Your transaction is
being suspended until space is made available in the log.
Then I tried dump tran but it doesn't work.
1> dump tran isi_tst_db with truncate_only
DUMP TRANSACTION for database 'isi_tst_db' could not truncate the log. Either extend the log using ALTER DATABASE ... LOG ON command or eliminate the oldest active transaction in database 'isi_tst_db' shown in syslogshold table.
Can any one advise?
BTW: The DB is set to 'trunc log on chkpt'