Compacting Database

  • Thread starter Thread starter Jeremy
  • Start date Start date
J

Jeremy

Is there a way to compact the databases on a regular
basis? I have made some that run on a continual basis
querying an Oracle Database for Machine Status (running,
up, down, etc..). By the end of a day, this database goes
from 400K to about 200MB in size. And I have 5 of these
databases running simultaneously. It takes up a lot of
space on the network and if I move the database to the
local machine, they won't run due to a lockdown policy on
the computers. A definate Catch-22 here. If I can get
some help, that would be fantastic!

Thanks in advance!

Jeremy
 
Is there a way to compact the databases on a regular
basis? I have made some that run on a continual basis
querying an Oracle Database for Machine Status (running,
up, down, etc..). By the end of a day, this database goes
from 400K to about 200MB in size. And I have 5 of these
databases running simultaneously. It takes up a lot of
space on the network and if I move the database to the
local machine, they won't run due to a lockdown policy on
the computers. A definate Catch-22 here. If I can get
some help, that would be fantastic!
Click to expand...

You might want to check out FMS, Inc.'s Total Visual Agent:

http://www.fmsinc.com/products/agent/index.html
 
Back
Top