>This solution was provided by UT to my problem of the ever increasing database.Worked.What drawback does it have.None seem to be apparent.Except the fact that I lose my.dbc file that also if it so happens because of this command.Any alternative. Please do help Urgent.Thank you

Neerja,

You are probably losing the DBC because some user exits the app and does not wait for the shu8t down to complete. A PACK leaves the file being packed vulnerable to loss until the PACK has completed.

As Craig said, there is no need to pack a DBC unless you are adding tables and views to it during runtime. If you are adding things to teh dbc at runtime, I would suggest that you consider using a temporary dbc for this stuff, create the database, put the temporary views adn tables in it and then when finished erase the dbc and the tables that were added to it.

PACKing is a dangerous operation and you should limit it to only those users who appreciate that during it the entire data is in jepordy.