No, you can't!
Deleted records space cannot be take back. Only back-up and restore can do
that.
>From your example is not quite normal to have this difference between
database before backup and databse after restore.
Please take a look to your database statistic at:
Generation 1842
Page size 8192
ODS version 10.1
Oldest transaction 1834
Oldest active 1835
Oldest snapshot 1835
Next transaction 1836
If you have very big difference between oldest transaction and next
transaction it could be a problem with that. You never make a commit ... !!!
I'm not sure if this is best comparison but maybe someone else could correct
me.
Regards,
Paul
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf
> Of Sean
> Sent: Wednesday, March 28, 2007 6:13 PM
> To: [email protected]
> Subject: [Firebird-net-provider] reclaim space from deleted records
>
> Hi,
>
> I have a program deleting records frequently, but seems the database is
> not
> taking back the space used by the deleted records. The database grew up
> to
> 3GB after a period of time. After doing backup and restore, it became
> 60MB.
>
> Can I reclaim the space from deleted records programmatically?
>
> Thanks a lot!
> Sean
>
>
>
> -----------------------------------------------------------------------
> --
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVD
> EV
> _______________________________________________
> Firebird-net-provider mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
