Any1 can help me solve a problem I have with tfgld106 file size. Its like this, the table has reached its size limitation so some fiscal year records were backed-up and then deleted. But still the table size stayed the same. Any1 have needed answers to this?

the table size does not change by simply removing the records. it's a database thing. the size is made up of the actual space and a reserved space. when you delete records your actual space occupied by your records lessens but it brings it to your reserved space. the bottomline is you will still have the same size after all. you need to ask your dba to shrink the database, meaning do a db maintenance to manage/shrink the reserved space.

Thanks Benito for your reply. But I just resolved the problem by creating a sequential dump of tfgld106 only and then create table from sequential dump to a test company. But takes sometime and the procedure worked. File size lessened and and number of records are same with the source. So next thing to do was to create table from the same dump file to the actual live company with option to delete table b4 loading. Now will test data integrity randomly.

hi, most baan admins can't do what you did because of the file size. i would be very extra careful in dropping a table from the live company. i would rather do all these in the database level using db tools.

Nice Job Biboie, you're great!!!

I would choose your method Biboie, excellent job dude.