Go Back > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 58

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 8th December 2005, 21:06
tuple9i's Avatar
tuple9i tuple9i is offline
Join Date: Jul 2005
Posts: 36
tuple9i is on a distinguished road
Baan: 5c - DB: Oracle - OS: Win/*nix
Unhappy Help - Lost table data during reorganization

Ran into a bit of a problem. I have been playing with the TTAAD4225M000 session to reorganize various tables. The first set were tables that showed chaining and then I went to another set of tables with empty_blocks=0. The first set of tables reorganized perfectly. Problem:

when I did the first table in the set that showed empty_blocks=0 (Number of never used blocks in the table), the reorg process appeared to go well. It produced the R.{tablename} file, reorged the table and the R.{tablename} file released. Well, when I checked the table, it appears that the data within the table is gone!

Initial Statistics:

--------------- -------------- ----------- ---------- ---------- ----------
TWHINH200750 65536 361 0 46340 739

After reorg:

--------------- -------------- ----------- ---------- ---------- ----------
TWHINH200750 65536 0 0 0 0

The R.{tablename} file no longer exists. It dissappeared after the reorg process completed. Please note: there were no errors generated during the reorg process and the process was not interrupted.

Database: Oracle
BaaN: Porting set - 7.1d.03 (heavily modified)

Help! Luckily this is a test database/BaaN app, so I lost no production data, but I have planned on doing this in prod very soon.

Thanks for your input
Sometimes you are the windshield
Sometimes you are the bug

Last edited by tuple9i : 8th December 2005 at 21:17.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 05:38
Tables used for MRP and PRP. BurghMan Tools Development 1 10th February 2005 14:08
Should it not lead to data loss through table sharing ?? learner Tools Administration & Installation 6 30th December 2004 04:01
copy records c_siek Tools Development 9 18th June 2004 15:43

All times are GMT +2. The time now is 08:29.

©2001-2018 - -