Did you know that you can PACK tablename, PACK INDEX(s) in a live
multi-user environment?
Here's how ...
PACK tablename
Packing a single table when MULTI is set ON. This parameter is very
beneficial with databases that are always is use.
PACK INDEX
Use this option to PACK all indices for the currently connected
database. PACK INDEX is supported in multi-user environments.
PACK INDEX indexname
PACK INDEX indexname is now supported in multi-user environments.
This command will execute on the currently connected database.
PACK INDEX FOR tablename
Specifies a particular table whos indices you want to PACK
Have fun!
Razzak
At 09:39 AM 7/21/2017, Dan Goldberg wrote:
So I notice that my database will become corrupt when a table has a
number or large deletes and adds.
For example, I have a table that I store my bill of materials by
part# in by model year. It goes through the bom tree every night,
regenerates the list, deletes the old data, and inserts the new data.
Yesterday I had to run it 3 times as we are in model change. The
table became corrupt after the 3rd time.
Since it is a live database I cannot do a pack during the day. So is
there a way to pack an individual table?
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
