Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 8th December 2005, 22:06
tuple9i's Avatar
tuple9i tuple9i is offline
Member
 
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:

TABLE_NAME INITIAL_EXTENT AVG_ROW_LEN CHAIN_CNT NUM_ROWS AVG_SPACE
--------------- -------------- ----------- ---------- ---------- ----------
TWHINH200750 65536 361 0 46340 739

After reorg:

TABLE_NAME INITIAL_EXTENT AVG_ROW_LEN CHAIN_CNT _ROWS AVG_SPACE
--------------- -------------- ----------- ---------- ---------- ----------
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 8.1.7.4
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
__________________
tuple9i
Sometimes you are the windshield
Sometimes you are the bug

Last edited by tuple9i : 8th December 2005 at 22:17.
Reply With Quote
  #2  
Old 8th December 2005, 22:38
dave_23's Avatar
dave_23 dave_23 is offline
Guru
 
Join Date: Oct 2002
Location: Portland, OR
Posts: 1,303
dave_23 will become famous soon enough
Baan: All - DB: Oracle / MS SQL / DB2 - OS: All
It looks like you're looking at dba_tables/user_tables to determine
# of rows..

do
select count(*) from <tablename>;

to see if they are really there.. if they are, then just run
analyze table <tablename> estimate statistics;

Dave
Reply With Quote
  #3  
Old 8th December 2005, 23:39
tuple9i's Avatar
tuple9i tuple9i is offline
Member
 
Join Date: Jul 2005
Posts: 36
tuple9i is on a distinguished road
Baan: 5c - DB: Oracle - OS: Win/*nix
Talking Worked like a charm

Thanks, worked like a charm. Appreciate the feedback.
__________________
tuple9i
Sometimes you are the windshield
Sometimes you are the bug
Reply With Quote
Sponsored Links
  #4  
Old 9th December 2005, 02:34
dave_23's Avatar
dave_23 dave_23 is offline
Guru
 
Join Date: Oct 2002
Location: Portland, OR
Posts: 1,303
dave_23 will become famous soon enough
Baan: All - DB: Oracle / MS SQL / DB2 - OS: All
Great news!

There's a "bug/design flaw" the oracle driver. Baan will automatically
estimate statistics for you on your tables after they are created (if you use 0214 in your ora_storage) but it's tied to index creation.

So, in your case, if you run reconfig without the "fast" option then Baan will create the table, create the indexes, generate statistics then load the data.. So your statistics are on a table with no data.

I logged a bug on this a year or so ago and i think it was fixed in Baan 5 and up, but it was too much for them to do it in Baan 4 (especally when there is an easy workaround)

Dave
Reply With Quote
  #5  
Old 12th December 2005, 16:11
tuple9i's Avatar
tuple9i tuple9i is offline
Member
 
Join Date: Jul 2005
Posts: 36
tuple9i is on a distinguished road
Baan: 5c - DB: Oracle - OS: Win/*nix
Thanks for the info. Good tip.
__________________
tuple9i
Sometimes you are the windshield
Sometimes you are the bug
Reply With Quote
Reply


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 06:38
Tables used for MRP and PRP. BurghMan Tools Development 1 10th February 2005 15:08
Should it not lead to data loss through table sharing ?? learner Tools Administration & Installation 6 30th December 2004 05:01
copy records c_siek Tools Development 9 18th June 2004 16:43


All times are GMT +2. The time now is 07:22.


©2001-2017 - Baanboard.com - Baanforums.com