How to avoid shrinking database with journal full? (DBMR3233)
Shrinking database could be rolled back, which meant your “shrink” operation required journal file, and the required size should be double of compressed data and BLOB. If the capacity of journal is not enough, you can shrink database with setting journal off. Open dmsqls with single user mode. Before you execute below commands, please backup database.
dmSQL> start db db_name sysadm;
dmSQL> set journal off;
dmSQL> shrink tablespace ts_name compressonly;
dmSQL> set journal on;
Version: 5.4.3
Product: Normal/Bundle
Platform: Windows/Linux