robert.c.cemper
Reputation: 181
How to shrink IRISTEMP db in runtime?
After running an extensive block of daily statistics my IRISTEMP
has expanded dramatically. But FreeSpace shows 97% unused and FREE space.
How can I shrink IRISTEMP in runtime without shutdown and manual intervention?
Upvotes: 1
Views: 185
Answers (1)
Danny Wijnschenk
Reputation: 26
What do you mean 'without manual intervention' ? You can shrink it with the database tools (Do ^DATABASE, option 13 (compact free space in a database) & option 12 (return free space for a database). But that is a 'manual' intervention. It will only happen automatically when you restart Iris.
Upvotes: 1
Related Questions
- SQL Server 2005 - how to shrink the tempdb
- How to implement truncate and load in target in informatica?
- Moving IRIS db in runtime?
- shrink a database in oracle 11g
- Best way to shrink database of oracle
- Remove Execution plan cache from Sybase IQ
- Where can I shrink database directly from Central admin (SharePoint2010)
- How to shrink user data file in oracle?
- oracle 10G shrink datafiles
- How to make Extensible Storage Engine Database Shrink? - the database should not have much data inside?